Michael Fuhr <mike@fuhr.org> writes:
> In an already-loaded database, I think the following should work:
> UPDATE pg_language SET lanvalidator = 'plpgsql_validator'::regproc
> WHERE lanname = 'plpgsql';
> Tom (or anybody else), are there any gotchas with updating pg_language
> like this? It works for me in simple tests.
That would not create a dependency from the language to the validator,
but in practice you probably don't care about that. The bigger problem
for Tony is likely to be that plpgsql_validator() doesn't exist as a
function in his database; he'll have to create it (see createlang -e
for a reference) first.
regards, tom lane