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

Re: pgsql-server/ oc/src/sgml/runtime.sgml rc/back ...

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Peter Eisentraut <peter_e(at)gmx(dot)net>
Cc: pgsql-committers(at)postgresql(dot)org
Subject: Re: pgsql-server/ oc/src/sgml/runtime.sgml rc/back ...
Date: 2003-10-04 03:55:42
Message-ID: 3115.1065239742@sss.pgh.pa.us (view raw or flat)
Thread:
Lists: pgsql-committerspgsql-hackers
Peter Eisentraut <peter_e(at)gmx(dot)net> writes:
> Tom Lane writes:
>> Add GUC parameter check_function_bodies to control whether validation
>> of function bodies is done at CREATE FUNCTION time.

> If it's only honored by SQL functions, then it should probably be called
> check_sql_function_bodies.

I thought about that while I was making the patch, but decided that it
would be a very un-forward-looking name.  Someday we will probably have
syntax-checking validators for plpgsql, etc.

The original version of the patch actually suppressed calling the
validator altogether, but I soon realized that wouldn't do --- it
would allow you to create SQL functions with unsupported pseudotype
arguments or results, for example.  Further thought led me to decide
explicitly not to suspend checking of internal and C function
references, on the grounds that if they are broken they'd still be
broken at the completion of the restore script, and so we'd only
be losing the ability to report the problem.

So the fact that it only affects SQL functions at the moment is IMHO
just happenstance; the scope of what it does will change as we add more
validation capability.

			regards, tom lane

In response to

Responses

pgsql-hackers by date

Next:From: Mark KirkwoodDate: 2003-10-04 06:50:03
Subject: Re: Oracle/PostgreSQL incompatibilities
Previous:From: Bruce MomjianDate: 2003-10-04 03:42:00
Subject: Re: Thoughts on maintaining 7.3

pgsql-committers by date

Next:From: Peter Eisentraut - PostgreSQLDate: 2003-10-04 18:09:10
Subject: pgsql-server/src/backend/po hr.po
Previous:From: Bruce MomjianDate: 2003-10-04 03:14:14
Subject: pgsql-server/ /INSTALL oc/src/sgml/installatio ...

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