Re: Have psql display names and OUT/INOUT in \df output - Mailing list pgsql-patches

From Neil Conway
Subject Re: Have psql display names and OUT/INOUT in \df output
Date
Msg-id 1153052218.5069.17.camel@localhost
Whole thread Raw
In response to Re: Have psql display names and OUT/INOUT in \df output  (David Fetter <david@fetter.org>)
Responses Re: Have psql display names and OUT/INOUT in \df output
List pgsql-patches
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



pgsql-patches by date:

Previous
From: David Fetter
Date:
Subject: Re: Have psql display names and OUT/INOUT in \df output
Next
From: Andreas Seltenreich
Date:
Subject: Re: Restartable Recovery