SQLSTATE exception thrown from exception handling block prevents plpgsql function from compiling

From: <pgagarinov(at)alliedtesting(dot)com>
To: <pgsql-bugs(at)postgresql(dot)org>
Subject: SQLSTATE exception thrown from exception handling block prevents plpgsql function from compiling
Date: 2010-06-25 13:31:52
Message-ID: A0AE235BEDFE7842B9118FA2B320499B4F537AF1F0@mail2a.alliedtesting.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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 ='test message';
END
$BODY$
LANGUAGE 'plpgsql' VOLATILE
COST 100;

Browse pgsql-bugs by date

  From Date Subject
Next Message Peter Gagarinov 2010-06-25 13:35:05 BUG #5524: SQLSTATE exception thrown from exception handling block prevents plpgsql function from compiling
Previous Message Robert Haas 2010-06-25 03:02:32 Re: Postgres on AIX5.3 and AIX6.1