Postgres Pro
Downloads
Home   >   mailing lists

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

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

--
  Heikki Linnakangas
  EnterpriseDB   http://www.enterprisedb.com

pgsql-bugs by date:

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