Re: Feature request - Edit data and tables without a primary key - Mailing list pgadmin-support

From Jan-Peter Seifert
Subject Re: Feature request - Edit data and tables without a primary key
Date
Msg-id 50017767.8050600@gmx.de
Whole thread Raw
In response to Re: Feature request - Edit data and tables without a primary key  (Dave Page <dpage@pgadmin.org>)
Responses Re: Feature request - Edit data and tables without a primary key
List pgadmin-support
Hello,

thank you very much for your feedback everyone!

Am 14.07.2012 15:06, schrieb Dave Page:

>     >  it would be nice to have additional/other fallback options ( via
>     check box in pgAdmin's general options? ) to identify rows for
>     editing in tables without primary keys.
>     > > I'd suggest serials ( serial/serial4 and bigserial/serial8 )
> 
>     You can't be sure a serial (serial2, serial4, and serial8) column will
>     only contain unique values.
> 
>     >  or unique columns/constraints.
> 
>     Yes, this would be interesting to add. I thought we already did it, but
>     I gues I was wrong. I'll add a ticket to work on this later.
> 
> 
> That method will work only if the columns involved are all not null
> constrained.

Sorry - must have been in a hurry ...

Then serials with a unique constraint or unique constraints with 'all
necessary' 'NOT NULL'-constraints maybe?

>     You can add OID columns to an already existing table since 8.4. But it
>     doesn't mean you want to (and actually I don't want to add OID columns
>     to my tables).

That's good - then at least you don't have to recreate the table in
order to edit it with pgAdmin ...
Otherwise we have no need for OID columns ...

Best regards,

Peter



pgadmin-support by date:

Previous
From: Guillaume Lelarge
Date:
Subject: Re: Feature request - Edit data and tables without a primary key
Next
From: Jan-Peter Seifert
Date:
Subject: Re: Feature request - Edit data and tables without a primary key