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

Re: Problem entering new VAT rates

On Tue, Sep 25, 2012 at 2:22 AM, Jos Geluk <..hidden..> wrote:
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.

Best Wishes,
Chris Travers 

Thanks Chris, but as I said, this is 1.2.25. Is your solution still
valid in this case?


tel. 06 5341 4670

Live Security Virtual Conference
Exclusive live event will cover all the ways today's security and
threat landscape has changed and how IT managers can respond. Discussions
will include endpoint security, mobile security and the latest in malware
threats. http://www.accelacomm.com/jaw/sfrnl04242012/114/50122263/
Ledger-smb-users mailing list