Postgres Pro
Downloads
Home   >   mailing lists

Possible bug in 'set constraints all deferred'; - Mailing list pgsql-hackers

From David Jack Olrik
Subject Possible bug in 'set constraints all deferred';
Date
Msg-id 20000809145407.C19247@chrome.hashbang.net
Whole thread Raw
Responses Re: Possible bug in 'set constraints all deferred';
List pgsql-hackers
Tree view 
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!' ]
Attachment

pgsql-hackers by date:

Previous
From: Tatsuo Ishii
Date:
Subject: Re: Re: LIKE gripes
Next
From: "Michael Mayo"
Date:
Subject: Activating USE_SYSLOG from srpm?