On Thu, Jul 5, 2012 at 1:56 AM, Craig Ringer <ringerc@ringerc.id.au> wrote:
> On 07/05/2012 02:05 AM, gary.haran@gmail.com wrote:
>>
>> development=3D# 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"
--=20
Jaime Casanova www.2ndQuadrant.com
Professional PostgreSQL: Soporte 24x7 y capacitaci=F3n