Why schema of table is removed from explain?

Поиск
Список
Период
Сортировка
От hubert depesz lubaczewski
Тема Why schema of table is removed from explain?
Дата
Msg-id 20110901180822.GA18044@depesz.com
обсуждение исходный текст
Ответы Re: Why schema of table is removed from explain?
Re: Why schema of table is removed from explain?
Список pgsql-general
example:
$ create schema x;
CREATE SCHEMA

$ create table x.y as select * from pg_class;
SELECT 294

$ explain select * from x.y limit 1;
                         QUERY PLAN
------------------------------------------------------------
 Limit  (cost=0.00..0.04 rows=1 width=189)
   ->  Seq Scan on y  (cost=0.00..13.70 rows=370 width=189)
(2 rows)

Why it doesn't show "Seq Scan on x.y" ? it makes certain plans virtually
useless, when you can't know which schema was used?!

Best regards,

depesz

--
The best thing about modern society is how easy it is to avoid contact with it.
                                                             http://depesz.com/

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

Предыдущее
От: Scott Marlowe
Дата:
Сообщение: Re: md5 of table
Следующее
От: "David Johnston"
Дата:
Сообщение: How to get around this limitation (ALTER DATABASE db SET search_path = ...)