Thread: 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é > >
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é
>
>
Thanks and Regards,
Aditya Toshniwal
Sr. Software Engineer | EnterpriseDB India | Pune
"Don't Complain about Heat, Plant a TREE"
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