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