Re: [HACKERS] Cannot use all four trigger events at once - Mailing list pgsql-bugs

From Tom Lane
Subject Re: [HACKERS] Cannot use all four trigger events at once
Date
Msg-id 5780.1245279030@sss.pgh.pa.us
Whole thread Raw
In response to Cannot use all four trigger events at once  (Greg Sabino Mullane <greg@turnstep.com>)
Responses Re: [HACKERS] Cannot use all four trigger events at once  ("Greg Sabino Mullane" <greg@turnstep.com>)
List pgsql-bugs
Greg Sabino Mullane <greg@turnstep.com> writes:
> This was failing:
> CREATE TRIGGER foo
> AFTER INSERT OR UPDATE OR DELETE OR TRUNCATE
> ON foobar
> FOR EACH STATEMENT EXECUTE PROCEDURE baz();

> Turns out the parser wasn't set up to handle four different trigger
> event types.

Hmm, that's a problem ...

> Patch attached.

... but this patch doesn't come close to fixing it.  struct CreateTrigStmt
needs changes.  I kinda think the restriction to 4 (or whatever)
elements ought to go away altogether.
        regards, tom lane


pgsql-bugs by date:

Previous
From: Greg Sabino Mullane
Date:
Subject: Cannot use all four trigger events at once
Next
From: "Greg Sabino Mullane"
Date:
Subject: Re: [HACKERS] Cannot use all four trigger events at once