Re: all serial type was changed to 1

[Rob Sargent <robjsargent@xxxxxxxxx>]

Every row?

On 05/01/2017 05:17 PM, Max Wang wrote:

Sorry. I mean all tables’ id column were reset to 1.

 

Thanks.

 

 

 

From: Melvin Davidson [mailto:melvin6925@xxxxxxxxx]
Sent: Tuesday, 2 May 2017 9:14 AM
To: Max Wang <mwang@xxxxxxxxxxxxx>
Cc: Adrian Klaver <adrian.klaver@xxxxxxxxxxx>; pgsql-general@xxxxxxxxxxxxxx
Subject: Re: all serial type was changed to 1

 

 

 

On Mon, May 1, 2017 at 7:08 PM, Max Wang <mwang@xxxxxxxxxxxxx> wrote:

Hi Adrian,

Only sequences (id) reset to 1.

Regards,
Max

-----Original Message-----
From: Adrian Klaver [mailto:adrian.klaver@xxxxxxxxxxx]
Sent: Monday, 1 May 2017 11:30 PM
To: Max Wang <mwang@xxxxxxxxxxxxx>; pgsql-general@xxxxxxxxxxxxxx
Subject: Re: 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.klaver@xxxxxxxxxxx


--
Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx)
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.