Postgres Pro
Downloads
Home   >   mailing lists

Re: Trigger bug ? - Mailing list pgsql-general

From David G. Johnston
Subject Re: Trigger bug ?
Date
Msg-id CAKFQuwYH5u0b29X23Dad1ZTvgm=J2mAEh83Nz6Yrf4aiWB_ARw@mail.gmail.com
Whole thread Raw
In response to Trigger bug ?  (PegoraroF10 <marcos@f10.com.br>)
List pgsql-general
Tree view
On Wed, May 22, 2019 at 2:33 PM PegoraroF10 <marcos@f10.com.br> wrote:
We forgot FOR EACH ROW/STATEMENT when created our trigger.

On docs it´s written {ROW/STATEMENT} between {}, so it´s needed. But why did
it accepted our command to create that trigger ?

You only partially absorbed the syntax doc for that...in full it reads:

...
[ FOR [ EACH ] { ROW | STATEMENT } ]

You omitted the whole thing which is allowed.

David J.

pgsql-general by date:

Previous
From: Adrian Klaver
Date:
Subject: Re: Trigger bug ?
Next
From: Perumal Raj
Date:
Subject: Re: Centos : Load Average :OS Process Name : migration/1, migration/2, migration/n