Re: [BUGS] BUG #8056: postgres forgets hstore over time

2013-04-10 Thread E E
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

Re: [BUGS] BUG #8056: postgres forgets hstore over time

2013-04-22 Thread E E
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 To: knowze...@yahoo.com Cc: pgsql-bugs@postg