J. Manuel Velasco - UBILIBET wrote:
> The DB I am using has views. I need to modify the view adding one
> field to the QUERY that build the query.
> When I edit the VIEW and add the field, I get the error that tells me
> "It's not possible to change columns number in a view"
> So, do I need to remove the complete VIEW and create a new one ? Or
> there is other way to modify the view. ?¿
> Thanks in advance, --
Yes - The only way to do it is DROP VIEW... then CREATE VIEW... - the
catch is any other views that depend on the view you wish to drop.
You can only replace a view with a new query that generates the
identical set of columns (i.e., same column names and data types).
pgSQL (at) Sheeky (dot) Biz
Get Sheeky @ http://Sheeky.Biz
In response to
pgsql-general by date
|Next:||From: Karsten Hilbert||Date: 2008-05-20 17:35:44|
|Subject: Re: psql: FATAL: Ident authentication failedforuser"postgres"|
|Previous:||From: Dan Joo||Date: 2008-05-20 16:47:55|
|Subject: Re: psql: FATAL: Ident authentication failed foruser"postgres"|