SQLSTATE exception thrown from exception handling block prevents plpgsql function from compiling - Mailing list pgsql-bugs

From
Subject SQLSTATE exception thrown from exception handling block prevents plpgsql function from compiling
Date
Msg-id A0AE235BEDFE7842B9118FA2B320499B4F537AF1F0@mail2a.alliedtesting.com
Whole thread Raw
List pgsql-bugs
PostgreSQL 9.0 Beta2, Windows XP Professional SP2.

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 =3D'test message';
END
$BODY$
  LANGUAGE 'plpgsql' VOLATILE
  COST 100;

pgsql-bugs by date:

Previous
From: "Peter Gagarinov"
Date:
Subject: BUG #5524: SQLSTATE exception thrown from exception handling block prevents plpgsql function from compiling
Next
From: Tom Lane
Date:
Subject: Re: BUG #5524: SQLSTATE exception thrown from exception handling block prevents plpgsql function from compiling