Re: Problems handling errors in PL/pgSQL

Поиск
Список
Период
Сортировка
От Josh Berkus
Тема Re: Problems handling errors in PL/pgSQL
Дата
Msg-id web-43221@davinci.ethosmedia.com
обсуждение исходный текст
Ответ на Re: Problems handling errors in PL/pgSQL  ("Joe Conway" <jconway2@home.com>)
Список pgsql-sql
Joe,

> I'm not sure if this is what you're looking for, but in 7.1 you can
> do
> something like:
> 
>     INSERT INTO bar(barpk,foopk) VALUES(barpkval,foopkval);
>     GET DIAGNOSTICS rows = ROW_COUNT;
>     -- do something based on rows --

There's several other ways I can check, as well.  However, I was hoping
for some way to avoid adding anything to a couple of dozen functions
which are already debugged.

-Josh 

P.S. Does anyone yet have full documentation on GET DIAGNOSICS?
Roberto?

______AGLIO DATABASE SOLUTIONS___________________________                                      Josh Berkus Complete
informationtechnology      josh@agliodbs.com  and data management solutions       (415) 565-7293 for law firms, small
businesses       fax 621-2533   and non-profit organizations.      San Francisco
 


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

Предыдущее
От: "Joe Conway"
Дата:
Сообщение: Re: Problems handling errors in PL/pgSQL
Следующее
От: Tom Lane
Дата:
Сообщение: Re: pg_dump bug? (7.1)