=?UTF-8?B?VG9tw6HFoSBVa28=?= <uko@xxxxxxxxx> 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@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-admin
