Postgres Pro
Downloads
Home   >   mailing lists

Re: Request: set opclass for generated unique and primary key indexes - Mailing list pgsql-hackers

From Pavel Stehule
Subject Re: Request: set opclass for generated unique and primary key indexes
Date
Msg-id BAY20-F105521FB4E6939825B1788F9F20@phx.gbl
Whole thread Raw
In response to Re: Request: set opclass for generated unique and primary  (Stephan Szabo <sszabo@megazone.bigpanda.com>)
Responses Re: Request: set opclass for generated unique and primary
List pgsql-hackers
Tree view 
>
>Right, but does the pattern_ops one have to be unique?
Sorry, I don't uderstand

>And if it does, do you need the normal unique constraint as well?
Sometime yes. It's about using natural or generated unique values.

I looked to source code and I propouse syntax:

CREATE TABLE name .. colname type PRIMARY KEY | UNIQUE [USING INDEX [TABLESPACE ...] [OPERATOR 
CLASS opclass]

CREATE CONSTRAINT name PRIMARY KEY | UNIQUE '(' colname opt_class, ....

I don't think so this need big patch.
What do you think?

Regards, nice a day
Pavel Stehule

_________________________________________________________________
Citite se osamele? Poznejte nekoho vyjmecneho diky Match.com. 
http://www.msn.cz/

pgsql-hackers by date:

Previous
From: "Qingqing Zhou"
Date:
Subject: Re: A doubt..
Next
From: Martijn van Oosterhout
Date:
Subject: Re: pg_config, pg_service.conf, postgresql.conf ....