[Pkg-postgresql-private] Status of #66232 (TRUNCATE doesn't check REFERENCE clause)?

Oliver Elphick olly@lfix.co.uk
Sat, 27 Mar 2004 18:51:48 +0000


On Sat, 2004-03-27 at 18:36, Martin Pitt wrote:
> Hi!
> 
> Does anybody of you know whether this bug is still valid? It is really
> ancient and maybe it was fixed by intermediate versions. Can anybody
> write a small test (example db) for this?

Release 7.4.2:

junk=# truncate aa;
ERROR:  cannot truncate a table referenced in a foreign key constraint
DETAIL:  Table "bb" references "aa" via foreign key constraint "$1".