Re: Cannot find hstore operator - Mailing list pgsql-general

From David G. Johnston
Subject Re: Cannot find hstore operator
Date
Msg-id CAKFQuwbu7bHQq4ye0NenATY=gUG5AHaL2RDHQZ4h65Ssbn4tLQ@mail.gmail.com
Whole thread Raw
In response to Re: Cannot find hstore operator  (Dominique Devienne <ddevienne@gmail.com>)
Responses Re: Cannot find hstore operator
List pgsql-general
On Monday, January 24, 2022, Dominique Devienne <ddevienne@gmail.com> wrote:

After re-reading
https://www.postgresql.org/docs/14/sql-createfunction.html in light of
Tom's answer,
does that mean that our `SET search_path TO {0}, 'pg_temp'`
workaround, in the trigger below,
to not depend on the search_path at runtime:


The general trigger documentation is kind enough to point out that the sql language cannot be used to write trigger functions.

David J.

pgsql-general by date:

Previous
From: Umair Shahid
Date:
Subject: Proposed German Translation of Code of Conduct Policy
Next
From: Tom Dearman
Date:
Subject: tstzrange on large table gives poor estimate of expected rows