Christopher Kings-Lynne <[EMAIL PROTECTED]> writes:
>> Thank you for your help. I found that an implicit index is created for
>> the primary key in the current version. However, it is not done in 7.x
>> version.
> It absolutely is created in all 7.x versions of PostgreSQL.
And every other version too. PRIMARY KEY/UNIQUE syntax was not
supported before this patch:
1997-12-04 18:07 thomas
* src/backend/parser/: analyze.c, gram.y: Add SQL92-compliant
syntax for constraints. Implement PRIMARY KEY and UNIQUE clauses
using indices.
and in that patch and every subsequent version, unique constraints are
associated with indexes. In fact, we do not even *have* any
implementation method for unique constraints other than the duplicate-
entry-detection code in the btree index AM.
regards, tom lane
---------------------------(end of broadcast)---------------------------
TIP 2: Don't 'kill -9' the postmaster
