Create initially deferred trigger syntax

Question

Please help get my head around trigger creation syntax

create trigger cool_trigger
    after insert or update
    on custom_object_reference
    deferrable initially deferred
    for each statement
    execute procedure do_something();

syntax error at or near "deferrable"

I am using PostgreSQL 9.6.7

Never used that defer thing but from the documentation, it sounds like you should either put DEFERRABLE or INITIALLY DEFERRED, not both - have you tried putting only one? — 404
– 404, Commented Apr 10, 2018 at 16:17

Laurenz Albe · Accepted Answer · 2018-04-10 16:22:33Z

11

Only a constraint trigger can be deferred, so you'll have to use

CREATE CONSTRAINT TRIGGER ...

As the documentation says, you can only do this for AFTER ROW triggers.

answered Apr 10, 2018 at 16:22

Laurenz Albe

257k22 gold badges312 silver badges388 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

Dmytro Starosud Over a year ago

Okay :( Then I have to look for some way to still do this (run code on commit if that table was changed).

Collectives™ on Stack Overflow

Create initially deferred trigger syntax

1 Answer 1

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related