* Tom Lane ([EMAIL PROTECTED]) wrote: > Stephen Frost <[EMAIL PROTECTED]> writes: > > It would be useful to have a function which could be passed a relative > > (to the caller's search path) object name and would return the fully > > qualified name of that object. In this way, functions could be written > > which take relative arguments from the user but *only* those explicitly > > checked for. > > Your example doesn't seem to be doing anything interesting ... am I > misunderstanding, or did you omit the actual checking? Also, if the > search path is controlled by the function, what good is this --- > wouldn't it always result in a trusted schema?
The idea was that 'pg_getfullpath()' would return the full path to an object relative to the caller's path while in a function which has an explicit search_path defined. Probably more sensible is an example of what I'm thinking the function would do: postgres=# create schema myschema; CREATE SCHEMA postgres=# set search_path=myschema; SET postgres=# create table abc (a int); CREATE TABLE postgres=# select pg_getfullpath('abc'); fullpath ---------- myschema.abc The 'special' bit here is that pg_getfullpath() would work relative to the caller's search_path even inside of a function which has its 'PATH' set. That's really the only thing about it that makes it very interesting. Of course, thinking a bit farther along, this would only be useful when building up an SQL statement as a string to then execute, but you have to do that if you're getting a table passed in as an argument anyway (and is exactly what I'm doing). Hope that helps. Thanks, Stephen
Description: Digital signature