Skip site navigation (1) Skip section navigation (2)

Re: 8.1 and syntax checking at create time

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 (view raw or flat)
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



In response to

Responses

pgsql-hackers by date

Next:From: Tom LaneDate: 2005-08-31 19:17:49
Subject: Re: 8.1 and syntax checking at create time
Previous:From: Josh BerkusDate: 2005-08-31 18:59:47
Subject: Re: 8.1 and syntax checking at create time

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group