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
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 |