Re: BUG #8056: postgres forgets hstore over time

Ok, after making my own functions and putting:=0A=0ASET search_path TO publ=
ic;=0A=0A=0AOn top, the errors seemed to have stopped. So it seems like thi=
s is an issue with the search_path being forgotten.=0A=0A=0A_______________=
_________________=0A From: Dickson S. Guedes <listas@guedesoft.net>=0ATo: k=
nowzerox@yahoo.com =0ACc: pgsql-bugs@postgresql.org =0ASent: Wednesday, Apr=
il 10, 2013 7:19 AM=0ASubject: Re: [BUGS] BUG #8056: postgres forgets hstor=
e over time=0A =0A=0A2013/4/9=A0 <knowzerox@yahoo.com>:=0A> The following b=
ug 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 kno=
wzerox@yahoo.com=0A> PostgreSQL version: 9.2.1=0A=0APlease update your Post=
gres to 9.2.4.=0A=0A> I have hstore installed on my server and it works fin=
e. But sometimes=0A> postgres would give me errors such as:=0A>=0A> type "h=
store" does not exist=0A=0ADid you check search_path? Compare search_path b=
etween sessions that=0Aare getting error and see if hstore type/functions a=
re reached through=0Ait.=0A=0A[]s=0A-- =0ADickson S. Guedes=0Amail/xmpp: gu=
edes@guedesoft.net - skype: guediz=0Ahttp://github.com/guedes - http://gued=
esoft.net=0Ahttp://www.postgresql.org.br