Address 1.6.1-2.0 upgrade problems reported by Ben Shum
authordbs <dbs@dcc99617-32d9-48b4-a31d-7c20da2025e4>
Sun, 28 Nov 2010 15:11:02 +0000 (15:11 +0000)
committerdbs <dbs@dcc99617-32d9-48b4-a31d-7c20da2025e4>
Sun, 28 Nov 2010 15:11:02 +0000 (15:11 +0000)
commitcf6e84f9c60e4bc56ffd293c62803f7876f11794
tree9feafe20b80677e8952b7061be0e15a1ccc06901
parent5f573d615e702274b6f9873261118c1de333983b
Address 1.6.1-2.0 upgrade problems reported by Ben Shum

1. We were attempting to update the asset.uri ID sequence value
with the wrong syntax; also, adding just 1 would return an error
in the event that only the seed value for asset.uri had been
inserted.

2. Somehow the body of the maintain_control_numbers() function
was pasted twice, resulting in a syntax error.

git-svn-id: svn://svn.open-ils.org/ILS/branches/rel_2_0@18849 dcc99617-32d9-48b4-a31d-7c20da2025e4
Open-ILS/src/sql/Pg/1.6.1-2.0-upgrade-db.sql