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