For the psql command try adding -veg_version=NULL to define the
eg_version variable.
Thomas Berezansky
Merrimack Valley Library Consortium
Quoting "Soulliere, Robert" <[email protected]>:
Hi all,
I am trying to run the 2.2. database upgrade script on a test server:
2.1-2.2-upgrade-db.sql.
with the command:
psql -U evergreen -f 2.1-2.2-upgrade-db.sql evergreen
However, I am getting the following syntax errors:
psql:2.1-2.2-upgrade-db.sql:6256: ERROR: syntax error at or near ":"
LINE 1: SELECT evergreen.upgrade_deps_block_check('0647', :eg_versio...
So far the only way I know how to avoid these error and complete the
upgrade script is to comment out all the
"SELECT evergreen.upgrade_deps_block_check('0651', :eg_versio..."
lines in the scripts.
Obviously, that doesn't seem like to correct path so solve this
issue since this is supposed to check for preciously installed
updates.
I am wondering if these errors are occurring because I am missing a
postgresql language install or if a previous upgrade might be missing?
I am installing from trunk and am tried this on both postgresql 9.0
and 9.1 systems.
Thanks,
Robert
Robert Soulliere, BA (Hons), MLIS
Systems Librarian
Mohawk College Library
[email protected]
Telephone: 905 575 1212 x3936
Fax: 905 575 2011
This E-mail contains privileged and confidential information intended
only for the individual or entity named in the message. If the reader
of this message is not the intended recipient, or the agent responsible
to deliver it to the intended recipient, you are hereby notified that
any review, dissemination, distribution or copying of this communication
is prohibited. If this communication was received in error, please
notify the sender by reply E-mail immediately, and delete and destroy
the original message.
