Re: upgrade path / versioning roles

Patrick Welche <prlw1(at)newn(dot)cam(dot)ac(dot)uk> writes:
> I tried the fix mentioned in the earlier message to encourage
> validation. Now dumping this "fixed" database, and loadinging it into the
> new database gives:

> ALTER FUNCTION
> psql:./huge.db:4403: ERROR: function plpgsql_validator(oid) does not exist
> CREATE FUNCTION
> ALTER FUNCTION
> psql:./huge.db:4517: ERROR: language "plpgsql" does not exist
> HINT: You need to use "createlang" to load the language into the database.

Ah, right, *that's* why it's a good idea to have the dependency from the
language to the function ;-) ... else there's no guarantee pg_dump will
dump them in the right order. If you want you could add a suitable
pg_depend row.

regards, tom lane