Re: BUG #3597: CREATE OR REPLACE VIEW

Поиск
Список
Период
Сортировка
Искать
От
Luiz K. Matsumura
Тема
Re: BUG #3597: CREATE OR REPLACE VIEW
Дата
Msg-id
46DD1244.9090503@planit.com.br
Ответ на
Список
Дерево обсуждения
BUG #3597: CREATE OR REPLACE VIEW "Luiz K. Matsumura" <luiz@planit.com.br>
Re: BUG #3597: CREATE OR REPLACE VIEW Reece Hart <reece@harts.net>
Re: BUG #3597: CREATE OR REPLACE VIEW "Heikki Linnakangas" <heikki@enterprisedb.com>
Re: BUG #3597: CREATE OR REPLACE VIEW "Luiz K. Matsumura" <luiz@planit.com.br>
Re: BUG #3597: CREATE OR REPLACE VIEW "Heikki Linnakangas" <heikki@enterprisedb.com>
Re: BUG #3597: CREATE OR REPLACE VIEW Tom Lane <tgl@sss.pgh.pa.us>
Re: BUG #3597: CREATE OR REPLACE VIEW "Luiz K. Matsumura" <luiz@planit.com.br>
Heikki Linnakangas wrote:
> Luiz K. Matsumura wrote:
>   
>> When we do a command Create or Replace View that change columns of previous
>> view we got a error.
>>     
>
> Right. You can't change the data types of an existing view. You'll have
> to drop and recreate it.
>
>   
But, with  the 'replace' command, this isn't implicit ?
If they found a view, replace the existing view with the new one (on the 
other words, drop and create again?)

-- 
Luiz K. Matsumura
Plan IT Tecnologia Informática Ltda.
В списке pgsql-bugs по дате отправления
От: Luiz K. Matsumura
Дата:
От: Heikki Linnakangas
Дата:
FAQ