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 information technology [EMAIL PROTECTED]
and data management solutions (415) 565-7293
for law firms, small businesses fax 621-2533
and non-profit organizations. San Francisco
---------------------------(end of broadcast)---------------------------
TIP 6: Have you searched our list archives?
http://www.postgresql.org/search.mpl
