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 -- Sent via pgadmin-support mailing list (pgadmin-support@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgadmin-support