On Sun, Apr 30, 2017 at 10:51 PM, Max Wang <mwang@xxxxxxxxxxxxx> 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/ -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
