Re: BUG #8056: postgres forgets hstore over time

From: "Dickson S(dot) Guedes" <listas(at)guedesoft(dot)net>
To: knowzerox(at)yahoo(dot)com
Cc: pgsql-bugs(at)postgresql(dot)org
Subject: Re: BUG #8056: postgres forgets hstore over time
Date: 2013-04-10 11:19:45
Message-ID: CAHHcreqv+Nu9+71G1eRb8JODCqR12w1sM9QA-wRuELeRC6O-cA@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

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

In response to

Responses

Browse pgsql-bugs by date

  From Date Subject
Next Message Kyotaro HORIGUCHI 2013-04-10 13:38:07 Re: replication_timeout not effective
Previous Message Dang Minh Huong 2013-04-10 09:57:41 Re: replication_timeout not effective