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

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

From: Peter Eisentraut <peter_e(at)gmx(dot)net>
To: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
Cc: pgsql-committers(at)postgresql(dot)org
Subject: Re: pgsql-server/ oc/src/sgml/runtime.sgml rc/back ...
Date: 2003-10-05 14:26:06
Message-ID: Pine.LNX.4.44.0310051619000.2745-100000@peter.localdomain (view raw, whole thread or download thread mbox)
Lists: pgsql-committerspgsql-hackers
Tom Lane writes:

> I think that issues like these are likely to arise for other sorts of
> checks than those on embedded SQL code.  For example, it probably
> wouldn't be unreasonable for a validator for brand-X-language to try to
> check the existence of referenced functions, even if those functions are
> called from code that doesn't look much like SQL.

Given that new languages don't tend to appear out of the blue, I think
it's reasonable to design the feature considering the languages currently
available.  We have sql, plpgsql, pltcl, plpython, plperl, plruby, plsh,
pljava, maybe something Scheme-based.  None of these languages except the
first two have anything to gain, but everything to lose, if they were
asked not to check the function body during a dump restore.  So do you
have anything more particular in mind?

> Would you like it better if the switch were called
> do_all_the_right_things_for_pg_dump?  (That name is a bit facetious, but
> in terms of long-term behavior that's pretty much what I'm after.)

Would that include altering all sorts of other behaviors, beyond the issue
of function bodies, to facilitate restoring dumps?  That might not be the
worst of ideas, but I'd rather see us improving pg_dump and keep the
relaxed behavior constrained to very well defined areas.

Peter Eisentraut   peter_e(at)gmx(dot)net

In response to


pgsql-hackers by date

Next:From: Bruce MomjianDate: 2003-10-05 14:28:31
Subject: Re: Thoughts on maintaining 7.3
Previous:From: Hans-Jürgen SchönigDate: 2003-10-05 13:41:07
Subject: Re: Question regarding coopting Database Engine

pgsql-committers by date

Next:From: Bruce MomjianDate: 2003-10-05 14:32:14
Subject: Re: pgsql-server/ oc/src/sgml/runtime.sgml rc/back ...
Previous:From: Bruce MomjianDate: 2003-10-05 14:25:29
Subject: pgsql-server/doc FAQ src/FAQ/FAQ.html

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