Re: ON ERROR triggers - Mailing list pgsql-hackers

From Don Baccus
Subject Re: ON ERROR triggers
Date
Msg-id 3C39FC7B.90708@pacifier.com
Whole thread Raw
In response to Re: ON ERROR triggers  ("Mikheev, Vadim" <vmikheev@SECTORBASE.COM>)
List pgsql-hackers
Mikheev, Vadim wrote:


> 2. Not sure about CHECK constraints but Uniq/PrimaryKey ones are not
>    deferrable currently -:( And this is muuuuuch worse drawback then absence
>    of comprehensive reports. It's more complex thing to do than on error
>    triggers but someday it will be implemented because of this is "must
> have"
>    kind of things.


At some point they need to be deferred to statement end so

update t set foo = foo + 1;

works ...


-- 
Don Baccus
Portland, OR
http://donb.photo.net, http://birdnotes.net, http://openacs.org



pgsql-hackers by date:

Previous
From: Tom Lane
Date:
Subject: Re: again on index usage
Next
From: Tom Lane
Date:
Subject: Re: ecpg compile error on AIX