Ok, after making my own functions and putting: SET search_path TO public;
On top, the errors seemed to have stopped. So it seems like this is an issue with the search_path being forgotten. ________________________________ From: Dickson S. Guedes <lis...@guedesoft.net> To: knowze...@yahoo.com Cc: pgsql-bugs@postgresql.org Sent: Wednesday, April 10, 2013 7:19 AM Subject: Re: [BUGS] BUG #8056: postgres forgets hstore over time 2013/4/9 <knowze...@yahoo.com>: > The following bug has been logged on the website: > > Bug reference: 8056 > Logged by: Eugene > Email address: knowze...@yahoo.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: gue...@guedesoft.net - skype: guediz http://github.com/guedes - http://guedesoft.net http://www.postgresql.org.br
