Re: plpgsql and Schemas

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: plpgsql and Schemas
Дата
Msg-id 6414.1026695974@sss.pgh.pa.us
обсуждение исходный текст
Ответ на plpgsql and Schemas  (Rod Taylor <rbt@zort.ca>)
Ответы Re: plpgsql and Schemas  (Rod Taylor <rbt@zort.ca>)
Список 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 по дате отправления:

Предыдущее
От: Tom Lane
Дата:
Сообщение: Re: PLPGSQL and Exceptions
Следующее
От: Rod Taylor
Дата:
Сообщение: Re: plpgsql and Schemas