Re: coalesce in execute crashes backend

pgsql-bugs@postgresql.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 ----