TRUNCATE doesn't follow referential integrity

From: Ondrej Palkovsky <xpalo03(at)vse(dot)cz>
To: pgsql-hackers(at)postgresql(dot)org
Subject: TRUNCATE doesn't follow referential integrity
Date: 2001-05-19 10:56:48
Message-ID: Pine.LNX.4.20.0105191254210.4280-100000@ondra.debian.cz
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
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!

Browse pgsql-hackers by date

  From Date Subject
Next Message Bruce Momjian 2001-05-19 12:09:00 Re: Fix for tablename in targetlist
Previous Message Peter Eisentraut 2001-05-19 10:33:40 Truncation of char, varchar, bit, varbit types