Horton

Re: ON ERROR triggers

Don Baccus <dhogaza@pacifier.com>

View thread
From: Don Baccus <dhogaza@pacifier.com>
To: "Mikheev, Vadim" <vmikheev@SECTORBASE.COM>
Cc: "'Holger Krug'" <hkrug@rationalizer.com>, pgsql-hackers@postgresql.org
Date: 2002-01-07T19:52:27Z
Lists: 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