Skip site navigation (1) Skip section navigation (2)

Re: BUG #2101: Postmaster Crash Using PL/PgSQL With %TYPE on Non-Exisiting Column

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: "Will Szopko" <dba(at)vilaj(dot)com>
Cc: pgsql-bugs(at)postgresql(dot)org
Subject: Re: BUG #2101: Postmaster Crash Using PL/PgSQL With %TYPE on Non-Exisiting Column
Date: 2005-12-09 17:10:15
Message-ID: 29311.1134148215@sss.pgh.pa.us (view raw or flat)
Thread:
Lists: pgsql-bugs
"Will Szopko" <dba(at)vilaj(dot)com> writes:
> The postmaster in 8.1.0 crashes when creating or replacing a PL/PgSQL
> function containing an invalid variable declaration.

Looks like a copy-and-paste mistake...

Index: pl_comp.c
===================================================================
RCS file: /cvsroot/pgsql/src/pl/plpgsql/src/pl_comp.c,v
retrieving revision 1.94.2.1
diff -c -r1.94.2.1 pl_comp.c
*** pl_comp.c	22 Nov 2005 18:23:30 -0000	1.94.2.1
--- pl_comp.c	9 Dec 2005 16:56:38 -0000
***************
*** 1457,1463 ****
  done:
  	if (HeapTupleIsValid(classtup))
  		ReleaseSysCache(classtup);
! 	if (HeapTupleIsValid(classtup))
  		ReleaseSysCache(attrtup);
  	if (HeapTupleIsValid(typetup))
  		ReleaseSysCache(typetup);
--- 1457,1463 ----
  done:
  	if (HeapTupleIsValid(classtup))
  		ReleaseSysCache(classtup);
! 	if (HeapTupleIsValid(attrtup))
  		ReleaseSysCache(attrtup);
  	if (HeapTupleIsValid(typetup))
  		ReleaseSysCache(typetup);


			regards, tom lane

In response to

pgsql-bugs by date

Next:From: Bruce MomjianDate: 2005-12-09 17:18:49
Subject: Re: BUG #2100: CREATE TABLE AS - may not supply table specification
Previous:From: Tom LaneDate: 2005-12-09 16:41:26
Subject: Re: BUG #2102: Backend reports wrong number of affected rows for a table that uses rules

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group