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