BUG #5838: tables of the same name in different schemas

From: "Tyler Kellen" <tyler(at)sleekcode(dot)net>
To: pgsql-bugs(at)postgresql(dot)org
Subject: BUG #5838: tables of the same name in different schemas
Date: 2011-01-14 08:07:25
Message-ID: 201101140807.p0E87PFN053886@wwwmaster.postgresql.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs


The following bug has been logged online:

Bug reference: 5838
Logged by: Tyler Kellen
Email address: tyler(at)sleekcode(dot)net
PostgreSQL version: 9.0.2
Operating system: Win7 64
Description: tables of the same name in different schemas
Details:

Given two objects of the same name in different schemas, when both schemas
are in the search_path, \d only shows the object from the first schema
listed.

Reproduction:
CREATE SCHEMA s1;
CREATE SCHEMA s2;
CREATE TABLE s1.test ( id int );
CREATE TABLE s2.test ( id int );
SET search_path TO s1,s2;
\d
SET search_path TO s2,s1;
\d

Responses

Browse pgsql-bugs by date

  From Date Subject
Next Message Heikki Linnakangas 2011-01-14 11:12:12 Re: BUG #5838: tables of the same name in different schemas
Previous Message Alex Hunsaker 2011-01-14 06:33:17 Re: BUG #5835: PL/Python crashes