Skip to main content
  • EN

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.

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

Reply


Community Stats

30,123
Posts
114,335
Replies
37,752
Members
Terms & ConditionsCookie settings
A product of
Safe Software respectfully acknowledges that we live, learn and work on the traditional and unceded territories of the Kwantlen, Katzie, and Semiahmoo First Nations.