Extensions btree_gist and cube collide?
Hi.
When i add extensions: cube and btree_gist.
First extension installs, but second not.
There is a (spelled) error message:
ERROR: operator 6(oid,oid) already exists in operator's family gist_oid_ops
I try to install it in other schema, but i don't know how to use it.
--
------------
pasman
=?ISO-8859-2?Q?pasman_pasma=F1ski?= <pasman.p@gmail.com> writes:
When i add extensions: cube and btree_gist.
First extension installs, but second not.
There is a (spelled) error message:
ERROR: operator 6(oid,oid) already exists in operator's family gist_oid_ops
Hmm, works for me:
regression=# create extension cube;
CREATE EXTENSION
regression=# create extension btree_gist;
CREATE EXTENSION
What PG version is this? Are you starting from an empty database?
It could be the issue is from some pre-existing object and not the
two extensions themselves.
regards, tom lane
Hi.
I recreate database and a problem disapears.
Thanks.
------------
pasman
Import Notes
Resolved by subject fallback
Tom Lane wrote:
=?ISO-8859-2?Q?pasman_pasma=F1ski?=<pasman.p@gmail.com> writes:
When i add extensions: cube and btree_gist.
First extension installs, but second not.
There is a (spelled) error message:ERROR: operator 6(oid,oid) already exists in operator's family gist_oid_ops
Hmm, works for me:
FWIW, I saw this behavior when upgrading a 9.0 database (which had cube and
earthdistance installed, but no cube or earthdistance objects in the
database other than UDFs) and using the CREATE EXTENSION FROM unpackaged syntax.
Jay Levitt