Re: all serial type was changed to 1

From: Adrian Klaver <adrian(dot)klaver(at)aklaver(dot)com>
To: Max Wang <mwang(at)1080agile(dot)com>, Melvin Davidson <melvin6925(at)gmail(dot)com>
Cc: Amitabh Kant <amitabhkant(at)gmail(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-02 00:01:51
Message-ID: 093b49cc-f9a1-bd8f-b1d4-1b6514b9816c@aklaver.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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(dot)klaver(at)aklaver(dot)com

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Melvin Davidson 2017-05-02 00:01:57 Re: all serial type was changed to 1
Previous Message John R Pierce 2017-05-01 23:59:53 Re: Compatibility of libpg