Patrick Welche <[EMAIL PROTECTED]> 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 ---------------------------(end of broadcast)--------------------------- TIP 5: don't forget to increase your free space map settings