Re: BUG #1266: Improper unique constraint / MVCCactivitieswithin

From: "Aleksey Fedorchenko" <alexey_f(at)ukr(dot)net>
To: "Stephan Szabo" <sszabo(at)megazone(dot)bigpanda(dot)com>
Cc: pgsql-bugs(at)postgresql(dot)org
Subject: Re: BUG #1266: Improper unique constraint / MVCCactivitieswithin
Date: 2004-09-27 07:56:42
Message-ID: E1CBqNG-0007i2-Al@storage.ukr.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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 on improper 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 same way.

In response to

Responses

Browse pgsql-bugs by date

  From Date Subject
Next Message Stephan Szabo 2004-09-27 14:43:36 Re: BUG #1266: Improper unique constraint / MVCCactivitieswithin
Previous Message Tom Lane 2004-09-27 03:45:42 Re: Dollar quoting inside a regex bracket expression