I just found out the databases on 8.0 where originally restored from a
7.4 server, so it seems I have never had the
lanvalidator function even while running on 8.0 for the last 10 months :-(
So how can I update my restored databases, i tried dropping the
language, but it wouldn't let me becasuse of dependent objects.
Are you using a database that was restored from an earlier version
>of PostgreSQL? I wonder if you're not getting the lanvalidator
>function. What's the result of the following query?
> lanplcallfoid, lanplcallfoid::regprocedure,
> lanvalidator, lanvalidator::regprocedure
>What happens if you create a fresh database and run "createlang
>plpgsql" in it, and then run your tests?
In response to
pgsql-hackers by date
|Next:||From: Andrew Dunstan||Date: 2005-08-31 19:37:21|
|Subject: Re: 8.1 and syntax checking at create time|
|Previous:||From: Tom Lane||Date: 2005-08-31 19:29:30|
|Subject: Re: 8.1 and syntax checking at create time |