On Thu, Jul 5, 2012 at 1:56 AM, Craig Ringer <ring...@ringerc.id.au> wrote: > On 07/05/2012 02:05 AM, gary.ha...@gmail.com wrote: >> >> development=# create extension hstore; >> ERROR: type "hstore" already exists > > First, thanks for the info in the report. > > At a guess, it has the hstore data type in it from before the extension > system exists. You need to follow the upgrade instructions to convert it to > an extension.
what about adding a HINT there? something like "you probably need to use CREATE EXTENSION ... FROM unpackaged" -- Jaime Casanova www.2ndQuadrant.com Professional PostgreSQL: Soporte 24x7 y capacitación -- Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-bugs
