Views an non-present column

Поиск
Список
Период
Сортировка
От Fabien SK
Тема Views an non-present column
Дата
Msg-id 1134237858.6696.15.camel@hobbes
обсуждение исходный текст
Ответы Re: Views an non-present column  (Bruno Wolff III <bruno@wolff.to>)
Список pgsql-novice
Hi everyone,

I am playing with Postgresql 8.0 (Mandriva 2006) and there is something
I don't understand. Let's assume that I have a table with some columns.
I create the following view:

CREATE VIEW vista as select name from mytable;

Then I check that everything is fine:

EXPLAIN select name from vista;

OK, I get a "Seq Scan on...".

but if I do:

EXPLAIN select mytable.name from vista;

I get an horrible:

 Nested Loop  (cost=17.70..9834.70 rows=490000 width=82)
   ->  Seq Scan on mytable  (cost=0.00..17.00 rows=700 width=0)
   ->  Materialize  (cost=17.70..24.70 rows=700 width=82)
         ->  Seq Scan on mytable  (cost=0.00..17.00 rows=700 width=82)


I also get the following notice:
NOTICE:  Ajout d'une entrée manquante dans FROM (table «mytable»)

Bad translation:
 adding an entry missing in the clause FROM (table «mytable»)

My question is: is there a way to prevent such a behaviour ? I would
like to get an error instead.

Cheers,
Fabien SK


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

Предыдущее
От: Michael Fuhr
Дата:
Сообщение: Re: Sorting empty rows at the bottom of a recordset
Следующее
От: Bruno Wolff III
Дата:
Сообщение: Re: Views an non-present column