[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
Tax rate changes and constraint "tax_pkey
- Subject: Tax rate changes and constraint "tax_pkey
- From: Leah Kubik <..hidden..>
- Date: Sat, 5 May 2007 01:48:41 -0400
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