Re: [BUGS] BUG #14578: Tables with same name in different schema arenot shown with \dt

On 04-03-2017 11:51, francois@teksol.info wrote:
> In my schema, I happen to have two tables in different schemas with the same
> name. PG supports that no problem, but when I listed the tables using \dt
> and the search path set to both schemas, I expected to see the two tables.
> Sadly, that wasn't the case.
> 
It is not a bug. It is a documented behavior [1].

"An object is said to be visible if its containing schema is in the
search path and no object of the same kind and name appears earlier in
the search path."


[1] https://www.postgresql.org/docs/9.6/static/app-psql.html


-- 
   Euler Taveira                   Timbira - http://www.timbira.com.br/
   PostgreSQL: Consultoria, Desenvolvimento, Suporte 24x7 e Treinamento


-- 
Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-bugs