Re: 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