Google Groups no longer supports new Usenet posts or subscriptions. Historical content remains viewable.
Dismiss
Having trouble installing/using extension modules
8 views
Skip to first unread message
Aviswa
Feb 1, 2015, 6:53:10 AM2/1/15
to
Hi
I "think" I did install extensions - cube, fuzzystrmatch and a few others as a postgres user(Ubuntu). When I said, "create extension cube", it went through - and didn't allow it again.
postgres=# create extension cube;
ERROR: extension "cube" already exists
postgres=#
Then on, when I changed user settings created the db "testdb"; and then tried a simple SELECT command, I get:
av@aviswa:~$ psql testdb -c "SELECT '1'::cube;"
ERROR: type "cube" does not exist
LINE 1: SELECT '1'::cube;
How do I be able to use cube through my session of psql.
Thank you
AV
I "think" I did install extensions - cube, fuzzystrmatch and a few others as a postgres user(Ubuntu). When I said, "create extension cube", it went through - and didn't allow it again.
postgres=# create extension cube;
ERROR: extension "cube" already exists
postgres=#
Then on, when I changed user settings created the db "testdb"; and then tried a simple SELECT command, I get:
av@aviswa:~$ psql testdb -c "SELECT '1'::cube;"
ERROR: type "cube" does not exist
LINE 1: SELECT '1'::cube;
How do I be able to use cube through my session of psql.
Thank you
AV
0 new messages