copy and paste ERROR on table with column with type 'SERIAL'

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 column with type 'SERIAL'
Date: 2019-09-26 06:10:13
Message-ID: 54e557f7-e16b-be2c-905d-d1526c3e36e4@uni-jena.de
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgadmin-support

We are using pgAdmin 4 4.13. Our Administrators often work with copy and
paste rows within a table using the GUI. In pgAdmin III, when copy and
paste a row with a SERIAL, a messagebox with question:

"This table contains columns from type 'SERIAL'. Use values from within
clipboard for this column? YES/NO"

pops up. If select NO, the column with the SERIAL is cleared after
insert. When saving the changes, the field is filled with next value
from sequence.

In pgAdmin 4 the dedection of such SERIAL-columns is not implemented, so
that you have to clear the column with SERIAL manually. Otherwise an
Error-Message pops up after saving.

Is it on roadmap to implement this useful feature in pgAdmin 4?

Regards
André

Responses

Browse pgadmin-support by date

  From Date Subject
Next Message André Burkhardt 2019-09-26 06:30:50 Re: copy and paste ERROR on table with column with type 'SERIAL'
Previous Message Pepe TD Vo 2019-09-25 12:35:06 Re: pgAdmin4 error