[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 04:41:42 -0700
On Tue, Sep 25, 2012 at 4:00 AM, Jos Geluk <..hidden..>
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)Thank you, this works.
> but not the second. The valid_to being null will prevent that in 1.2.
You will probably want to also:
CREATE UNIQUE INDEX tax_chart_id_current_u ON tax(chart_id) WHERE validto IS NULL;