Re: truncate error

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: truncate error
Date: 2005-10-04 15:21:42
Message-ID: 20051004152142.GC6925@surnet.cl
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

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"

In response to

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Tom Lane 2005-10-04 15:35:10 Re: Vacuum Warning
Previous Message Jeff Frost 2005-10-04 15:03:33 Re: archive_command