Re: copy and paste ERROR on table with oid

From: Aditya Toshniwal <aditya(dot)toshniwal(at)enterprisedb(dot)com>
To: André Burkhardt <andre(dot)burkhardt(at)uni-jena(dot)de>
Cc: "pgadmin-support lists(dot)postgresql(dot)org" <pgadmin-support(at)lists(dot)postgresql(dot)org>
Subject: Re: copy and paste ERROR on table with oid
Date: 2019-08-30 12:10:58
Message-ID: CAM9w-_=4nftX2rwvQ23DKx3AiVJNmQsUkmeAD-vL+fQ+iWWEJg@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgadmin-support

Hi André,

The issue is logged - https://redmine.postgresql.org/issues/4381. This is
fixed and will be available in next release.

On Fri, Aug 30, 2019 at 5:38 PM André Burkhardt <andre(dot)burkhardt(at)uni-jena(dot)de>
wrote:

> We are using pgAdmin 4 4.12. Our Administrators often work with copy and
> paste rows within a table using the GUI. In pgAdmin III it was not a
> problem, the column "oid" was not copied and pasted. But in pgAdmin 4,
> when I insert the copied row, the oid is filled with the value from the
> copied dataset. After "Saving Data Changes" an error message is shown:
>
> ERROR: column "oid" of relation "tablename" does not exist
>
> There is also no possibility to delete the oid manually ofter insert,
> the column is locked.
>
>
>

--
Thanks and Regards,
Aditya Toshniwal
Software Engineer | EnterpriseDB India | Pune
"Don't Complain about Heat, Plant a TREE"

In response to

Browse pgadmin-support by date

  From Date Subject
Next Message Ray O'Donnell 2019-08-30 13:47:00 Re: pgAdmin bug
Previous Message André Burkhardt 2019-08-30 12:08:11 copy and paste ERROR on table with oid