Re: BUG #1266: Improper unique constraint / MVCCactivitieswithin - Mailing list pgsql-bugs

From Aleksey Fedorchenko
Subject Re: BUG #1266: Improper unique constraint / MVCCactivitieswithin
Date
Msg-id E1CBqNG-0007i2-Al@storage.ukr.net
Whole thread Raw
In response to Re: BUG #1266: Improper unique constraint / MVCCactivitieswithin  (Stephan Szabo <sszabo@megazone.bigpanda.com>)
List pgsql-bugs
> And in current sources, functions 2 and 3 error with foreign key
> violations rather than unique constraint violations.  If the constraint
> was deferred you'd still get the unique violations, but we're still
> looking to see which error is correct in that case.

Does it mean that scripts that i sent you yesterday works fine and their results are proper (in mean of proper reaction
onimproper user activities) and different from described by me in first letter? 

Its strange because i tuned SET CONSTRAINTS in different modes but it didn't take any effect - i still have same
results!

Did you apply any patches on your pgsql instance? Because i have 3 distribs (7.4.2/8.0.0b1/8.0.0b2) and all fails the
sameway. 

pgsql-bugs by date:

Previous
From: Michael Fuhr
Date:
Subject: Re: BUG #1274: Trigger sequence incorrect
Next
From: "Alexander Ternopolski"
Date:
Subject: Error on pg_dumpall (PG8.0 B2)