Error applying 2.0.0-2.0.1-upgrade-db.sql in PostgreSQL 9.0

[Anoop Atre]

Evergreen 2.0.0
OpenSRF 1.6.2
PostgreSQL 9.0.3
Ubuntu Lucid

I am getting an error while trying to upgrade a server from 1.6.1.* to 2.0.2, it occurs when applying 2.0.0-2.0.1-upgrade-db.sql
--------------------------------
$$ LANGUAGE plpgsql;
psql:Open-ILS/src/sql/Pg/2.0.0-2.0.1-upgrade-db.sql:328: ERROR: cannot change name of input parameter "dest_usr"
HINT: Use DROP FUNCTION first.
--------------------------------
Full log: http://paste.lisp.org/display/120006

It seems to be a 9.0 specific issue, looking in the release notes they talk about a change in section "E.4.2.4. Object Renaming".
http://www.postgresql.org/docs/9.0/static/release-9-0.html
http://wiki.postgresql.org/wiki/Illustrated_9_0#Named_Parameter_Calls

Other threads:
http://postgresql.1045698.n5.nabble.com/create-or-replace-function-no-longer-allows-parameters-td1976493.html
http://postgresql.1045698.n5.nabble.com/function-name-parameter-name-td2806381.html

[Anoop Atre (anoop-atre)]

Adding the DROP FUNCTION fixed the issue and I found no errors running 2.0.1-2.0.2-upgrade-db.sql to update to 2.0.2

[Anoop Atre (anoop-atre)]

Adding the DROP FUNCTION fixed the issue and I found no errors running 2.0.1-2.0.2-upgrade-db.sql to update to 2.0.2

[Mike Rylander (mrylander)]

Patch applied to rel_2_0, thanks much!