Christopher Kings-Lynne wrote:
>> Not true. Currently, you need either OID *or* a primary key.
>> Obviously, that id column should get a pk.
>> We'll extend the grid some time, to accept any other unique keys
>> also. Still, defining a PK on every table is best practice.
>> Defining a column as serial does *not* guarantee it's unique!
>
>
> Remember that unique indexes can have multiple NULL values.
Shhh, didn't think of that. So we won't ever accept unique indices for this.
> Also, oids are not guaranteed unique.
AFAICS this only happens on wrap around, i.e. hopefully never. Being
strict, we shouldn't rely on oid uniqueness, but in practice hopefully
nobody will ever notice.
Regards,
Andreas