Re: Problems handling errors in PL/pgSQL

"Josh Berkus" <josh@agliodbs.com> writes:
> 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.

But how would KPSQL know what value the function might have returned?
Something fishy here ... did you check the postmaster log to see whether
an error is really being reported or not?
        regards, tom lane