On 07/05/2012 10:18 PM, Jaime Casanova wrote:
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"
Yeah, I suggested that. It's not trivial to make sure that this is
really because of the extension and not because the user just happened
to create their own type called "hstore" (or whatever the
type(s)/function(s) the ext provides) are, but I guess with a hint you
don't have to. I'm assuming if it were simple it would've been done as
part of extension implementation. It's certainly way beyond me.
--
Craig Ringer
--
Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-bugs
