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



---------------------------(end of broadcast)---------------------------
TIP 1: if posting/reading through Usenet, please send an appropriate
       subscribe-nomail command to [EMAIL PROTECTED] so that your
       message can get through to the mailing list cleanly

Reply via email to