Re: plpgsql and Schemas
От | Rod Taylor |
---|---|
Тема | Re: plpgsql and Schemas |
Дата | |
Msg-id | 1026696432.30427.188.camel@jester обсуждение исходный текст |
Ответ на | Re: plpgsql and Schemas (Tom Lane <tgl@sss.pgh.pa.us>) |
Список | pgsql-hackers |
On Sun, 2002-07-14 at 21:19, Tom Lane wrote: > 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? I was thinking of the effort put into pg_dump to prevent over qualifying references in order to allow the user to move stuff easily. It's not a big deal, but does prevent this ability with functions.
В списке pgsql-hackers по дате отправления: