Postgres Pro
Downloads
Home   >   mailing lists

Re: how to catch the error in procedure ? - Mailing list pgsql-general

From Richard Huxton
Subject Re: how to catch the error in procedure ?
Date
Msg-id 200401160941.16268.dev@archonet.com
Whole thread Raw
In response to how to catch the error in procedure ?  ("LitelWang" <wlxyk@vip.163.com>)
Responses Re: how to catch the error in procedure ?
List pgsql-general
Tree view 
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.

--
  Richard Huxton
  Archonet Ltd

pgsql-general by date:

Previous
From: Ritu Khetan
Date:
Subject: Newbie to Postgres - Urgent query
Next
From: David Garamond
Date:
Subject: Re: fixed-length row