From: | elein <elein(at)varlena(dot)com> |
---|---|
To: | Joe Conway <mail(at)joeconway(dot)com> |
Cc: | "Hackers (PostgreSQL)" <pgsql-hackers(at)postgresql(dot)org> |
Subject: | Re: statement level trigger causes pltcl, plpython SIGSEGV |
Date: | 2003-08-04 04:59:38 |
Message-ID: | 20030803215938.C25993@cookie |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-hackers pgsql-patches |
I thought that statement level triggers did not work yet.
Are they supposed to work in 7.4?
(But even if they don't work they shouldn't crash...)
elein
On Sun, Aug 03, 2003 at 08:04:11PM -0700, Joe Conway wrote:
> I was working on trigger support for PL/R and ran across this bug in my
> own code related to STATEMENT level triggers. I decided to try it in PL/Tcl:
>
> regression=# CREATE FUNCTION tcltrigfunc() RETURNS trigger AS '
> regression'# return OK
> regression'# ' LANGUAGE pltcl;
> CREATE FUNCTION
> regression=#
> regression=# CREATE TRIGGER tcltrig BEFORE INSERT OR UPDATE OR DELETE ON foo
> regression-# FOR EACH STATEMENT EXECUTE PROCEDURE tcltrigfunc();
> CREATE TRIGGER
> regression=# insert into foo values(11,'cat99',1.89);
> The connection to the server was lost. Attempting reset: Failed.
> connection pointer is NULL
> !>
>
> Hmm, same problem. Looks like PL/pgSQL does the right thing, but
> plpython will crash also. I don't think plperl supports triggers.
>
> I'll try to submit a patch later tonight or tomorrow morning if no one
> beats me to it.
>
> Joe
>
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 4: Don't 'kill -9' the postmaster
>
From | Date | Subject | |
---|---|---|---|
Next Message | Christopher Kings-Lynne | 2003-08-04 05:18:23 | DROP TYPE/DROP DOMAIN |
Previous Message | Larry Rosenman | 2003-08-04 03:07:10 | Re: Release changes |
From | Date | Subject | |
---|---|---|---|
Next Message | Joe Conway | 2003-08-04 05:45:06 | Re: [HACKERS] statement level trigger causes pltcl, plpython SIGSEGV |
Previous Message | Joe Conway | 2003-08-04 03:04:11 | statement level trigger causes pltcl, plpython SIGSEGV |