Every time I try to insert I get the error:
docking_dev=# INSERT INTO "chinese_price_infos" ("item_code", "price_cents", "unit", "description", "company_id",
"created_at","updated_at") VALUES ('01GS10001', 6000, 'Lift', 'Shore Crane Rental',
'9ae3f8b8-8f3f-491c-918a-efd8f5100a5e','2019-05-06 10:49:03.894725', '2019-05-06 10:49:03.894725');
ERROR: duplicate key value violates unique constraint "chinese_price_infos_pkey"
DETAIL: Key (id)=(71165) already exists.
docking_dev=# INSERT INTO "chinese_price_infos" ("item_code", "price_cents", "unit", "description", "company_id",
"created_at","updated_at") VALUES ('01GS10001', 6000, 'Lift', 'Shore Crane Rental',
'9ae3f8b8-8f3f-491c-918a-efd8f5100a5e','2019-05-06 10:49:03.894725', '2019-05-06 10:49:03.894725');
ERROR: duplicate key value violates unique constraint "chinese_price_infos_pkey"
DETAIL: Key (id)=(71166) already exists.
Then I found:
docking_dev=# SELECT MAX(id) FROM chinese_price_infos;
max
--------
128520
(1 row)
docking_dev=# SELECT nextval('chinese_price_infos_id_seq');
nextval
---------
71164
(1 row)
Not sure how it is out of sync. How can I fix this permanently. I ran vacuum analyze verbose; still same error.
Thanks,
Arup Rakshit
ar@zeit.io