Re: Problems handling errors in PL/pgSQL

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: "Josh Berkus" <josh(at)agliodbs(dot)com>
Cc: pgsql-sql(at)postgresql(dot)org
Subject: Re: Problems handling errors in PL/pgSQL
Date: 2001-04-24 00:19:13
Message-ID: 24459.988071553@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

"Josh Berkus" <josh(at)agliodbs(dot)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

In response to

Responses

Browse pgsql-sql by date

  From Date Subject
Next Message Thomas F. O'Connell 2001-04-24 00:26:00 using top-level aggregate values in subqueries
Previous Message Josh Berkus 2001-04-24 00:15:43 Re: Problems handling errors in PL/pgSQL