Schema (Search path issue) on PostgreSQL9.2

From: chiru r <chirupg(at)gmail(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: Schema (Search path issue) on PostgreSQL9.2
Date: 2013-05-16 12:51:19
Message-ID: CA+RSxMiv8tMq66zrTkynZ9dEMHUmdqTB+OZR+Wg_N0Odz4q23g@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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();
version

---------------------------------------------------------------------------------------------------------------
PostgreSQL 9.2.4 on x86_64-unknown-linux-gnu, compiled by gcc (GCC) 4.1.2
20080704 (Red Hat 4.1.2-52), 64-bit
(1 row)

postgres=# \dn
List of schemas
Name | Owner
--------------------+----------
information_schema | postgres
pg_catalog | postgres
pg_toast | postgres
pg_toast_temp_1 | postgres
public | postgres
(5 rows)

postgres=# SET search_path to *chiru92*;
SET

*PostgreSQL9.1:*
++++++++++++

postgres=# select version();
version

---------------------------------------------------------------------------------------------------------------
PostgreSQL 9.1.9 on x86_64-unknown-linux-gnu, compiled by gcc (GCC) 4.1.2
20080704 (Red Hat 4.1.2-52), 64-bit
(1 row)

postgres=# \dn
List of schemas
Name | Owner
--------------------+----------
information_schema | postgres
pg_catalog | postgres
pg_toast | postgres
pg_toast_temp_1 | postgres
public | postgres
(5 rows)

postgres=# SET search_path to *chiru91*;
ERROR: invalid value for parameter "search_path": "chiru91"
DETAIL: schema "chiru91" does not exist

Please comment on below point.

Is there any schema(set search_path) behaviour changes from PostgreSQL9.1
to PostgreSQL9.2 ?, or Is there any schema(set search_path) issue in
PostgreSQL9.2 version?.

Thanks in Advance.

Best Regards,
Chiru

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Raghavendra 2013-05-16 13:01:37 Re: Schema (Search path issue) on PostgreSQL9.2
Previous Message David M. Kaplan 2013-05-16 12:47:28 problem with lost connection while running long PL/R query