Skip site navigation (1) Skip section navigation (2)

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 (view raw or flat)
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

pgsql-bugs by date

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

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group