From: | Roman Neuhauser <neuhauser(at)sigpipe(dot)cz> |
---|---|
To: | pgsql-general <pgsql-general(at)postgresql(dot)org> |
Subject: | non-btree primary key |
Date: | 2006-02-25 19:22:06 |
Message-ID: | 20060225192206.GA34889@isis.sigpipe.cz |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
Hello,
looks like PostgreSQL (8.0/8.1) has no support for using
other-than-btree indexes for primary keys. Is there a (perhaps
un(der)documented) way to specify the index type?
Rationale: I'm trying to have PKs on a type that defines only the = and
<> operators, and would work with a hash-based PK. I know I could work
around it with a UNIQUE INDEX, but would like to avoid that for exactly
the reason described in the manual:
: Technically, PRIMARY KEY is merely a combination of UNIQUE and NOT
: NULL, but identifying a set of columns as primary key also provides
: metadata about the design of the schema, as a primary key implies
: that other tables may rely on this set of columns as a unique
: identifier for rows.
Please cc me on replies, I have problems with the postgresql.org
majordomo.
--
How many Vietnam vets does it take to screw in a light bulb?
You don't know, man. You don't KNOW.
Cause you weren't THERE. http://bash.org/?255991
From | Date | Subject | |
---|---|---|---|
Next Message | Karsten Hilbert | 2006-02-25 19:38:48 | Re: How to specify infinity for intervals ? |
Previous Message | Robert Treat | 2006-02-25 19:17:04 | Re: User groups |