Re: BUG #11107: UPDATE violates table check constraint

From: Marko Tiikkaja <marko(at)joh(dot)to>
To: David G Johnston <david(dot)g(dot)johnston(at)gmail(dot)com>, pgsql-bugs(at)postgresql(dot)org
Subject: Re: BUG #11107: UPDATE violates table check constraint
Date: 2014-08-01 17:01:54
Message-ID: 53DBC802.7050205@joh.to
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

On 8/1/14 5:59 PM, David G Johnston wrote:
> Tom Lane-2 wrote
>> Sorry, but this check constraint has entirely undefined behavior, as does
>> any check constraint that refers to data rows other than the one that is
>> being checked.
>
> Which is why PostgreSQL has CREATE TRIGGER functionality...

Which does absolutely nothing to get rid of the race conditions.

.marko

In response to

Responses

Browse pgsql-bugs by date

  From Date Subject
Next Message David Johnston 2014-08-01 17:30:27 Re: BUG #11107: UPDATE violates table check constraint
Previous Message David G Johnston 2014-08-01 15:59:37 Re: BUG #11107: UPDATE violates table check constraint