Make patch-checking function able to raise a notice
authorDan Scott <dan@coffeecode.net>
Tue, 31 May 2011 17:19:08 +0000 (13:19 -0400)
committerBill Erickson <berick@esilibrary.com>
Wed, 1 Jun 2011 13:17:40 +0000 (09:17 -0400)
commit340e026918ecca3ab7dfef6a67160ed516cca835
treede3892f4367569d5656e72b7041ae23f89912d28
parent501f26fe7f0da1d4a5d6962b2c3a820eec3ccc4d
Make patch-checking function able to raise a notice

There's probably a more elegant way to do this, but basic
testing with the following at least didn't throw an error:

SELECT evergreen.upgrade_deps_block_check('XXXX', NULL);

Also note that the CREATE OR REPLACE function calls will
fail on an existing database due to the changed return
type of the functions - so if this gets moved into its
own upgrade script, DROP FUNCTION calls will be
required.

Signed-off-by: Dan Scott <dscott@laurentian.ca>
Signed-off-by: Bill Erickson <berick@esilibrary.com>
Open-ILS/src/sql/Pg/002.schema.config.sql
Open-ILS/src/sql/Pg/upgrade/0526.schema.upgrade-dep-tracking.sql