On Wed, May 22, 2019 at 3:21 PM PegoraroF10 <marcos@xxxxxxxxxx> wrote:
Try to create exactly what I sent you and you´ll see null values on that pk.
You should probably submit self-contained examples if you need the user to do this.
And that occurs just because that trigger was created without EACH
ROW/STATEMENT.
So, my question is, PG should return an error and not create that trigger
because ROW/STATEMENT was not specified, correct ?
PostgreSQL doesn't inspect the called function to see if it is written correctly for a given invocation of CREATE TRIGGER. So, no, given that your command was syntactically valid PostgreSQL doesn't have any reason to return an error.
David J.
