Postgres Pro
Downloads
Home   >   mailing lists

Re: [GENERAL] all serial type was changed to 1 - Mailing list pgsql-general

From Adrian Klaver
Subject Re: [GENERAL] all serial type was changed to 1
Date
Msg-id 093b49cc-f9a1-bd8f-b1d4-1b6514b9816c@aklaver.com
Whole thread Raw
In response to Re: [GENERAL] all serial type was changed to 1  (Max Wang <mwang@1080agile.com>)
List pgsql-general
Tree view 
On 05/01/2017 04:55 PM, Max Wang wrote:
> Hi Melvin,
>
>
>
> I already reset id to correct value after this happen. This is a
> production database. We could not stop and wait for trouble shooting. I
> manually reset sequence of id to correct value.

I would grep for setval in any of the code you have touching this
database. Also are you using any third party code?

>
>
>


--
Adrian Klaver
adrian.klaver@aklaver.com

pgsql-general by date:

Previous
From: John R Pierce
Date:
Subject: Re: [GENERAL] Compatibility of libpg
Next
From: Melvin Davidson
Date:
Subject: Re: [GENERAL] all serial type was changed to 1