[OPEN-ILS-DEV] [PATCH] DB update script

[Joe Atzberger]

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.

Attachment two is a resend of simple two word error-suppressing fix that I
haven't seen come through yet (sent from my gmail instead of esilibrary
account... via gmail).
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://libmail.georgialibraries.org/pipermail/open-ils-dev/attachments/20091022/a40ae2f9/attachment.htm 
-------------- next part --------------
A non-text attachment was scrubbed...
Name: update_db.patch
Type: application/octet-stream
Size: 2976 bytes
Desc: not available
Url : http://libmail.georgialibraries.org/pipermail/open-ils-dev/attachments/20091022/a40ae2f9/attachment.obj 
-------------- next part --------------
A non-text attachment was scrubbed...
Name: 0032_IF_EXISTS.patch
Type: application/octet-stream
Size: 449 bytes
Desc: not available
Url : http://libmail.georgialibraries.org/pipermail/open-ils-dev/attachments/20091022/a40ae2f9/attachment-0001.obj