Possible bug in 'set constraints all deferred';

David Jack Olrik <david@olrik.dk>

From: David Jack Olrik <david@olrik.dk>
To: pgsql-hackers@postgresql.org
Date: 2000-08-09T12:54:10Z
Lists: pgsql-hackers

Attachments

Hi,

I think I have found a bug in the handeling of 'deferred
contraints'. I have attached a small sql script that reproduces the
error.

The first transaction succedes, but the second one failes with
'psql:bug.sql:58: ERROR:  <unnamed> referential integrity violation -
key in p still referenced from c'

Isn't it supposed succed just like the first one ??

-- 
Best regards,
David Jack Olrik <david@olrik.dk>     http://david.olrik.dk
GnuPG key C290 0A4A 0CCC CBA8 2B37 E18D 01D2 F6EF 2E61 9894
[ GNU Software: 'The source will be with you ... Always!' ]