how to modify a view - Mailing list pgsql-general

From J. Manuel Velasco - UBILIBET
Subject how to modify a view
Date
Msg-id 4832FBAB.9030301@ubilibet.com
Whole thread Raw
Responses Re: how to modify a view  (Shane Ambler <pgsql@Sheeky.Biz>)
List pgsql-general
Hello,

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,
--
Attachment

pgsql-general by date:

Previous
From: "Joshua D. Drake"
Date:
Subject: Re: psql: FATAL: Ident authentication failed for user"postgres"
Next
From: Karsten Hilbert
Date:
Subject: Re: psql: FATAL: Ident authentication failed for user"postgres"