copy and paste ERROR on table with oid

From: André Burkhardt <andre(dot)burkhardt(at)uni-jena(dot)de>
To: pgadmin-support(at)lists(dot)postgresql(dot)org
Subject: copy and paste ERROR on table with oid
Date: 2019-08-30 12:08:11
Message-ID: 4d973e7b-6b41-d963-d1e1-f8a9d20d0911@uni-jena.de
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgadmin-support

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.

Responses

Browse pgadmin-support by date

  From Date Subject
Next Message Aditya Toshniwal 2019-08-30 12:10:58 Re: copy and paste ERROR on table with oid
Previous Message Paolo Saudin 2019-08-27 13:22:55 Re: PgAdmin Error when retrieving SQL definition