| From: | "David G(dot) Johnston" <david(dot)g(dot)johnston(at)gmail(dot)com> |
|---|---|
| To: | Nafees Sardar <nafees(at)epazz(dot)net> |
| Cc: | "pgsql-bugs(at)lists(dot)postgresql(dot)org" <pgsql-bugs(at)lists(dot)postgresql(dot)org> |
| Subject: | Re: Duplicate key value violates unique constraint |
| Date: | 2020-03-16 16:23:44 |
| Message-ID: | CAKFQuwbyaTJ0EKOs1vNfo4+4=FVBN40vZ5a_DyF_mYogv2Pyhg@mail.gmail.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-bugs |
On Monday, March 16, 2020, Nafees Sardar <nafees(at)epazz(dot)net> wrote:
> Hi support,
>
>
>
> I migrate my data from MS Sql server to postgreSQL database, now when I
> try to insert new row it gives me error “duplicate key value violates
> unique constraint”. For example I have a table which contains 100 rows of
> records when I go for inserting 101 row it give duplicate value constraint
> error. When I pass PK value manually its working, and one more thing auto
> increment is enabled for all tables .
>
>
>
> Can you please let me know anything I am missing? I will really
> appreciate it.
>
ALTER SEQUENCE
David J.
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Tom Lane | 2020-03-16 16:27:09 | Re: Duplicate key value violates unique constraint |
| Previous Message | Nafees Sardar | 2020-03-16 15:55:57 | Duplicate key value violates unique constraint |