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/