Postgres Pro
Downloads
Home   >   mailing lists

KEY or INDEX - Mailing list pgsql-novice

From tövis
Subject KEY or INDEX
Date
Msg-id 006801c54fc6$85b57db0$3401a8c0@mainxp
Whole thread Raw
Responses Re: KEY or INDEX
List pgsql-novice
Tree view
Hi All
Seem to be that I can not create KEY exclude PRIMARY and FOREIGN.
This means for one table I can create only one key.
All other, frequently used operations (browse, search) should use INDEX-es (may be unique).
Is these statemens are correct?
 
Best regards
    tövis
 

pgsql-novice by date:

Previous
From: tövis
Date:
Subject: Re: CONSTRAINT ... FOREIGN KEY
Next
From: Sean Davis
Date:
Subject: Re: CONSTRAINT ... FOREIGN KEY