From: | "David G(dot) Johnston" <david(dot)g(dot)johnston(at)gmail(dot)com> |
---|---|
To: | PegoraroF10 <marcos(at)f10(dot)com(dot)br> |
Cc: | pgsql-general <pgsql-general(at)postgresql(dot)org> |
Subject: | Re: Trigger bug ? |
Date: | 2019-05-22 22:45:09 |
Message-ID: | CAKFQuwYU9udU+uFrNZ8=wGSReci9OjfHFChqGqLJu9+84VJdfA@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
On Wed, May 22, 2019 at 3:41 PM PegoraroF10 <marcos(at)f10(dot)com(dot)br> wrote:
> I´m not saying it should inspect function code, but I think it should deny
> when I try to create a trigger missing a needed argument.
>
Guessing you missed my earlier response...
> When I do ...
> create table MyTable(integer);
> gives me an "syntax error at end of input" because I forgot field name.
>
> why when I do ...
> create trigger MyTrigger after insert on MyTable execute procedure
> MyFunction();
> It does not gives me something similar ?
>
CREATE [ CONSTRAINT ] TRIGGER name { BEFORE | AFTER | INSTEAD OF } { event
[ OR ... ] }
ON table_name
[ FROM referenced_table_name ]
[ NOT DEFERRABLE | [ DEFERRABLE ] [ INITIALLY IMMEDIATE | INITIALLY
DEFERRED ] ]
[ REFERENCING { { OLD | NEW } TABLE [ AS ] transition_relation_name } [
... ] ]
[ FOR [ EACH ] { ROW | STATEMENT } ]
[ WHEN ( condition ) ]
EXECUTE PROCEDURE function_name ( arguments )
The part about { ROW | STATEMENT } is within an optional clause.
David J.
From | Date | Subject | |
---|---|---|---|
Next Message | PegoraroF10 | 2019-05-22 22:49:58 | Re: Trigger bug ? |
Previous Message | Adrian Klaver | 2019-05-22 22:42:35 | Re: Trigger bug ? |