> Le 4 mars 2017 à 10:10, Euler Taveira <euler@timbira.com.br> a écrit :
>
> 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
Oh, OK. That was surprising. I don't usually have tables with the same name in different schemas.
Thanks for the quick replies!
François
--
Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-bugs