Re: BUG #3597: CREATE OR REPLACE VIEW - Mailing list pgsql-bugs

From Luiz K. Matsumura
Subject Re: BUG #3597: CREATE OR REPLACE VIEW
Date
Msg-id 46DD1244.9090503@planit.com.br
Whole thread Raw
In response to Re: BUG #3597: CREATE OR REPLACE VIEW  ("Heikki Linnakangas" <heikki@enterprisedb.com>)
Responses Re: BUG #3597: CREATE OR REPLACE VIEW  ("Heikki Linnakangas" <heikki@enterprisedb.com>)
List pgsql-bugs
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 by date:

Previous
From: "Luiz K. Matsumura"
Date:
Subject: BUG #3598: Strange behaviour of character columns in select with views
Next
From: "Heikki Linnakangas"
Date:
Subject: Re: BUG #3597: CREATE OR REPLACE VIEW