KEY or INDEX

From: tövis <tovises(at)freemail(dot)hu>
To: "pgsql novice" <pgsql-novice(at)postgresql(dot)org>
Subject: KEY or INDEX
Date: 2005-05-03 09:57:31
Message-ID: 006801c54fc6$85b57db0$3401a8c0@mainxp
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-novice

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

Responses

Browse pgsql-novice by date

  From Date Subject
Next Message Sean Davis 2005-05-03 10:42:02 Re: CONSTRAINT ... FOREIGN KEY
Previous Message tövis 2005-05-03 09:49:10 Re: CONSTRAINT ... FOREIGN KEY