[OPEN-ILS-DEV] upgrade sql script

[Peters, Michael]

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 - mrpeters at library.in.gov 


-----Original Message-----
From: open-ils-dev-bounces at list.georgialibraries.org [mailto:open-ils-dev-bounces at list.georgialibraries.org] 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 - mrpeters at library.in.gov 


-----Original Message-----
From: open-ils-dev-bounces at list.georgialibraries.org [mailto:open-ils-dev-bounces at list.georgialibraries.org] 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" <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.
>