Postgres Pro
Downloads
Home   >   mailing lists

Re: Feature request - Edit data and tables without a primary key - Mailing list pgadmin-support

From Thom Brown
Subject Re: Feature request - Edit data and tables without a primary key
Date
Msg-id CAA-aLv4e2PmF6gk0TA8brUQe8zMu-n-SJCbiJRdh5W3t0wr7NQ@mail.gmail.com
Whole thread Raw
In response to Feature request - Edit data and tables without a primary key  ("Jan-Peter Seifert" <Jan-Peter.Seifert@gmx.de>)
Responses Re: Feature request - Edit data and tables without a primary key
List pgadmin-support
Tree view 
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

pgadmin-support by date:

Previous
From: "Jan-Peter Seifert"
Date:
Subject: Feature request - Edit data and tables without a primary key
Next
From: "Isabelle Froc"
Date:
Subject: demande de support