Thanks for all your assistance and tips everyone. Using the option:
-veg_version=NULL in the psql command works well. I have a few things to clean up related to past updates in this test database, but this put me on the right track. After examining my original email, I see I need to do more careful spell and typo checking before hitting send. ;-) Regards, Robert Robert Soulliere, BA (Hons), MLIS Systems Librarian Mohawk College Library [email protected] Telephone: 905 575 1212 x3936 Fax: 905 575 2011 ________________________________________ From: [email protected] [[email protected]] On Behalf Of Peters, Michael [[email protected]] Sent: February 9, 2012 11:59 AM To: Evergreen Development Discussion List Subject: Re: [OPEN-ILS-DEV] upgrade sql script Sorry for the bad advice, Robert. Sincerely, Michael Peters Indiana State Library MIS | Inspire.IN.gov Helpdesk | Evergreen Indiana Helpdesk office - 317.234.2128 email - [email protected] -----Original Message----- From: [email protected] [mailto:[email protected]] On Behalf Of Peters, Michael Sent: Thursday, February 09, 2012 11:35 AM To: Evergreen Development Discussion List Subject: Re: [OPEN-ILS-DEV] upgrade sql script I could be wrong, but isn't this a job for update_db.sh? Something like: /home/opensrf/Evergreen/build/tools/update_db.sh localhost evergreen evergreen (while in Open-ILS/src/sql/Pg) Sincerely, Michael Peters Indiana State Library MIS | Inspire.IN.gov Helpdesk | Evergreen Indiana Helpdesk office - 317.234.2128 email - [email protected] -----Original Message----- From: [email protected] [mailto:[email protected]] On Behalf Of Thomas Berezansky Sent: Thursday, February 09, 2012 11:05 AM To: Evergreen Development Discussion List Subject: Re: [OPEN-ILS-DEV] upgrade sql script 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. > 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.
