Re: [BUGS] BUG #5838: tables of the same name in different schemas

2011-01-14 Thread Tom Lane
Heikki Linnakangas writes: > On 14.01.2011 10:07, Tyler Kellen wrote: >> 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. > That's intentional. \d lists the object that are currently vis

Re: [BUGS] BUG #5838: tables of the same name in different schemas

2011-01-14 Thread Heikki Linnakangas
On 14.01.2011 10:07, Tyler Kellen wrote: 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.te

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

2011-01-14 Thread Tyler Kellen
The following bug has been logged online: Bug reference: 5838 Logged by: Tyler Kellen Email address: ty...@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 sa