Skip to main content
Solved

Run trigger with hstore function on writing

  • March 28, 2023
  • 1 reply
  • 18 views
albinepro
Supporter
Forum|alt.badge.img+7

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.

Best answer by albinepro

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

View original
Did this help you find an answer to your question?

1 reply

albinepro
Supporter
Forum|alt.badge.img+7
  • albineproSupporter
  • Author
  • Supporter
  • Best Answer
  • March 30, 2023

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

Reply


Helpful Members This Week

Community Stats

31,341
Posts
118,857
Replies
38,930
Members

Latest FME

Terms & ConditionsCookie settings

Cookie policy

We use cookies to enhance and personalize your experience. If you accept you agree to our full cookie policy. Learn more about our cookies.

 
Cookie 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.