Possible bug in 'set constraints all deferred';

From: David Jack Olrik <david(at)olrik(dot)dk>
To: pgsql-hackers(at)postgresql(dot)org
Subject: Possible bug in 'set constraints all deferred';
Date: 2000-08-09 12:54:10
Message-ID: 20000809145407.C19247@chrome.hashbang.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

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(at)olrik(dot)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!' ]

Attachment Content-Type Size
bug.sql text/plain 1.0 KB

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Michael Mayo 2000-08-09 13:14:05 Activating USE_SYSLOG from srpm?
Previous Message Tatsuo Ishii 2000-08-09 12:45:13 Re: Re: LIKE gripes