Postgres Pro
Downloads
Home   >   mailing lists

TRUNCATE doesn't follow referential integrity - Mailing list pgsql-hackers

From Ondrej Palkovsky
Subject TRUNCATE doesn't follow referential integrity
Date
Msg-id Pine.LNX.4.20.0105191254210.4280-100000@ondra.debian.cz
Whole thread Raw
List pgsql-hackers
Tree view 
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!

pgsql-hackers by date:

Previous
From: Peter Eisentraut
Date:
Subject: Truncation of char, varchar, bit, varbit types
Next
From: Bruce Momjian
Date:
Subject: Re: Fix for tablename in targetlist