Yo primero hice truncate a la tabla derivada y luego a la tabla maestra y
PostgreSQL no me lo permitia, entonces hice DELETE sobre la tabla maestro y
si pudo borrar los registros, aun no se porque pasa eso.
From: Alvaro Herrera <alvherre@xxxxxxxxxxxxxx>
To: Sidar López Cruz <sidarlopez@xxxxxxxxxxx>
CC: pgsql-admin@xxxxxxxxxxxxxx
Subject: Re: truncate error
Date: Tue, 4 Oct 2005 11:21:42 -0400
On Tue, Oct 04, 2005 at 08:40:31AM -0600, Sidar López Cruz wrote:
> PostgreSQL 8.1 beta 2 raise error on truncating tables with foreign
keys,
> try this to see !!!
Hum, what were you trying to show us? Truncating tables with foreign
keys is supposed to work as long as you truncate the referenced table at
the same time.
--
Alvaro Herrera Valdivia, Chile ICBM: S 39º 49' 17.7", W 73º 14'
26.8"
"La felicidad no es mañana. La felicidad es ahora"
---------------------------(end of broadcast)---------------------------
TIP 1: if posting/reading through Usenet, please send an appropriate
subscribe-nomail command to majordomo@xxxxxxxxxxxxxx so that your
message can get through to the mailing list cleanly
_________________________________________________________________
MSN Amor: busca tu ½ naranja http://latam.msn.com/amor/
---------------------------(end of broadcast)---------------------------
TIP 6: explain analyze is your friend
