Roman Neuhauser <[EMAIL PROTECTED]> writes:
> 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?
No --- at present this is not possible because btree is the only index
type that implements uniqueness checking. If that got fixed, we might
consider adding syntax to allow PK specification of index type.
regards, tom lane
---------------------------(end of broadcast)---------------------------
TIP 9: In versions below 8.0, the planner will ignore your desire to
choose an index scan if your joining column's datatypes do not
match
