Re: duplicate key violation on insert to parts

[Eamonn Hamilton <..hidden..>]

Ask and ye shall receive, oh wise one :


ledgersmb=# select * from id;
 sequence_name | last_value | increment_by |      max_value      |
min_value | cache_value | log_cnt | is_cycled | is_called 
---------------+------------+--------------+---------------------+-----------+-------------+---------+-----------+-----------
 id            |      10251 |            1 | 9223372036854775807 |
1 |           1 |      24 | f         | t
(1 row)

ledgersmb=# select max(id) from transactions;
  max  
-------
 10512
(1 row)


I'm guessing that the 10251 from id should be 10513?