BUG #5838: tables of the same name in different schemas - Mailing list pgsql-bugs

From Tyler Kellen
Subject BUG #5838: tables of the same name in different schemas
Date
Msg-id 201101140807.p0E87PFN053886@wwwmaster.postgresql.org
Whole thread Raw
Responses Re: BUG #5838: tables of the same name in different schemas
List pgsql-bugs
The following bug has been logged online:

Bug reference:      5838
Logged by:          Tyler Kellen
Email address:      tyler@sleekcode.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

pgsql-bugs by date:

Previous
From: Alex Hunsaker
Date:
Subject: Re: BUG #5835: PL/Python crashes
Next
From: Heikki Linnakangas
Date:
Subject: Re: BUG #5838: tables of the same name in different schemas