Обсуждение: copy and paste ERROR on table with column with type 'SERIAL'

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é

-------- Ursprüngliche Nachricht --------
Von: André Burkhardt <andre.burkhardt@uni-jena.de>
Betreff: copy and paste ERROR on table with column with type 'SERIAL'
Datum: Donnerstag, 26. September 2019, 06:10 UTC
An: pgadmin-support@lists.postgresql.org

> 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.

The Error-Message only pops up, when there is an UNIQUE INDEX on the
column with the SERIAL! Otherwise the dataset is inserted without error
or info.

> 
> Is it on roadmap to implement this useful feature in pgAdmin 4?
> 
> Regards
> André
> 
> 

https://redmine.postgresql.org/issues/4782

-------- Ursprüngliche Nachricht --------
Von: Aditya Toshniwal <aditya.toshniwal@enterprisedb.com>
Betreff: copy and paste ERROR on table with column with type 'SERIAL'
Datum: Donnerstag, 26. September 2019, 07:13 UTC
An: André Burkhardt <andre.burkhardt@uni-jena.de>
Cc: pgadmin-support lists.postgresql.org
<pgadmin-support@lists.postgresql.org>

> Hi,
> 
> Kindly raise a request here
> https://redmine.postgresql.org/projects/pgadmin4/issues/new.
> 
> On Thu, Sep 26, 2019 at 12:00 PM André Burkhardt <
> andre.burkhardt@uni-jena.de> wrote:
> 
>>
>>
>> -------- Ursprüngliche Nachricht --------
>> Von: André Burkhardt <andre.burkhardt@uni-jena.de>
>> Betreff: copy and paste ERROR on table with column with type 'SERIAL'
>> Datum: Donnerstag, 26. September 2019, 06:10 UTC
>> An: pgadmin-support@lists.postgresql.org
>>
>>> 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.
>>
>> The Error-Message only pops up, when there is an UNIQUE INDEX on the
>> column with the SERIAL! Otherwise the dataset is inserted without error
>> or info.
>>
>>>
>>> Is it on roadmap to implement this useful feature in pgAdmin 4?
>>>
>>> Regards
>>> André
>>>
>>>
>>
>>
>>
> 

-- 
Friedrich-Schiller-Universität Jena
Universitätsrechenzentrum
Zentrale Server und Basisdienste
Fürstengraben 1
07743 Jena

Tel.:    +49 3641 9 404808
E-Mail: andre.burkhardt@uni-jena.de
PGP:     0xBE0907A5