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

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

-------- Ursprüngliche Nachricht --------
Von: Aditya Toshniwal <aditya(dot)toshniwal(at)enterprisedb(dot)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(dot)burkhardt(at)uni-jena(dot)de>
Cc: pgadmin-support lists.postgresql.org
<pgadmin-support(at)lists(dot)postgresql(dot)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(dot)burkhardt(at)uni-jena(dot)de> wrote:
>
>>
>>
>> -------- Ursprüngliche Nachricht --------
>> Von: André Burkhardt <andre(dot)burkhardt(at)uni-jena(dot)de>
>> Betreff: copy and paste ERROR on table with column with type 'SERIAL'
>> Datum: Donnerstag, 26. September 2019, 06:10 UTC
>> An: pgadmin-support(at)lists(dot)postgresql(dot)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(dot)burkhardt(at)uni-jena(dot)de
PGP: 0xBE0907A5