Re: BUG #8056: postgres forgets hstore over time

You mean by running current_schemas(true) on that session?=0A=0A=0ASo 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 b=
e sure this addresses the issue)=0A=0ACREATE OR REPLACE FUNCTION accounts.m=
yhstore_merge(myh hstore, mytext text[])=0A=A0 RETURNS hstore AS=0A$BODY$BE=
GIN=0ASET search_path TO public;=0ARETURN myh || hstore(mytext);=0A=0AEND;$=
BODY$=0A=A0 LANGUAGE plpgsql VOLATILE=0A=A0 COST 100;=0A=0A=0A_____________=
___________________=0A From: Dickson S. Guedes <listas@guedesoft.net>=0ATo:=
 knowzerox@yahoo.com =0ACc: pgsql-bugs@postgresql.org =0ASent: Wednesday, A=
pril 10, 2013 7:19 AM=0ASubject: Re: [BUGS] BUG #8056: postgres forgets hst=
ore over time=0A =0A2013/4/9=A0 <knowzerox@yahoo.com>:=0A> The following bu=
g has been logged on the website:=0A>=0A> Bug reference:=A0 =A0 =A0 8056=0A=
> Logged by:=A0 =A0 =A0 =A0 =A0 Eugene=0A> Email address:=A0 =A0 =A0 knowze=
rox@yahoo.com=0A> PostgreSQL version: 9.2.1=0A=0APlease update your Postgre=
s to 9.2.4.=0A=0A> I have hstore installed on my server and it works fine. =
But sometimes=0A> postgres would give me errors such as:=0A>=0A> type "hsto=
re" does not exist=0A=0ADid you check search_path? Compare search_path betw=
een sessions that=0Aare getting error and see if hstore type/functions are =
reached through=0Ait.=0A=0A[]s=0A-- =0ADickson S. Guedes=0Amail/xmpp: guede=
s@guedesoft.net - skype: guediz=0Ahttp://github.com/guedes - http://guedeso=
ft.net=0Ahttp://www.postgresql.org.br