Re: upgrade path / versioning roles - Mailing list pgsql-hackers

Patrick Welche <prlw1@newn.cam.ac.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