Re: 8.1 and syntax checking at create time

Hi,

I did restore from a 8.0 dump.

here is the output from the query:

lanname  | lanplcallfoid |     lanplcallfoid      | lanvalidator |         lanvalidator
----------+---------------+------------------------+--------------+------------------------------internal |
0| -                      |         2246 | fmgr_internal_validator(oid)c        |             0 | -
|         2247 | fmgr_c_validator(oid)sql      |             0 | -                      |         2248 |
fmgr_sql_validator(oid)plperlu |         16392 | plperl_call_handler()  |            0 | -plpgsql  |         16394 |
plpgsql_call_handler()|            0 | -
 
(5 rows)


here is my version string:

PostgreSQL 8.1beta1 on i686-pc-linux-gnu, compiled by GCC i686-pc-linux-gnu-gcc (GCC) 3.3.5-20050130 (Gentoo Linux
3.3.5.20050130-r1,ssp-3.3.5.20050130-1, pie-8.7.7.1)
 

I am trying my tests on a new database with fresh language install now.

How can I get my restored databases to behave the same as a fresh one?

Thanks for your help on this.

Tony