Re: coalesce in execute crashes backend

pgsql-bugs(at)postgresql(dot)org writes:
> coalesce in execute crashes backend

Try the attached patch to 7.1.2. I see Jan's already fixed this in
current sources, but not in the 7.1 branch ...

regards, tom lane

*** src/pl/plpgsql/src/pl_exec.c.orig Mon May 7 21:02:03 2001
--- src/pl/plpgsql/src/pl_exec.c Tue Jun 12 21:02:59 2001
***************
*** 3,9 ****
* procedural language
*
* IDENTIFICATION
! * $Header: /home/projects/pgsql/cvsroot/pgsql/src/pl/plpgsql/src/pl_exec.c,v 1.41.2.1 2001/05/08 01:02:03 tgl Exp $
*
* This software is copyrighted by Jan Wieck - Hamburg.
*
--- 3,9 ----
* procedural language
*
* IDENTIFICATION
! * $Header: /home/projects/pgsql/cvsroot/pgsql/src/pl/plpgsql/src/pl_exec.c,v 1.41.2.2 2001/06/13 01:02:59 tgl Exp $
*
* This software is copyrighted by Jan Wieck - Hamburg.
*
***************
*** 1922,1930 ****
ObjectIdGetDatum(typeStruct->typelem),
Int32GetDatum(-1)));

- if (!typeStruct->typbyval)
- pfree((void *) query);
-
ReleaseSysCache(typetup);

/*
--- 1922,1927 ----
***************
*** 2037,2045 ****
query,
ObjectIdGetDatum(typeStruct->typelem),
Int32GetDatum(-1)));
-
- if (!typeStruct->typbyval)
- pfree((void *) query);

ReleaseSysCache(typetup);

--- 2034,2039 ----