Postgres Pro
Downloads
Home   >   mailing lists

Re: Sometimes referential integrity seems not to work - Mailing list pgsql-sql

From Rod Taylor
Subject Re: Sometimes referential integrity seems not to work
Date
Msg-id 1075747450.308.100.camel@jester
Whole thread Raw
In response to Re: Sometimes referential integrity seems not to work  (Jan Wieck <JanWieck@Yahoo.com>)
List pgsql-sql
Tree view 
> 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.

pgsql-sql by date:

Previous
From: Jan Wieck
Date:
Subject: Re: Sometimes referential integrity seems not to work
Next
From: "scott.marlowe"
Date:
Subject: Re: Sometimes referential integrity seems not to work