Re: Schema (Search path issue) on PostgreSQL9.2

chiru r <chirupg@gmail.com> writes:
> Is there any schema(set search_path) behaviour changes from  PostgreSQL9.1
> to PostgreSQL9.2 ?

Please read the release notes when updating to a new major version.
The first item under "Server Settings" in the 9.2 release notes is:

    Silently ignore nonexistent schemas specified in search_path (Tom Lane)

    This makes it more convenient to use generic path settings, which might include some schemas that don't exist in
alldatabases. 


            regards, tom lane