On Sun, 2002-07-14 at 21:19, Tom Lane wrote: > Rod Taylor <[EMAIL PROTECTED]> 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. ---------------------------(end of broadcast)--------------------------- TIP 2: you can get off all lists at once with the unregister command (send "unregister YourEmailAddressHere" to [EMAIL PROTECTED])