Re: BUG #8056: postgres forgets hstore over time

You mean by running current_schemas(true) on that session?

So far I have remade the hstore functions into this and it seems to be working for now: (But this happens randomly after time so it might take a day or 2 to be sure this addresses the issue)

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;

________________________________
From: Dickson S. Guedes <listas(at)guedesoft(dot)net>
To: knowzerox(at)yahoo(dot)com
Cc: pgsql-bugs(at)postgresql(dot)org
Sent: Wednesday, April 10, 2013 7:19 AM
Subject: Re: [BUGS] BUG #8056: postgres forgets hstore over time

2013/4/9  <knowzerox(at)yahoo(dot)com>:
> The following bug has been logged on the website:
>
> Bug reference:      8056
> Logged by:          Eugene
> Email address:      knowzerox(at)yahoo(dot)com
> PostgreSQL version: 9.2.1

Please update your Postgres to 9.2.4.

> I have hstore installed on my server and it works fine. But sometimes
> postgres would give me errors such as:
>
> type "hstore" does not exist

Did you check search_path? Compare search_path between sessions that
are getting error and see if hstore type/functions are reached through
it.

[]s
--
Dickson S. Guedes
mail/xmpp: guedes(at)guedesoft(dot)net - skype: guediz
http://github.com/guedes - http://guedesoft.net
http://www.postgresql.org.br