On Sun, 2006-07-16 at 01:00 -0700, David Fetter wrote:
> On Sun, Jul 16, 2006 at 12:21:12AM -0700, Neil Conway wrote:
> > You need to schema-qualify references to builtin functions, to avoid
> > accidentally using functions of the same name that appear earlier in
> > the user's search path.
>
> I don't understand what you mean here.
For example, you shouldn't be using "generate_series" in the SQL query:
if the user has a function of the same name earlier in their search
path, psql will invoke the wrong function. Instead, you should call
"pg_catalog.generate_series", as psql was careful to do prior to the
patch.
-Neil