Re: Feature request - Edit data and tables without a primary key

From: Thom Brown <thom(at)linux(dot)com>
To: Jan-Peter Seifert <Jan-Peter(dot)Seifert(at)gmx(dot)de>
Cc: pgadmin-support(at)postgresql(dot)org
Subject: Re: Feature request - Edit data and tables without a primary key
Date: 2012-07-12 11:31:36
Message-ID: CAA-aLv4e2PmF6gk0TA8brUQe8zMu-n-SJCbiJRdh5W3t0wr7NQ@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgadmin-support

On 12 July 2012 12:20, Jan-Peter Seifert <Jan-Peter(dot)Seifert(at)gmx(dot)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

In response to

Responses

Browse pgadmin-support by date

  From Date Subject
Next Message Isabelle Froc 2012-07-12 11:58:44 demande de support
Previous Message Jan-Peter Seifert 2012-07-12 11:20:15 Feature request - Edit data and tables without a primary key