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