Re: [BUGS] Postgres on AIX5.3 and AIX6.1

2010-06-25 Thread Robert Haas
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: > Th

Re: [BUGS] BUG #5524: SQLSTATE exception thrown from exception handling block prevents plpgsql function from compiling

2010-06-25 Thread Tom Lane
"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

[BUGS] SQLSTATE exception thrown from exception handling block prevents plpgsql function from compiling

2010-06-25 Thread pgagarinov
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

[BUGS] BUG #5524: SQLSTATE exception thrown from exception handling block prevents plpgsql function from compiling

2010-06-25 Thread Peter Gagarinov
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 handl