Re: Schema + search path problem

Thanks Tom, that's cleared up both issues.

You're right about the docs - I couldn't find the material in the 7.4 docs
because I wasn't sure where to look.

A full text index (web app showcasing Postgres's full test search
capabilities) of the latest docs would be great! ... please don't say
"google" :)

Thanks for your help.

John

Tom Lane said:
> "John Sidney-Woollett" <johnsw@wardbrook.com> writes:
>> Is there a way to set the default search path for the user 'FRED'
>> permanently?
>
> See ALTER USER.  You can set per-user or per-database defaults for any
> SETtable variable, not only search_path.
>
>> 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)?
>
> It's a good idea.  At the moment a function body is interpreted with the
> call-time value of search_path.  We've batted around the idea that it
> should use the creation-time path, but nothing's been done about it.
>
>> ps Is the 7.4 documentation less detailed on schemas than the 7.3
>> docs?
>
> I don't believe we've removed anything; rearranged, perhaps.  Does
> http://www.postgresql.org/docs/current/static/ddl-schemas.html
> not cover the same ground that's in the 7.3 docs?
>
>             regards, tom lane
>