Re: 8.1 and syntax checking at create time

Tom,
I successfully updated my database to use the validator function without
dropping it using:

CREATE FUNCTION "plpgsql_validator" (oid) RETURNS void AS
'$libdir/plpgsql' LANGUAGE C;
UPDATE pg_language SET lanvalidator = 'plpgsql_validator'::regproc
WHERE lanname = 'plpgsql';

The create checking is *much* better now :-)

Thanks to everyone for helping me track this down, turned out it had
nothing to do with 8.1 but I didn't know that.
Sorry about that.

Tony

>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
>
>
>