| From: | Tony Caduto <tony_caduto(at)amsoftwaredesign(dot)com> |
|---|---|
| To: | Michael Fuhr <mike(at)fuhr(dot)org> |
| Cc: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>, Alvaro Herrera <alvherre(at)alvh(dot)no-ip(dot)org>, PG Hackers <pgsql-hackers(at)postgresql(dot)org> |
| Subject: | Re: 8.1 and syntax checking at create time |
| Date: | 2005-08-31 19:14:11 |
| Message-ID: | 43160183.90405@amsoftwaredesign.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-hackers |
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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Tom Lane | 2005-08-31 19:17:49 | Re: 8.1 and syntax checking at create time |
| Previous Message | Josh Berkus | 2005-08-31 18:59:47 | Re: 8.1 and syntax checking at create time |