[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
Re: Upgrade Error
- Subject: Re: Upgrade Error
- From: "Angus Jordan" <..hidden..>
- Date: Thu, 12 Apr 2007 18:53:19 -0700
Perfection, I shall try it this evening.
On 4/12/07, Chris Travers <..hidden..
Hmmm..... I can see areas where this could be problematic. It might
be a good idea to think about how this works. Maybe we should
generalize the primary key to include the valid_to field as well.....
In the mean time, delete the primary key definition from your update
script and reapply. These should be transactional.
Then create a primary key on the table for both the chart_id and
alter table tax add primary key (chart_id, valid_to);