On Thu, Jul 5, 2012 at 1:56 AM, Craig Ringer <[email protected]> wrote: > On 07/05/2012 02:05 AM, [email protected] 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 ([email protected]) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-bugs
