[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

Tax rate changes and constraint "tax_pkey



Ok, I think we had talked about this before, but a general decision was not 
made.  When you expire a tax rate and go to add the new rate, you will have a 
problem:

DBD::Pg::st execute failed: ERROR: duplicate key violates unique 
constraint "tax_pkey"
Error!

INSERT INTO tax (chart_id, rate, taxnumber, validto,
pass, taxmodule_id)
VALUES (?, ?, ?, ?, ?, ?)
ERROR: duplicate key violates unique constraint "tax_pkey"

Is the current solution to remove the primary key for tax?

http://comments.gmane.org/gmane.comp.finance.ledger.smb.user/710

Leah
-- 
Leah Kubik : d416-585-9971x692 : d416-703-5977 : m416-559-6511
Frauerpower! Co. : www.frauerpower.com : Toronto, ON Canada
MSN: ..hidden.. | AIM: frauerpower | Yahoo: h3inous
F9B6 FEFE 080B 8299 D7EA  1270 005C EC73 47C9 B7A6