From: | Max Wang <mwang(at)1080agile(dot)com> |
---|---|
To: | Melvin Davidson <melvin6925(at)gmail(dot)com> |
Cc: | Adrian Klaver <adrian(dot)klaver(at)aklaver(dot)com>, "pgsql-general(at)postgresql(dot)org" <pgsql-general(at)postgresql(dot)org> |
Subject: | Re: all serial type was changed to 1 |
Date: | 2017-05-01 23:17:54 |
Message-ID: | ME1PR01MB139411AB7C2DA73B618A9F2DA8140@ME1PR01MB1394.ausprd01.prod.outlook.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
Sorry. I mean all tables’ id column were reset to 1.
Thanks.
From: Melvin Davidson [mailto:melvin6925(at)gmail(dot)com]
Sent: Tuesday, 2 May 2017 9:14 AM
To: Max Wang <mwang(at)1080agile(dot)com>
Cc: Adrian Klaver <adrian(dot)klaver(at)aklaver(dot)com>; pgsql-general(at)postgresql(dot)org
Subject: Re: [GENERAL] all serial type was changed to 1
On Mon, May 1, 2017 at 7:08 PM, Max Wang <mwang(at)1080agile(dot)com<mailto:mwang(at)1080agile(dot)com>> wrote:
Hi Adrian,
Only sequences (id) reset to 1.
Regards,
Max
-----Original Message-----
From: Adrian Klaver [mailto:adrian(dot)klaver(at)aklaver(dot)com<mailto:adrian(dot)klaver(at)aklaver(dot)com>]
Sent: Monday, 1 May 2017 11:30 PM
To: Max Wang <mwang(at)1080agile(dot)com<mailto:mwang(at)1080agile(dot)com>>; pgsql-general(at)postgresql(dot)org<mailto:pgsql-general(at)postgresql(dot)org>
Subject: Re: [GENERAL] all serial type was changed to 1
On 04/30/2017 10:51 PM, Max Wang wrote:
> Hi All,
>
>
>
> We have a PostgreSQL database. There are 26 tables and we use serial
> type as primary key. We had a insert error as "duplicate key value
> violates unique constraint, DETAIL: Key (id)=(1) already exists." one
> weeks ago. I checked and found all tables' id were reset to 1.
So to be clear:
Every row in each of the 26 tables has an id of 1?
or
Do you mean the sequences where reset to 1?
>
>
>
> I checked database log and did not find any useful information. I am
> not sure why this happen. The only script which connect to this
> database is a Python script and only do normal insert/update/delete actions.
>
>
>
> Please give me some suggestions if you happen to know something about
> this issue. I appreciate any feedback you might have.
>
>
>
> I am very new to PostgreSQL and this mail list. Please let me know if
> I did not something wrong.
>
>
>
> Thank you.
>
>
>
> Regards,
>
> Max
>
--
Adrian Klaver
adrian(dot)klaver(at)aklaver(dot)com<mailto:adrian(dot)klaver(at)aklaver(dot)com>
--
Sent via pgsql-general mailing list (pgsql-general(at)postgresql(dot)org<mailto:pgsql-general(at)postgresql(dot)org>)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
But as Adrian asked, was the sequence reset to 1 for ALL tables sequences or just 1?
--
Melvin Davidson
I reserve the right to fantasize. Whether or not you
wish to share my fantasy is entirely up to you. [http://us.i1.yimg.com/us.yimg.com/i/mesg/tsmileys2/01.gif]
From | Date | Subject | |
---|---|---|---|
Next Message | Rob Sargent | 2017-05-01 23:23:38 | Re: all serial type was changed to 1 |
Previous Message | Adrian Klaver | 2017-05-01 23:16:23 | Re: all serial type was changed to 1 |