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
---------------------------(end of broadcast)---------------------------
TIP 9: In versions below 8.0, the planner will ignore your desire to
choose an index scan if your joining column's datatypes do not
match
