From: =?UTF-8?B?VG9tw6HFoSBVa28=?= <uko@avast.com>
References: 
 <CANYp5wr3cPWZ9QvW1CMn-LtK=7orR=JUdPUndivNM_QrC+0TNQ@mail.gmail.com>
 <CANUg7LBybkWvuMr8dM+bM6hExmQ8Lmv3++_+48_PCLy1qh06rA@mail.gmail.com>
 <05172a3859cb6805b368084dfd015dbc@mail.gmail.com>
 <c02d9c97c1a7ba62c221625bf063907d@mail.gmail.com>
 <14201.1474544219@sss.pgh.pa.us>
In-Reply-To: <14201.1474544219@sss.pgh.pa.us>
MIME-Version: 1.0
Thread-Index: AQJeZc6q4p7G23ZWufj/ZOJoeizsWAJCsalDAuAQpvIDTWZHGwFoetKunx4DCmA=
Date: Thu, 22 Sep 2016 14:09:01 +0200
Message-ID: <4017414da2205610f2f2a6762b145f23@mail.gmail.com>
Subject: Re: Problem with extension
To: Tom Lane <tgl@sss.pgh.pa.us>
Cc: pgsql-admin@postgresql.org
Content-Type: text/plain; charset=UTF-8
Content-Transfer-Encoding: quoted-printable
Precedence: bulk
Sender: pgsql-admin-owner@postgresql.org

Hi Tom,

It worked!
XY=3D# create extension hstore from unpackaged;
CREATE EXTENSION
XY=3D# \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@sss.pgh.pa.us]
Sent: Thursday, September 22, 2016 1:37 PM
To: Tom=C3=A1=C5=A1 Uko <uko@avast.com>
Cc: pgsql-admin@postgresql.org
Subject: Re: [ADMIN] Problem with extension

=3D?UTF-8?B?VG9tw6HFoSBVa28=3D?=3D <uko@avast.com> writes:
> Recreating extension again via =E2=80=9ECREATE EXTENSION=E2=80=9C doesn=
=E2=80=99t work XY=3D#
> CREATE EXTENSION hstore SCHEMA public;
> ERROR:  type "hstore" already exists
> XY=3D# 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=3D# 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


--=20
Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-admin