TRUNCATE doesn't follow referential integrity
Ondrej Palkovsky <xpalo03@vse.cz>
From: Ondrej Palkovsky <xpalo03@vse.cz>
To: pgsql-hackers@postgresql.org
Date: 2001-05-19T10:56:48Z
Lists: pgsql-hackers
I tried to do a TRUNCATE on a table that was referenced by other table and the refererential integrity wasn't kept. Seems to me this thing behaves really differently then DELETE FROM table. I think it should be at least mentioned in the docs or disabled if the table is referenced by foreign key. Ondrej -- As President I have to go vacuum my coin collection!