Re: inserting new records without OIDs

From: Christopher Kings-Lynne <chriskl(at)familyhealth(dot)com(dot)au>
To: Andreas Pflug <pgadmin(at)pse-consulting(dot)de>
Cc: mdoggett(at)coas(dot)oregonstate(dot)edu, "[pgADMIN]" <pgadmin-support(at)postgresql(dot)org>
Subject: Re: inserting new records without OIDs
Date: 2004-02-18 04:46:47
Message-ID: 4032EE37.8040105@familyhealth.com.au
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

In response to

Responses

Browse pgadmin-support by date

  From Date Subject
Next Message Andreas Pflug 2004-02-18 10:12:57 Re: inserting new records without OIDs
Previous Message Adam H.Pendleton 2004-02-18 02:22:00 Re: connection dropping continued