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

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