| From: | Robert Treat <xzilla(at)users(dot)sourceforge(dot)net> |
|---|---|
| To: | Richard Huxton <dev(at)archonet(dot)com> |
| Cc: | wlxyk(at)vip(dot)163(dot)com, pgsql-general <pgsql-general(at)postgresql(dot)org> |
| Subject: | Re: how to catch the error in procedure ? |
| Date: | 2004-01-16 13:49:54 |
| Message-ID: | 1074260995.29178.432.camel@camel |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
On Fri, 2004-01-16 at 04:41, Richard Huxton wrote:
> On Friday 16 January 2004 04:50, LitelWang wrote:
> > I need catch the error when my insert clause violate the
> > primary key .How to write in the server function ?
> > Thanks for any advice .
>
> You can't (at the moment). An error terminates a transaction immediately in
> PG's current model.
>
Didn't someone say this could be implemented in some of the other
pl's... plpython maybe? Or maybe they were using dblink to make a
separate connection/query... ?
Robert Treat
--
Build A Brighter Lamp :: Linux Apache {middleware} PostgreSQL
| From | Date | Subject | |
|---|---|---|---|
| Next Message | David Garamond | 2004-01-16 13:56:10 | Re: Creating GUID |
| Previous Message | Chris Gamache | 2004-01-16 13:40:06 | Re: Creating GUID |