From: Tom Lane <tgl@sss.pgh.pa.us>
To: Tomáš Uko <uko@avast.com>
Cc: pgsql-admin@postgresql.org
Subject: Re: Problem with extension
Date: Thu, 22 Sep 2016 07:36:59 -0400
Message-ID: <14201.1474544219@sss.pgh.pa.us> (raw)
In-Reply-To: <c02d9c97c1a7ba62c221625bf063907d@mail.gmail.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>
List-Unsubscribe: <mailto:majordomo@postgresql.org?body=unsub%20pgsql-admin>
=?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: tgl@sss.pgh.pa.us, uko@avast.com
Subject: Re: Problem with extension
In-Reply-To: <14201.1474544219@sss.pgh.pa.us>
* 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