> -----Original Message-----
> From: Andreas Pflug [mailto:[EMAIL PROTECTED] 
> Sent: 18 February 2004 10:13
> To: Christopher Kings-Lynne
> Cc: [EMAIL PROTECTED]; [pgADMIN]
> Subject: Re: [pgadmin-support] inserting new records without OIDs
> 
> 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.

Unique + not null should be OK, but only if the data was inserted with
that constraint in place.

> > 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.

<grin>

Regards, Dave.

---------------------------(end of broadcast)---------------------------
TIP 7: don't forget to increase your free space map settings

Reply via email to