From: Tomáš Uko <uko@avast.com>
To: Tom Lane <tgl@sss.pgh.pa.us>
Cc: pgsql-admin@postgresql.org
Subject: Re: Problem with extension
Date: Thu, 22 Sep 2016 14:09:01 +0200
Message-ID: <4017414da2205610f2f2a6762b145f23@mail.gmail.com> (raw)
In-Reply-To: <14201.1474544219@sss.pgh.pa.us>
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>
List-Unsubscribe: <mailto:majordomo@postgresql.org?body=unsub%20pgsql-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@sss.pgh.pa.us]
Sent: Thursday, September 22, 2016 1:37 PM
To: Tomáš Uko <uko@avast.com>
Cc: pgsql-admin@postgresql.org
Subject: Re: [ADMIN] Problem with extension
=?UTF-8?B?VG9tw6HFoSBVa28=?= <uko@avast.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
--
Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-admin
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-admin@postgresql.org
Cc: uko@avast.com, tgl@sss.pgh.pa.us
Subject: Re: Problem with extension
In-Reply-To: <4017414da2205610f2f2a6762b145f23@mail.gmail.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox