chiru r <chirupg@xxxxxxxxx> 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 all databases. regards, tom lane -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general