Re: inserting new records without OIDs - Mailing list pgadmin-support

From Christopher Kings-Lynne
Subject Re: inserting new records without OIDs
Date
Msg-id 4032EE37.8040105@familyhealth.com.au
Whole thread Raw
In response to Re: inserting new records without OIDs  (Andreas Pflug <pgadmin@pse-consulting.de>)
Responses Re: inserting new records without OIDs
List pgadmin-support
> 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.  Also, oids 
are not guaranteed unique.

Chris


pgadmin-support by date:

Previous
From: Adam H.Pendleton
Date:
Subject: Re: connection dropping continued
Next
From: Andreas Pflug
Date:
Subject: Re: inserting new records without OIDs