Re: BUG #3597: CREATE OR REPLACE VIEW

From: "Luiz K(dot) Matsumura" <luiz(at)planit(dot)com(dot)br>
To: Heikki Linnakangas <heikki(at)enterprisedb(dot)com>
Cc: pgsql-bugs(at)postgresql(dot)org
Subject: Re: BUG #3597: CREATE OR REPLACE VIEW
Date: 2007-09-04 08:07:32
Message-ID: 46DD1244.9090503@planit.com.br
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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.

In response to

Responses

Browse pgsql-bugs by date

  From Date Subject
Next Message Heikki Linnakangas 2007-09-04 08:22:07 Re: BUG #3597: CREATE OR REPLACE VIEW
Previous Message Luiz K. Matsumura 2007-09-04 08:03:29 BUG #3598: Strange behaviour of character columns in select with views