From: | Tomáš Uko <uko(at)avast(dot)com> |
---|---|
To: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
Cc: | pgsql-admin(at)postgresql(dot)org |
Subject: | Re: Problem with extension |
Date: | 2016-09-22 12:09:01 |
Message-ID: | 4017414da2205610f2f2a6762b145f23@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-admin |
Hi Tom,
It worked!
XY=# create extension hstore from unpackaged;
CREATE EXTENSION
XY=# \dx
List of installed extensions
Name | Version | Schema | Description
-------------+---------+------------+--------------------------------------------------
adminpack | 1.0 | pg_catalog | administrative functions for
PostgreSQL
hll | 1.0 | public | type for storing hyperloglog data
hstore | 1.2 | public | data type for storing sets of (key,
value) pairs
pgstattuple | 1.0 | public | show tuple-level statistics
plpgsql | 1.0 | pg_catalog | PL/pgSQL procedural language
(5 rows)
Thanks for help.
T.
-----Original Message-----
From: Tom Lane [mailto:tgl(at)sss(dot)pgh(dot)pa(dot)us]
Sent: Thursday, September 22, 2016 1:37 PM
To: Tomáš Uko <uko(at)avast(dot)com>
Cc: pgsql-admin(at)postgresql(dot)org
Subject: Re: [ADMIN] Problem with extension
=?UTF-8?B?VG9tw6HFoSBVa28=?= <uko(at)avast(dot)com> writes:
> Recreating extension again via „CREATE EXTENSION“ doesn’t work XY=#
> CREATE EXTENSION hstore SCHEMA public;
> ERROR: type "hstore" already exists
> XY=# CREATE EXTENSION hstore;
> ERROR: type "hstore" already exists
Perhaps what you've got there is an hstore installation from before
extensions existed? Try "create extension hstore from unpackaged"
to update it.
> Another thing, when we try to add extesion with insert to pg_extension
> it gets OID far greater than any other:
> XY=# select *,pg_extension.oid from pg_extension;
When you don't know what you are doing, trying to fix it with manual surgery
on the system catalogs is a good way to make things worse.
regards, tom lane
From | Date | Subject | |
---|---|---|---|
Next Message | Hunley, Douglas | 2016-09-22 13:22:11 | Re: replication help ... |
Previous Message | Tom Lane | 2016-09-22 11:36:59 | Re: Problem with extension |