FW: truncate error
От
Sidar López Cruz
Тема
FW: truncate error
Дата
Msg-id
BAY23-F106139BBD22CF2F37A02C8CE830@phx.gbl
Ответ на
Re: truncate error (Alvaro Herrera)
Список
Дерево обсуждения
truncate error Sidar López Cruz <sidarlopez@hotmail.com>
Re: truncate error Alvaro Herrera <alvherre@alvh.no-ip.org>
FW: truncate error Sidar López Cruz <sidarlopez@hotmail.com>
Re: FW: truncate error Alvaro Herrera <alvherre@alvh.no-ip.org>
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 >To: Sidar López Cruz >CC: pgsql-admin@postgresql.org >Subject: Re: [ADMIN] 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@postgresql.org so that your > message can get through to the mailing list cleanly _________________________________________________________________ MSN Amor: busca tu ½ naranja http://latam.msn.com/amor/
В списке pgsql-admin по дате отправления