[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

Re: Upgrade Error

Perfection, I shall try it this evening.


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