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
---------------------------(end of broadcast)--------------------------- TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]
