Re: plpgsql and Schemas - Mailing list pgsql-hackers

From Tom Lane
Subject Re: plpgsql and Schemas
Date
Msg-id 6414.1026695974@sss.pgh.pa.us
Whole thread Raw
In response to plpgsql and Schemas  (Rod Taylor <rbt@zort.ca>)
Responses Re: plpgsql and Schemas  (Rod Taylor <rbt@zort.ca>)
List pgsql-hackers
Rod Taylor <rbt@zort.ca> writes:
> I've been running a few functions within schema's.  It's annoying that
> everything needs to be qualified as it doesn't allow the functions to be
> moved very easily.
> Would it be appropriate for the function to have it's own schema as
> pre-pended onto the user path while in the users function?

Hmm.  I can think of examples where you wouldn't want that (because
the function *should* see the caller's namespace) about as easily
as cases where you would.

If a function wants to access "its own schema", why shouldn't it
use qualified references?
        regards, tom lane


pgsql-hackers by date:

Previous
From: Tom Lane
Date:
Subject: Re: PLPGSQL and Exceptions
Next
From: Rod Taylor
Date:
Subject: Re: plpgsql and Schemas