Copy and paste of row containing bytea column saves bytea as 'binary_data' in ascii (RM #5037)

[dpage]

Issue migrated from Redmine: https://redmine.postgresql.org/issues/5037 Originally created by Jason K. at 2019-12-24 04:23:53 UTC.

I apologize if this bug has been reported before but I have not found anything matching variations on the description.

I am using pgadmin 4.16 and have encountered a situation where copying and pasting a row containing a bytea column saves the bytea column as 'binary_data' in ascii bytes instead of the actual byte contents of the bytea column. I first observed this in pgadmin 4.8. The data continues to be displayed as '[binary data]' so it is not obvious until usage of the column data that the copy of the data is corrupt. Unless someone looks at the contents of the column bytes, they might simply think that their data was randomly damaged.

Either it should not be possible to use cut and paste on rows containing bytea columns or the cut/paste should actually copy and paste the bytes.

[dpage]

Comment migrated from Redmine: https://redmine.postgresql.org/issues/5037#note-1 Originally created by Aditya Toshniwal at 2020-01-03 11:13:49 UTC.

We can disable the bytea column from being copied, cut or pasted.

Redmine ticket header update:

Name	Old Value	New Value
Priority changed	High	Normal

[dpage]

Comment migrated from Redmine: https://redmine.postgresql.org/issues/5037#note-2 Originally created by Akshay Joshi at 2020-01-03 11:45:08 UTC.

Redmine ticket header update:

Name	Old Value	New Value
Sprint changed		Ready

[dpage]

Comment migrated from Redmine: https://redmine.postgresql.org/issues/5037#note-3 Originally created by Akshay Joshi at 2020-09-02 09:37:28 UTC.

Redmine ticket header update:

Name	Old Value	New Value
Sprint changed	Ready	EDB Sprint 73
Assigned To changed		Yogesh Mahajan

[dpage]

Comment migrated from Redmine: https://redmine.postgresql.org/issues/5037#note-4 Originally created by Yogesh Mahajan at 2020-09-11 07:36:15 UTC.

Redmine ticket header update:

Name	Old Value	New Value
Assigned To changed	Yogesh Mahajan

[dpage]

Comment migrated from Redmine: https://redmine.postgresql.org/issues/5037#note-5 Originally created by Akshay Joshi at 2020-09-16 10:08:48 UTC.

Redmine ticket header update:

Name	Old Value	New Value
Sprint changed	EDB Sprint 73	Ready

[dpage]

Comment migrated from Redmine: https://redmine.postgresql.org/issues/5037#note-6 Originally created by Akshay Joshi at 2022-02-02 06:19:46 UTC.

Redmine ticket header update:

Name	Old Value	New Value
Sprint changed	Ready	EDB Sprint 110

[dpage]

Comment migrated from Redmine: https://redmine.postgresql.org/issues/5037#note-7 Originally created by Akshay Joshi at 2022-02-02 10:45:59 UTC.

Redmine ticket header update:

Name	Old Value	New Value
Assigned To changed		Yogesh Mahajan

[dpage]

Comment migrated from Redmine: https://redmine.postgresql.org/issues/5037#note-8 Originally created by Akshay Joshi at 2022-02-16 10:32:14 UTC.

Redmine ticket header update:

Name	Old Value	New Value
Sprint changed	EDB Sprint 110	EDB Sprint 111

[dpage]

Comment migrated from Redmine: https://redmine.postgresql.org/issues/5037#note-9 Originally created by Akshay Joshi at 2022-02-16 10:37:18 UTC.

Redmine ticket header update:

Name	Old Value	New Value
Sprint changed	EDB Sprint 111	Ready
Assigned To changed	Yogesh Mahajan

[RohitBhati8269]

Fixed and verified on snapshot-build OS:- macOS Arm64 Installer: Mac (dmg package)