| From: | Don Baccus <dhogaza(at)pacifier(dot)com> |
|---|---|
| To: | "Mikheev, Vadim" <vmikheev(at)SECTORBASE(dot)COM> |
| Cc: | "'Holger Krug'" <hkrug(at)rationalizer(dot)com>, pgsql-hackers(at)postgresql(dot)org |
| Subject: | Re: ON ERROR triggers |
| Date: | 2002-01-07 19:52:27 |
| Message-ID: | 3C39FC7B.90708@pacifier.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| 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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Tom Lane | 2002-01-07 21:07:40 | Re: ecpg compile error on AIX |
| Previous Message | Tom Lane | 2002-01-07 19:41:07 | Re: again on index usage |