Re: duplicate key violation on insert to parts

[Eamonn Hamilton <..hidden..>]

Hi Chris,

The results from your queries :

ledgersmb=# select max(id) from parts;
  max  
-------
 10511
(1 row)

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

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

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



Now, the fact that I only get two numbers returned, and they're both
different, gives me to think summat not good is going on?

Cheers,
Eamonn