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?

Jos

--
www.ardispark.nl
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
..hidden..
https://lists.sourceforge.net/lists/listinfo/ledger-smb-users