Thread: BUG #5524: SQLSTATE exception thrown from exception handling block prevents plpgsql function from compiling

The following bug has been logged online:

Bug reference:      5524
Logged by:          Peter Gagarinov
Email address:      pgagarinov@alliedtesting.com
PostgreSQL version: 9.0 Beta 2
Operating system:   Windows XP Professional SP2
Description:        SQLSTATE exception thrown from exception handling block
prevents plpgsql function from compiling
Details:

The following function doesn’t seem to compile in PostgreSQL 9.0 while 8.4
accepts it with no problem.

CREATE OR REPLACE FUNCTION test.delete_sessions()
  RETURNS void AS
$BODY$
BEGIN
select 1;
EXCEPTION WHEN SQLSTATE '55P03' THEN
               RAISE SQLSTATE '55P03' using MESSAGE ='test message';
END
$BODY$
  LANGUAGE 'plpgsql' VOLATILE
  COST 100;

"Peter Gagarinov" <pgagarinov@alliedtesting.com> writes:
> The following function doesn’t seem to compile in PostgreSQL 9.0 while 8.4
> accepts it with no problem.

Fixed, thanks for the report!

            regards, tom lane