Problem with updating hstore extension from 9.2 to 9.3

Started by Murat Kabilovover 12 years ago2 messagesgeneral
Jump to latest
#1Murat Kabilov
kabilovmf@gmail.com

Hello,

I've just upgraded my database from 9.2.2 to 9.3.0 using pg_upgrade.
Besides I've updated hstore extension ("alter extension hstore update").
But I can't find new to 9.2 hstore functions such as "hstore_to_json" in my
database.

I found out that file "contrib/hstore/hstore.control" of pg 9.3 is
identical to 9.2 one. And there is no file like "hstore--1.1--1.2.sql".

Is there a miss of update files for hstore?

Thanks in advance.

--
Regards
Murat Kabilov

#2Bruce Momjian
bruce@momjian.us
In reply to: Murat Kabilov (#1)
Re: Problem with updating hstore extension from 9.2 to 9.3

On Wed, Sep 25, 2013 at 07:29:30PM +0400, Murat Kabilov wrote:

Hello,

I've just upgraded my database from 9.2.2 to 9.3.0 using pg_upgrade. Besides
I've updated hstore extension ("alter extension hstore update").
But I can't find new to 9.2 hstore functions such as "hstore_to_json" in my
database.

I found out that file "contrib/hstore/hstore.control" of pg 9.3 is identical to
9.2 one. And there is no file like "hstore--1.1--1.2.sql".

Is there a miss of update files for hstore?

This is fixed in 9.3.1; upgrade to that, and read the release notes on
how to fix hstore.

--
Bruce Momjian <bruce@momjian.us> http://momjian.us
EnterpriseDB http://enterprisedb.com

+ Everyone has their own god. +

--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general