[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".