On Thu, Oct 22, 2009 at 12:18 PM, Joe Atzberger <jatzber...@esilibrary.com>wrote:
> Attachment one is a database update script based on work Bill sent to the > list. The previous mechanism was to call psql -f once per file, but that > also required the psql password to be entered once per file and didn't check > to see if the call failed to try again or at least bail out on subsequent > files (that might require the earlier ones to succeed. Given that typing > (or even pasting) 20+ consecutive blind password entires is error-prone, I > replaced that with a pipe to single psql call. > > Pending acceptance, the foreseeable goal will be to integrate this script > with the update.sh script and have a single call to apply both code and data > changes from an updated repo. > DB update patch applied. I put it into build/tools next to update.sh Thanks, Joe. -b -- Bill Erickson | VP, Software Development & Integration | Equinox Software, Inc. / The Evergreen Experts | phone: 877-OPEN-ILS (673-6457) | email: erick...@esilibrary.com | web: http://esilibrary.com Please join us for the Evergreen 2010 International Conference, April 20-23, 2010 at the Amway Grand Hotel and Convention Center, Grand Rapids, Michigan. http://www.evergreen2010.org/