Re: Duplicate customer records, anyone?

[alta <al...@al...>]

Mystery solved.

Here's what happened:

I loaded a bunch of custormers from another system.
When I created a new customer, sql-ledger wrote over one of the 
loaded customers and created a new record.  The result was a 
blown-away customer and a new customer with duplicate records.

This is because the next id comes from a PostgreSQL proprietary 
sequence table called "id".  It does not really know what is in the 
customer table, it just supplies the next number in sequence.  
Because there are no checks in sql-ledger for an existing number or 
uniqueness, it happened.

Anyway, problem solved, and I'm a happy camper.

... Reed

-- 
Reed White  -  ALTA RESEARCH  -  www.alta-research.com
Phone: 877-360-2582  -  Email: al...@al...