Re: Sometimes referential integrity seems not to work

From: Rod Taylor <pg(at)rbt(dot)ca>
To: Jan Wieck <JanWieck(at)Yahoo(dot)com>
Cc: Stephan Szabo <sszabo(at)megazone(dot)bigpanda(dot)com>, Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>, Enio Schutt Junior <enio(at)pmpf(dot)rs(dot)gov(dot)br>, pgsql-sql(at)postgresql(dot)org
Subject: Re: Sometimes referential integrity seems not to work
Date: 2004-02-02 18:44:10
Message-ID: 1075747450.308.100.camel@jester
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

> TRUNCATE cannot be used inside of a transaction, and since 7.3 it checks
> for foreign keys. So I guess Enio is getting but ignoring the error

In 7.4 truncate is transaction safe.

In response to

Browse pgsql-sql by date

  From Date Subject
Next Message Terry Lee Tucker 2004-02-02 22:38:06 Novice SQL Question
Previous Message scott.marlowe 2004-02-02 18:40:01 Re: Sometimes referential integrity seems not to work