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

2013-05-16 Thread Tom Lane
chiru r 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 sp

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

2013-05-16 Thread Raghavendra
> postgres=# select version(); > version > > > --- > PostgreSQL 9.2.4 on x86_64-unknown-linux-gnu, compiled by gcc (GCC) 4.1.2 > 20080704

[GENERAL] Schema (Search path issue) on PostgreSQL9.2

2013-05-16 Thread chiru r
Hi All, I have seen strange behaviour in PostgreSQL9.2 version,it has been allowing to set search path any name,even the name is not created as a schema in database. Please find the below case between PostgreSQL9.1 and PostgreSQL9.2. *PostgreSQL9.2:* + postgres=# select version();