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

Re: 8.1 and syntax checking at create time

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Michael Fuhr <mike(at)fuhr(dot)org>
Cc: Andrew Dunstan <andrew(at)dunslane(dot)net>,Tony Caduto <tony_caduto(at)amsoftwaredesign(dot)com>,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 20:23:44
Message-ID: 4456.1125519824@sss.pgh.pa.us (view raw or flat)
Thread:
Lists: pgsql-hackers
Michael Fuhr <mike(at)fuhr(dot)org> writes:
> In an already-loaded database, I think the following should work:

> UPDATE pg_language SET lanvalidator = 'plpgsql_validator'::regproc
> WHERE lanname = 'plpgsql';

> Tom (or anybody else), are there any gotchas with updating pg_language
> like this?  It works for me in simple tests.

That would not create a dependency from the language to the validator,
but in practice you probably don't care about that.  The bigger problem
for Tony is likely to be that plpgsql_validator() doesn't exist as a
function in his database; he'll have to create it (see createlang -e
for a reference) first.

			regards, tom lane

In response to

Responses

pgsql-hackers by date

Next:From: Michael FuhrDate: 2005-08-31 20:39:47
Subject: Re: 8.1 and syntax checking at create time
Previous:From: Tony CadutoDate: 2005-08-31 20:13:02
Subject: Re: 8.1 and syntax checking at create time

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