On Mon, Dec 21, 2009 at 3:06 PM, Adrian Klaver <aklaver@xxxxxxxxxxx> wrote: > > > > ----- "Scott Marlowe" <scott.marlowe@xxxxxxxxx> wrote: > >> 2009/12/21 Adrian Klaver <aklaver@xxxxxxxxxxx>: >> > >> > >> > >> > ----- "Filip Rembiałkowski" <plk.zuber@xxxxxxxxx> wrote: >> >> 2009/12/19 Ralph Graulich < ralph.graulich@xxxxxxxxxxx > >> >> >> >> >> >> >> >> >> >> -- Only one of the two relations is shown >> >> >> >> >> >> >> >> >> >> I would call it a bug. Reproduced here, on 8.4.2 and 8.3.8 >> >> >> >> >> >> >> >> >> > >> > Try \dt *.table1 >> >> While that should work, suppose you have three schemas with the same >> table, and your search path is set to look at two. \dt by itself >> should only show the two in your search path, so it's not equivalent, >> but it is handy... > > Interested in a definitive answer to this as I understood that the below held and that in order to see identical names in more than one schema you needed to schema qualify the names or use wildcards. > > http://www.postgresql.org/docs/8.4/static/runtime-config-client.html > When there are objects of identical names in different schemas, the one found first in the search path is used So, there are two parts of the docs that don't really agree with each other completely. While this behaviour seems natural and expected when running select, update, insert, alter and so on, it seems to be somewhat iffy in the case of \dt. I'm not sure which is the right behaviour. I'd lean towards listing the two tables with the same name in different schemas with schema.tablename notation for each one so you know which is which. I'm guessing that /dt is using search_path and takes the first one only right now. So, either the docs for \dt need fixing to reflect reality, or they're right and psql \dt needs fixing. -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
