Re: Confusing EXPLAIN output in case of inherited tables

Поиск
Список
Период
Сортировка
От Ashutosh Bapat
Тема Re: Confusing EXPLAIN output in case of inherited tables
Дата
Msg-id CAFjFpRf-Tzo=eO_EFn07ZmsRrmqi2X06Pv6G8hg0JaHAzeB5iQ@mail.gmail.com
обсуждение исходный текст
Ответ на Re: Confusing EXPLAIN output in case of inherited tables  (Tom Lane <tgl@sss.pgh.pa.us>)
Список pgsql-hackers
Дерево обсуждения
I don't believe that the problem has anything to do with the names of
other tables that might happen to exist in the database.  It's a matter
of what RTE names/aliases are exposed for variable references in
different parts of the query.


Names of other tables come into picture when we schema qualify the fake aliases in the generated query. See examples in first post.
 
                       regards, tom lane



--
Best Wishes,
Ashutosh Bapat
EntepriseDB Corporation
The Enterprise Postgres Company

В списке pgsql-hackers по дате отправления:

Предыдущее
От: Josh Berkus
Дата:
Сообщение: Re: [GENERAL] Why extract( ... from timestamp ) is not immutable?
Следующее
От: Tom Lane
Дата:
Сообщение: Re: [GENERAL] pg_dump -s dumps data?!