Re: Feature request - Edit data and tables without a primary key

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