Re: 8.1 and syntax checking at create time

Michael Fuhr <mike(at)fuhr(dot)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