https://redmine.postgresql.org/issues/4782
-------- Ursprüngliche Nachricht -------- Von: Aditya Toshniwal <[email protected]> Betreff: copy and paste ERROR on table with column with type 'SERIAL' Datum: Donnerstag, 26. September 2019, 07:13 UTC An: André Burkhardt <[email protected]> Cc: pgadmin-support lists.postgresql.org <[email protected]> > 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 < > [email protected]> wrote: > >> >> >> -------- Ursprüngliche Nachricht -------- >> Von: André Burkhardt <[email protected]> >> Betreff: copy and paste ERROR on table with column with type 'SERIAL' >> Datum: Donnerstag, 26. September 2019, 06:10 UTC >> An: [email protected] >> >>> 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: [email protected] PGP: 0xBE0907A5
