Re: pl/pgsql and error handling

Поиск
Список
Период
Сортировка
От Bart Degryse
Тема Re: pl/pgsql and error handling
Дата
Msg-id 47C7C5D3.A3DD.0030.0@indicator.be
обсуждение исходный текст
Ответ на Re: pl/pgsql and error handling  (Alex Hochberger <alex@dsgi.us>)
Список pgsql-sql
<a
href="http://www.postgresql.org/docs/8.2/static/plpgsql-control-structures.html#PLPGSQL-ERROR-TRAPPING">www.postgresql.org/docs/8.2/static/plpgsql-control-structures.html#PLPGSQL-ERROR-TRAPPING</a>
wouldbe the place to look.<br /><br />>>> Alex Hochberger <alex@dsgi.us> 2008-02-29 6:29 >>><br
/>Ido not know.  It's sounds like the Oracle PL/SQL behavior is what I  <br />want.  Does PostgreSQL's pl/pgsql have
sucha feature?  It's not in  <br />the documentation anywhere.  I'll check it from the office tomorrow.<br /><br
/>Alex<br/><br />On Feb 28, 2008, at 11:43 PM, Tom Lane wrote:<br /><br />> Alex Hochberger <alex@dsgi.us>
writes:<br/>>> Is it possible to grab access to the actually user-friendly error<br />>> message?<br
/>><br/>> Doesn't the SQLERRM variable do what you want?<br />><br />> regards, tom lane<br />><br
/>>---------------------------(end of  <br />> broadcast)---------------------------<br />> TIP 4: Have you
searchedour list archives?<br />><br />>               <a
href="http://archives.postgresql.org/">http://archives.postgresql.org</a><br/><br /><br
/>---------------------------(endof broadcast)---------------------------<br />TIP 7: You can help support the
PostgreSQLproject by donating at<br /><br />                <a
href="http://www.postgresql.org/about/donate">http://www.postgresql.org/about/donate</a><br/> 

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

Предыдущее
От: Alex Hochberger
Дата:
Сообщение: Re: pl/pgsql and error handling
Следующее
От: "Professor Flávio Brito"
Дата:
Сообщение: Function returns error (view) (RESOLVED)