Re: plpgsql and Schemas

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