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