On 12 July 2012 12:20, Jan-Peter Seifert <Jan-Peter.Seifert@gmx.de> wrote:
> Hello,
>
> 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.
Use of the CTID system column would work.
--
Thom