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.burkha...@uni-jena.de> wrote: > > > -------- Ursprüngliche Nachricht -------- > Von: André Burkhardt <andre.burkha...@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é > > > > > > > -- Thanks and Regards, Aditya Toshniwal Sr. Software Engineer | EnterpriseDB India | Pune "Don't Complain about Heat, Plant a TREE"
