Re: Problems handling errors in PL/pgSQL

Tom,

> This would clearly be a bug, but I cannot replicate the problem:
> 
> regression=# SELECT fn_save_order_details (7703, '{34,29,40}','{TRUE,
> TRUE, FALSE}');
> ERROR:  <unnamed> referential integrity violation - key referenced
> from order_details not found in orders
> regression=#

Always good to have you folks test something.  This does appear to be a
bug ... in KPSQL (the KDE GUI for PSQL), not in Postgres.  When I run it
through command-line PSQL, an error is returned; for some reason, KPSQL
returns the return value for the function and no error.

Grazie!

-Josh Berkus

______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