postgresql "instead of" error

Vote count:

0

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?

asked 46 secs ago

Alexander Capone

19