By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
438,710 Members | 1,960 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 438,710 IT Pros & Developers. It's quick & easy.

question

P: n/a
Hi
There is question. How can I set column varchar[] (array) as UNIQUE
(constraint)? (I need this to set foreign key, but for this to work
varchar[] must be primary key or unique).
I use pgadmin, and pgadmin answer: "Error: data type character varying[]
has no default operator class for access method "btree". You must
specify an operator class for the index or define a default operator
class for the data type" What should I do?

---------------------------(end of broadcast)---------------------------
TIP 4: Don't 'kill -9' the postmaster

Nov 12 '05 #1
Share this Question
Share on Google+
1 Reply


P: n/a
Alexandr S <sa***@in.crimea.ua> writes:
There is question. How can I set column varchar[] (array) as UNIQUE


You cannot, in any Postgres version before 7.4. There isn't support for
indexes on array columns before 7.4.

regards, tom lane

---------------------------(end of broadcast)---------------------------
TIP 9: the planner will ignore your desire to choose an index scan if your
joining column's datatypes do not match

Nov 12 '05 #2

This discussion thread is closed

Replies have been disabled for this discussion.