Problem with adding parts after I imported part data

[Chris K. <kac...@ho...>]

What I did:
I had to put in about 100 parts.  Instead of entering each one through the
gui, I tested a few and found that the tables affected were parts, partstax,
and makemodel.  I then dummied up a spreadsheet for each of these tables
with ids and imported them into the postgres tables (pgaccess is really
cool).

What Happened:
This worked fine until I tried to add in a new part via the web interface.
When I did this, the new part showed up twice in the parts table (same id
number which confused me because I thought this was a unique field).  Also,
it over wrote an id number in the parts table from one of the parts I
imported.

What may be happening:
Does SQL-Ledger keep a counter somewhere of the next available id number.
If so, where is the counter so I can update it.  Of perhaps there is a
better way of importing a lot of data into SQL-Ledger.

Thanks in advance for your help.  I really like the program, just do not
want to do a bunch of hand entry.

cheers,

ski