Postgres Pro
Downloads
Home   >   mailing lists

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

From Peter Geoghegan
Subject Re: [GENERAL] all serial type was changed to 1
Date
Msg-id CAH2-Wz=3K7H9oJKbAmdwdD48RGsQxs=YTtnA5hqTcvN7mgZzsA@mail.gmail.com
Whole thread Raw
In response to [GENERAL] all serial type was changed to 1  (Max Wang <mwang@1080agile.com>)
List pgsql-general
Tree view 
On Sun, Apr 30, 2017 at 10:51 PM, Max Wang <mwang@1080agile.com> wrote:
> 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.

I've heard of this happening before. I never determined what the cause was.


--
Peter Geoghegan

VMware vCenter Server
https://www.vmware.com/

pgsql-general by date:

Previous
From: Max Wang
Date:
Subject: [GENERAL] all serial type was changed to 1
Next
From: Philippe BEAUDOIN
Date:
Subject: [GENERAL] Column rename in an extension update script