Shhh, didn't think of that. So we won't ever accept unique indices for
this.
What we do in phpPgAdmin is that rows with NULL values in the unique key
simply aren't editable - all other rows are though.
In order, we prefer to use a PK (since it is indexed), then oid column
(since it is complete)
> -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
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 *no
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!
Rememb
gt;Cc: [pgADMIN]
>Subject: Re: [pgadmin-support] inserting new records without OIDs
>
>Matt Doggett wrote:
>
>>Ooops. I sent this yesterday to the wrong maillist address. Sorry.
I'll
>>repost here.
>>
>>MD
>>-Original Message-
>>When I
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
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
