Re: BUG #8056: postgres forgets hstore over time

On 4/10/2013 11:01 AM, E E wrote:
>
> CREATE OR REPLACE FUNCTION accounts.myhstore_merge(myh hstore, mytext
> text[])
>   RETURNS hstore AS
> $BODY$BEGIN
> SET search_path TO public;
> RETURN myh || hstore(mytext);
>
> END;$BODY$
>   LANGUAGE plpgsql VOLATILE
>   COST 100;


public.hstore(...)    would have been much simpler than changing the
search_path, which is persistent to the connection and likely will
backfire if your apps are changing it to something else.



--
john r pierce                                      37N 122W
somewhere on the middle of the left coast