Schema + search path problem
От | John Sidney-Woollett |
---|---|
Тема | Schema + search path problem |
Дата | |
Msg-id | 1125.192.168.0.64.1071160429.squirrel@mercury.wardbrook.com обсуждение исходный текст |
Ответ на | Re: ERROR: did not find '}' at end of input node (again) (Tom Lane <tgl@sss.pgh.pa.us>) |
Ответы |
Re: Schema + search path problem
|
Список | pgsql-general |
I'm slightly confused by schemas and search paths... I'm using Postgres 7.4, and have broken my original test database into various schemas now. Using google I found a reference to a 7.3 document that provided quite a lot of information on schemas (in the section on SQL syntax). It appears that by default, the search path is a schema the same as your login name, and then public. I have created the schema in a database as the postgres user, and also created all that schema's objects (as the postgres user). Later I will connect to the schema via another user (say 'FRED') (who will have appropriate access rights to the objects in the schema). Question 1 ========== Is there a way to set the default search path for the user 'FRED' permanently? Or do you have to reset the search path (and/or default schema) for each new session? Question 2 ========== If I am the postgres user and creating a function (for example) in a given schema, do I have to qualify ALL the objects referred to in the function by the schema prefix (if I don't want them in the public schema)? And if I use the "SET search_path TO schema" command, am I still required to be explicit about the schema name for objects referred to in a newly created function? Thanks for shedding any light on the above. John Sidney-Woollett ps Is the 7.4 documentation less detailed on schemas than the 7.3 docs? Or have I missed a section somewhere?
В списке pgsql-general по дате отправления: