Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Error create extention rum #1

Closed
andreak opened this issue May 29, 2016 · 10 comments
Closed

Error create extention rum #1

andreak opened this issue May 29, 2016 · 10 comments

Comments

@andreak
Copy link

andreak commented May 29, 2016

andreak=# create extension rum ;
ERROR:  operator <-> already exists

andreak=# select version();
                                                   version                                                   
-------------------------------------------------------------------------------------------------------------
 PostgreSQL 9.6beta1 on x86_64-pc-linux-gnu, compiled by gcc (Ubuntu 5.3.1-14ubuntu2) 5.3.1 20160413, 64-bit

@za-arthur
Copy link
Contributor

Hello. What extensions did you installed, except rum?
You can see list of the installed extensions by using \dx command on psql.

@andreak
Copy link
Author

andreak commented May 29, 2016

andreak=# \dx
                                     List of installed extensions
    Name    | Version |   Schema   |                            Description                            
------------+---------+------------+-------------------------------------------------------------------
 btree_gin  | 1.0     | public     | support for indexing common datatypes in GIN
 btree_gist | 1.1     | public     | support for indexing common datatypes in GiST
 pg_trgm    | 1.2     | public     | text similarity measurement and index searching based on trigrams
 plpgsql    | 1.0     | pg_catalog | PL/pgSQL procedural language
(4 rows)

@obartunov
Copy link

On Sun, May 29, 2016 at 10:11 PM, Andreas Joseph Krogh <
notifications@github.com> wrote:

andreak=# \dx
List of installed extensions
Name | Version | Schema | Description
------------+---------+------------+-------------------------------------------------------------------
btree_gin | 1.0 | public | support for indexing common datatypes in GIN
btree_gist | 1.1 | public | support for indexing common datatypes in GiST

bum, btree_gist !

pg_trgm | 1.2 | public | text similarity measurement and index searching based on trigrams
plpgsql | 1.0 | pg_catalog | PL/pgSQL procedural language
(4 rows)


You are receiving this because you are subscribed to this thread.
Reply to this email directly, view it on GitHub
#1 (comment), or mute
the thread
https://github.com/notifications/unsubscribe/AGFI4omqkBnbbt035RtoEuNPRksRGDkKks5qGeTJgaJpZM4IpQGj
.

@akorotkov
Copy link
Contributor

Yes, it appears that btree_gist also contains "timestamp <-> timestamp".

@andreak
Copy link
Author

andreak commented May 30, 2016

Will this be fixed so that it doesn't clash with btree_gist? I depend upon btree_gist for exclusion-constraints so I really cannot remove it.

@obartunov
Copy link

On Mon, May 30, 2016 at 9:15 PM, Andreas Joseph Krogh <
notifications@github.com> wrote:

Will this be fixed so that it doesn't clash with btree_gist? I depend upon
btree_gist for exclusion-constraints so I really cannot remove it.

yes, it should be fixed.


You are receiving this because you commented.
Reply to this email directly, view it on GitHub
#1 (comment), or mute
the thread
https://github.com/notifications/unsubscribe/AGFI4oFmKKLEbwfnGkeOAJPBbI54QIxmks5qGylVgaJpZM4IpQGj
.

@andreak
Copy link
Author

andreak commented May 30, 2016

Supercool!

@za-arthur
Copy link
Contributor

Thank you for the issue! Operator <-> was renamed to <=>.

@andreak
Copy link
Author

andreak commented Aug 2, 2016

Tested it, and it works great now, thanks!

@golgote
Copy link

golgote commented Sep 15, 2021

FYI, <=> now is incompatible with smlar extension...

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
None yet
Projects
None yet
Development

No branches or pull requests

5 participants