Cause plpgsql's PERFORM to behave according to its documentation,

Tom Lane <tgl@sss.pgh.pa.us>

Commit: a056f14be0a22834b5fa7b90c0c5ea1ec42f2a29
Author: Tom Lane <tgl@sss.pgh.pa.us>
Date: 2001-05-28T19:33:24Z
Releases: 7.2.1
Cause plpgsql's PERFORM to behave according to its documentation,
which says that PERFORM will execute any SELECT query and discard the
result.  The former implementation would in fact raise an error if the
result contained more than one row or more than one column.

Also, change plpgsql's error-logging mechanism to emit the additional
messages about error location at NOTICE rather than DEBUG level.  This
allows them to be seen by the client without having to dig into the
postmaster log file (which may be nonexistent or inaccessible by the
client).

Files

PathChange+/−
doc/src/sgml/plsql.sgml modified +2 −5
src/pl/plpgsql/src/pl_exec.c modified +39 −14