Re: Advice upgrading from 0.7.1 to 0.92.0

[Tibor Simko <tibor.simko@xxxxxxx>]

Hello Ferran:

On Thu, 11 Jan 2007, Ferran Jorba wrote:

> BTW, is this 'Duplicate column name' also harmless?

Yes.  These warnings are generally harmless, because when you launch
several "make update-v0.x.y-tables" statements in a row, usually the
first launch contains a statement like:

   ./modules/miscutil/bin/dbexec < ./modules/miscutil/sql/tabcreate.sql

which creates the new tables already according to the final version
you are installing, i.e. 0.92.0, and so you do not need all these
intermediate 0.90.0 to 0.91.1 updates and so on.  This is why
RELEASE-NOTES says to launch all the ALTER TABLE statements one by
one, but to ignore any errors of the kind "index already exists" or
"column already exists".

In your case, when you launched "make update-v0.7.1-tables", the old
oaiHARVEST table was dropped (see that Makefile target's statements)
and the new table was already created with good 0.92.0 column
definitions, so the table was not needed to be altered once more
during "make update-v0.90.1-tables".

(The "update-v0.x.y-tables" statements are targeted for people
upgrading from one version right to the next, in which case they do
not produce any errors or warnings.)

Best regards
--
Tibor Simko ** CERN IT-UDS ** Bldg 31-S-014 ** Voice: +41-22-7673527
CERN Document Server ** <http://cds.cern.ch/> ** <cds.support@xxxxxxx>