Skip site navigation (1) Skip section navigation (2)

Re: inserting new records without OIDs

From: Andreas Pflug <pgadmin(at)pse-consulting(dot)de>
To: mdoggett(at)coas(dot)oregonstate(dot)edu
Cc: "[pgADMIN]" <pgadmin-support(at)postgresql(dot)org>
Subject: Re: inserting new records without OIDs
Date: 2004-02-17 17:15:16
Message-ID: (view raw, whole thread or download thread mbox)
Lists: pgadmin-support
Matt Doggett wrote:

>Ooops. I sent this yesterday to the wrong maillist address. Sorry. I'll
>repost here.
>-----Original Message-----
>When I create a new table that does not have OIDs (the Has OIDs checkbox
>is off and I'm using a serial column type to id my records), then I
>CANNOT insert new data records using the Edit Data window.  There is no
>blank row (with an asterisk *) in which to enter new data.  In other
>words, I've discovered that you MUST use OIDs to be able to insert new
>records with the Edit window.
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!


In response to


pgadmin-support by date

Next:From: Markus WollnyDate: 2004-02-17 17:17:46
Subject: Re: connection dropping continued
Previous:From: Matt DoggettDate: 2004-02-17 16:53:34
Subject: inserting new records without OIDs

Privacy Policy | About PostgreSQL
Copyright © 1996-2017 The PostgreSQL Global Development Group