Re: Upgrade Error

[Leah Kubik <..hidden..>]

Hi Angus,

<snip>

> NOTICE:  ALTER TABLE / ADD PRIMARY KEY will create implicit index
> "tax_pkey" for table "tax"
> ERROR:  could not create unique index
> DETAIL:  Table contains duplicated values.

<snip>

> chart_id | rate |    taxnumber    |  validto
> ----------+------+-----------------+------------
>     10019 |    0 |                 | 2006-06-30
>     10019 | 0.06 | GSTNUMBER |
>     10020 | 0.07 | PSTNUMBER         |

I had a similar issue when I did my update.  In my case I just had some random 
null entries below valid ones with the same ID.  I just deleted the. But in 
your case it sounds like somthing needs to be done to deal with making sure 
that you still have the 0 rate prior to 2006-06-30.  Maybe the chart_id can 
be updated for this entry to something else, but I don't know the software 
well enough to know if that would cause problems elsewhere (probably) so I'd 
wait for an answer from Chris or someone who knows for sure...

Leah

-- 
Leah Kubik : d416-585-9971x692 : d416-703-5977 : m416-559-6511
Frauerpower! Co. : www.frauerpower.com : Toronto, ON Canada
MSN: ..hidden.. | AIM: frauerpower | Yahoo: h3inous
F9B6 FEFE 080B 8299 D7EA  1270 005C EC73 47C9 B7A6