Re: Upgrade Error

["Angus Jordan" <..hidden..>]

Perfection, I shall try it this evening.

Angus

On 4/12/07, Chris Travers <..hidden.. > wrote:

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
valid_to fields:

alter table tax add primary key (chart_id, valid_to);

Best WIshes,
Chris Travers