[BUGS] 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: pgagari...@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; -- Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-bugs
[BUGS] SQLSTATE exception thrown from exception handling block prevents plpgsql function from compiling
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;
Re: [BUGS] BUG #5524: SQLSTATE exception thrown from exception handling block prevents plpgsql function from compiling
"Peter Gagarinov" 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 -- Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-bugs
Re: [BUGS] Postgres on AIX5.3 and AIX6.1
On Thu, Jun 24, 2010 at 11:02 PM, Robert Haas wrote: > On Thu, Jun 24, 2010 at 4:50 PM, Chris Browne wrote: >> alvhe...@commandprompt.com (Alvaro Herrera) writes: >>> Excerpts from Chris Browne's message of jue jun 24 14:40:30 -0400 2010: robertmh...@gmail.com (Robert Haas) writes: > This patch makes it clear that the workaround is no good on AIX 6.1, > but it doesn't seem quite clear about whether the underlying problem > has been fixed in AIX 6.1. It would be good to understand that. Better? >>> >>> Empty diff? >> >> Oops. Hopefully this is less empty. > > Yes. That seems pretty clear and unambiguous. Committed. -- Robert Haas EnterpriseDB: http://www.enterprisedb.com The Enterprise Postgres Company -- Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-bugs
