On Wednesday 22 October 2003 20:12, scott.marlowe wrote:
> On Wed, 22 Oct 2003, Tom Lane wrote:
> > It would probably be a good idea to allow the function's search path to
> > be explicitly specified as a clause of CREATE FUNCTION (otherwise it
> > will be a headache for pg_dump). So we could allow both viewpoints,
> > if there is a way to explicitly say "don't force any search path".
> > Perhaps specifying an empty path could mean that. But I think the
> > default should be to adopt the current search path (at the time of
> > CREATE FUNCTION) as the function's permanent path.
>
> It might be nice to have an alter function capability that could change
> the search path at a later date should one add schema etc... later on.
If it's part of CREATE FUNCTION then presumably CREATE OR REPLACE FUNCTION
would let you do that (it's not changing the signature of the function, so I
can't think why not).
-- Richard Huxton Archonet Ltd