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
Views: Raw Message | Whole Thread | Download mbox | Resend email
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

Browse pgsql-bugs by date

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