Hi, Consider the following sequence of commands in a psql session:
postgres=#create table public.sample(x int); postgres=#create schema new; postgres=#create table new.sample(x int); postgres=#set search_path=public,new; postgres=#\dt Schema | Name | Type | Owner ------------------------------------------- public | sample | table | postgres (1 row) We should have seen two entries in the above listing. So looks like a bug to me. The issue is with the call to pg_table_is_visible(). While scanning for the second entry, it breaks out because there is a matching entry with the same name in the first schema. What we need is a variation of this function which checks for visibility of the corresponding namespace in the search path and emit it out too if so. Thoughts? I can cook up a patch for this. Regards, Nikhils
