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

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: chiru r <chirupg(at)gmail(dot)com>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: Schema (Search path issue) on PostgreSQL9.2
Date: 2013-05-16 13:45:32
Message-ID: 12646.1368711932@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

chiru r <chirupg(at)gmail(dot)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 all databases.

regards, tom lane

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Jeff Janes 2013-05-16 13:56:07 Re: Running out of memory at vacuum
Previous Message Tom Lane 2013-05-16 13:42:51 Re: problem with lost connection while running long PL/R query