postgresql "instead of" error

Question

I had this issue before, but couldnt formulate my question properly.

This is my trigger creation in postgresql

  CREATE TRIGGER mytrigger
      INSTEAD OF UPDATE
      ON schemename.viewname
      FOR EACH ROW
      EXECUTE PROCEDURE schemename.functioninthisschemename();

This thing works if i do it on local test database, but on server it throws me error:

ERROR: syntax error at or near "INSTEAD" LINE 2: INSTEAD OF UPDATE

Can you please explain me, why i get this error?

Gordon Linoff · Accepted Answer · 2014-06-02 11:33:56Z

0

My guess is that this is a versioning issue in Postgres.

Postgres 9.1 supports "instead of" triggers. See here.

Postgres 9.0 and earlier do not support "instead of" triggers. See here.

answered Jun 2, 2014 at 11:33

Gordon Linoff

1.3m62 gold badges706 silver badges857 bronze badges

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

2 Comments

Alexander Capone Over a year ago

looks fair... how do i make trigger for a view then?

Gordon Linoff Over a year ago

@AlexanderCapone . . . That functionality is not supported prior to Postgres 9.1. Here is another question on the subject: stackoverflow.com/questions/451096/execute-trigger-on-view.

Collectives™ on Stack Overflow

postgresql "instead of" error

1 Answer 1

2 Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

2 Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related