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: | 40324C24.604@pse-consulting.de |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgadmin-support |
Matt Doggett wrote:
>Ooops. I sent this yesterday to the wrong maillist address. Sorry. I'll
>repost here.
>
>MD
>-----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!
Regards,
Andreas
From | Date | Subject | |
---|---|---|---|
Next Message | Markus Wollny | 2004-02-17 17:17:46 | Re: connection dropping continued |
Previous Message | Matt Doggett | 2004-02-17 16:53:34 | inserting new records without OIDs |