copy and paste ERROR on table with oid - Mailing list pgadmin-support

From André Burkhardt
Subject copy and paste ERROR on table with oid
Date
Msg-id 4d973e7b-6b41-d963-d1e1-f8a9d20d0911@uni-jena.de
Whole thread Raw
Responses Re: copy and paste ERROR on table with oid
List 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.



pgadmin-support by date:

Previous
From: Paolo Saudin
Date:
Subject: Re: PgAdmin Error when retrieving SQL definition
Next
From: Aditya Toshniwal
Date:
Subject: Re: copy and paste ERROR on table with oid