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