Skip site navigation (1) Skip section navigation (2)

Re: BUG #3597: CREATE OR REPLACE VIEW

From: "Heikki Linnakangas" <heikki(at)enterprisedb(dot)com>
To: "Luiz K(dot) Matsumura" <luiz(at)planit(dot)com(dot)br>
Cc: <pgsql-bugs(at)postgresql(dot)org>
Subject: Re: BUG #3597: CREATE OR REPLACE VIEW
Date: 2007-09-04 07:49:43
Message-ID: 46DD0E17.80703@enterprisedb.com (view raw or flat)
Thread:
Lists: pgsql-bugs
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

In response to

Responses

pgsql-bugs by date

Next:From: Luiz K. MatsumuraDate: 2007-09-04 08:03:29
Subject: BUG #3598: Strange behaviour of character columns in select with views
Previous:From: Luiz K. MatsumuraDate: 2007-09-04 07:42:59
Subject: BUG #3597: CREATE OR REPLACE VIEW

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group