Re: plpgsql and Schemas

Rod Taylor 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?

The SQL standard has rules on how the effective schema path during a
function execution is determined. In a nutshell, it allows you to specify
the path as an attribute of the containing schema. E.g.,

CREATE SCHEMA foo PATH here, there;

I haven't thought this through, but you might want to think about it.

--
Peter Eisentraut peter_e(at)gmx(dot)net