Re: how to catch the error in procedure ?

Поиск
Список
Период
Сортировка
От Robert Treat
Тема Re: how to catch the error in procedure ?
Дата
Msg-id 1074260995.29178.432.camel@camel
обсуждение исходный текст
Ответ на Re: how to catch the error in procedure ?  (Richard Huxton <dev@archonet.com>)
Список 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


В списке pgsql-general по дате отправления:

Предыдущее
От: Chris Gamache
Дата:
Сообщение: Re: Creating GUID
Следующее
От: David Garamond
Дата:
Сообщение: Re: Creating GUID