| From: | Euler Taveira <euler(at)timbira(dot)com(dot)br> |
|---|---|
| To: | francois(at)teksol(dot)info, pgsql-bugs(at)postgresql(dot)org |
| Subject: | Re: BUG #14578: Tables with same name in different schema are not shown with \dt |
| Date: | 2017-03-04 15:10:36 |
| Message-ID: | de2f17fd-9a4f-064f-3587-204fead887f6@timbira.com.br |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-bugs |
On 04-03-2017 11:51, francois(at)teksol(dot)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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Tom Lane | 2017-03-04 15:17:44 | Re: BUG #14578: Tables with same name in different schema are not shown with \dt |
| Previous Message | francois | 2017-03-04 14:51:44 | BUG #14578: Tables with same name in different schema are not shown with \dt |