From: | Bruce Momjian <maillist(at)candle(dot)pha(dot)pa(dot)us> |
---|---|
To: | David Mansfield <david(at)cobite(dot)com> |
Cc: | pgsql-ports(at)postgreSQL(dot)org |
Subject: | Re: [PORTS] Port Bug Report: calling notify in pl/pgsql proc causes core dump |
Date: | 1999-09-21 21:29:32 |
Message-ID: | 199909212129.RAA20689@candle.pha.pa.us |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-ports |
Can someone comment on this?
>
> >
> > Jan, this is yours.
> >
>
> Actually, I made a 'workaround' fix to this problem (after posting this
> bug report). I'll append the patch. I don't pretend to understand the
> internals of this system, but my guess is that a simple statement like
> 'notify xyz' went through the planner, got an spi_plan, but the 'plan
> list' was empty. So here's my patch, which may be fixing a symptom, not
> the cause, YMMV:
>
> --- pl_exec.c~ Wed May 26 03:07:39 1999
> +++ pl_exec.c Fri Jun 25 11:00:53 1999
> @@ -2482,6 +2482,10 @@
>
> plan = (Plan *) lfirst(spi_plan->ptlist);
>
> + /* it would seem as though plan can be null... --DAVID */
> + if (plan == NULL)
> + return;
> +
> /* ----------
> * 2. It must be a RESULT plan --> no scan's required
> * ----------
>
>
> >
> > >
> > > ============================================================================
> > > POSTGRESQL BUG REPORT TEMPLATE
> > > ============================================================================
> > >
> > >
> > > Your name : David Mansfield
> > > Your email address : david(at)cobite(dot)com
> > >
> > > Category : runtime: back-end
> > > Severity : serious
> > >
> > > Summary: calling notify in pl/pgsql proc causes core dump
> > >
> > > System Configuration
> > > --------------------
> > > Operating System : Linux 2.2.9
> > >
> > > PostgreSQL version : 6.5
> > >
> > > Compiler used : gcc 2.7.2.3
> > >
> > > Hardware:
> > > ---------
> > > RedHat 5.2
> > >
> > > Versions of other tools:
> > > ------------------------
> > > RedHat 5.2 standard
> > >
> > > --------------------------------------------------------------------------
> > >
> > > Problem Description:
> > > --------------------
> > > calling notify in pl/pgsql proc causes core dump
> > >
> > > --------------------------------------------------------------------------
> > >
> > > Test Case:
> > > ----------
> > > createdb bugs
> > > psql bugs
> > > \i /usr/src/postgresql-6.5/src/pl/plpgsql/src/mklang.sql
> > > create function a_func()
> > > returns
> > > char
> > > as
> > > 'begin
> > > notify my_listen;
> > > return \'a\';
> > > end;'
> > > language
> > > 'plpgsql'
> > > ;
> > > select a_func();
> > >
> > >
> > > --------------------------------------------------------------------------
> > >
> > > Solution:
> > > ---------
> > >
> > >
> > > --------------------------------------------------------------------------
> > >
> > >
> > >
> >
> >
> >
>
> --
> /==============================\
> | David Mansfield |
> | david(at)cobite(dot)com |
> \==============================/
>
>
--
Bruce Momjian | http://www.op.net/~candle
maillist(at)candle(dot)pha(dot)pa(dot)us | (610) 853-3000
+ If your life is a hard drive, | 830 Blythe Avenue
+ Christ can be your backup. | Drexel Hill, Pennsylvania 19026
From | Date | Subject | |
---|---|---|---|
Next Message | Bill Geddes | 1999-09-21 23:11:59 | Re: Installing PostgreSQL |
Previous Message | Bruce Momjian | 1999-09-21 20:57:53 | Re: [PORTS] Compile problems with 6.5 on RedHat 6.0 2.2.10 |