Run trigger with hstore function on writing

Question

I would like to insert to a Postgres table where ther is set up an trigger event with hstore function to write to another table. While running in common SQL client with "public" search_path, there is no problem.

I can't make it run in FME workspace, always getting an error:

ERROR:  function hstore(vfk.par) does not exist

where "vfk.par" is the table I'm writing to. I have tried to add search_path "public" setup in "SQL To Run Before Write" but with no luck. Any hints, please?

-------

EDIT: In another workspace with another schemas but with similar tasks it runs without errors as expected. The triggers with its functions are almost identical.

Page 1 / 1

So it was quite foolish mistake creating Postgres extension in other schema than "public". Recreating it in "public" worked.

Reply

albinepro · Accepted Answer

So it was quite foolish mistake creating Postgres extension in other schema than "public". Recreating it in "public" worked.

Reply

Community Stats

Sign up

An FME Account is required to contribute

Login to the community

An FME Account is required to contribute

Scanning file for viruses.

This file cannot be downloaded