I have a feature request for the 'Edit data' window that is available for each table in pgAdmin.
As the OID column is not guaranteed to contain unique OIDs 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 ) or unique columns/constraints.
Another drawback of OID columns is that you can't add them afterwards.
Issue migrated from Redmine: https://redmine.postgresql.org/issues/613 Originally created by Guillaume Lelarge at 2012-07-14 12:57:35 UTC.
I have a feature request for the 'Edit data' window that is available for each table in pgAdmin.
As the OID column is not guaranteed to contain unique OIDs 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 ) or unique columns/constraints. Another drawback of OID columns is that you can't add them afterwards.