| From: | Jaime Casanova <jaime(at)2ndquadrant(dot)com> |
|---|---|
| To: | Craig Ringer <ringerc(at)ringerc(dot)id(dot)au> |
| Cc: | gary(dot)haran(at)gmail(dot)com, pgsql-bugs(at)postgresql(dot)org |
| Subject: | Re: BUG #6718: Cannot delete, create or check existence of extension |
| Date: | 2012-07-05 14:18:11 |
| Message-ID: | CAJKUy5gXrMYVbMQJdnjbfqT+-0+mSLOLeGKfP_x2khR++Fztnw@mail.gmail.com |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-bugs |
On Thu, Jul 5, 2012 at 1:56 AM, Craig Ringer <ringerc(at)ringerc(dot)id(dot)au> wrote:
> On 07/05/2012 02:05 AM, gary(dot)haran(at)gmail(dot)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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Craig Ringer | 2012-07-05 15:09:39 | Re: BUG #6718: Cannot delete, create or check existence of extension |
| Previous Message | Bruce Momjian | 2012-07-05 13:32:53 | Re: BUG #6706: pg_upgrade fails when plpgsql dropped/re-created |