[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
Re: Problem entering new VAT rates
- Subject: Re: Problem entering new VAT rates
- From: Chris Travers <..hidden..>
- Date: Tue, 25 Sep 2012 03:30:08 -0700
On Tue, Sep 25, 2012 at 2:22 AM, Jos Geluk <..hidden..>
Chris Travers schreef op 25-09-12 10:19:
> Try running these:
> alter table tax drop constraint "tax_pkey";
> alter table tax add primary key (chart_id, validto);
> That makes the primary key a combination of chart_id and validto. In
> previous versions it was just chart_id.
> I am surprised that this is happening on 1.3 though. I thought we
> changed this early on in the 1.3 development cycle. I will have to go
> back and see if a general addition to Fixes.sql is required.
In 1.2 you will need to run the first statement (drop the primary key) but not the second. The valid_to being null will prevent that in 1.2.
Thanks Chris, but as I said, this is 1.2.25. Is your solution still
valid in this case?