From: | Aditya Toshniwal <aditya(dot)toshniwal(at)enterprisedb(dot)com> |
---|---|
To: | André Burkhardt <andre(dot)burkhardt(at)uni-jena(dot)de> |
Cc: | "pgadmin-support lists(dot)postgresql(dot)org" <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 07:13:59 |
Message-ID: | CAM9w-_neXxXxibkjfEO9jYYAUS2UeG5pgYiUzO4=YR042aPB+g@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgadmin-support |
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(dot)burkhardt(at)uni-jena(dot)de> wrote:
>
>
> -------- 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é
> >
> >
>
>
>
--
Thanks and Regards,
Aditya Toshniwal
Sr. Software Engineer | EnterpriseDB India | Pune
"Don't Complain about Heat, Plant a TREE"
From | Date | Subject | |
---|---|---|---|
Next Message | André Burkhardt | 2019-09-26 08:42:23 | Re: copy and paste ERROR on table with column with type 'SERIAL' |
Previous Message | André Burkhardt | 2019-09-26 06:30:50 | Re: copy and paste ERROR on table with column with type 'SERIAL' |