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
> postgres=# select version();
> version
>
>
> ---
> PostgreSQL 9.2.4 on x86_64-unknown-linux-gnu, compiled by gcc (GCC) 4.1.2
> 20080704
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();