From: | Sidar López Cruz <sidarlopez(at)hotmail(dot)com> |
---|---|
To: | pgsql-admin(at)postgresql(dot)org |
Subject: | FW: truncate error |
Date: | 2005-10-04 16:01:42 |
Message-ID: | BAY23-F106139BBD22CF2F37A02C8CE830@phx.gbl |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-admin |
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(at)alvh(dot)no-ip(dot)org>
>To: Sidar López Cruz <sidarlopez(at)hotmail(dot)com>
>CC: pgsql-admin(at)postgresql(dot)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(at)postgresql(dot)org so that your
> message can get through to the mailing list cleanly
_________________________________________________________________
MSN Amor: busca tu ½ naranja http://latam.msn.com/amor/
From | Date | Subject | |
---|---|---|---|
Next Message | Simon Riggs | 2005-10-04 16:09:55 | Re: archive_command |
Previous Message | Gaetano Mendola | 2005-10-04 15:51:58 | Re: archive_command |