From: | André Burkhardt <andre(dot)burkhardt(at)uni-jena(dot)de> |
---|---|
To: | pgadmin-support(at)lists(dot)postgresql(dot)org |
Subject: | Re: copy and paste ERROR on table with column with type 'SERIAL' |
Date: | 2019-09-26 06:30:50 |
Message-ID: | 81229b5e-15bb-2c44-cb5c-5bd78e3f8ffd@uni-jena.de |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgadmin-support |
-------- 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é
>
>
From | Date | Subject | |
---|---|---|---|
Next Message | Aditya Toshniwal | 2019-09-26 07:13:59 | Re: copy and paste ERROR on table with column with type 'SERIAL' |
Previous Message | André Burkhardt | 2019-09-26 06:10:13 | copy and paste ERROR on table with column with type 'SERIAL' |