[OPEN-ILS-DEV] upgrade sql script

[Thomas Berezansky]

For the psql command try adding -veg_version=NULL to define the  
eg_version variable.

Thomas Berezansky
Merrimack Valley Library Consortium


Quoting "Soulliere, Robert" <robert.soulliere at mohawkcollege.ca>:

> 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
> robert.soulliere at mohawkcollege.ca
> 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.
>