Re: Problem entering new VAT rates

On Tue, Sep 25, 2012 at 4:00 AM, Jos Geluk <..hidden..> wrote:

Chris Travers schreef op 25-09-12 12:30:

> > Try running these:
> >
> > alter table tax drop constraint "tax_pkey";
> > alter table tax add primary key (chart_id, validto);

> 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.

Thank you, this works.

You will probably want to also:

CREATE UNIQUE INDEX tax_chart_id_current_u ON tax(chart_id) WHERE validto IS NULL;

J.

--
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