On Mon, May 1, 2017 at 7:08 PM, Max Wang <mw...@1080agile.com> wrote:
> Hi Adrian, > > Only sequences (id) reset to 1. > > Regards, > Max > > -----Original Message----- > From: Adrian Klaver [mailto:adrian.kla...@aklaver.com] > Sent: Monday, 1 May 2017 11:30 PM > To: Max Wang <mw...@1080agile.com>; pgsql-general@postgresql.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.kla...@aklaver.com > > > -- > Sent via pgsql-general mailing list (pgsql-general@postgresql.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.