Changing the number and type of columns in a view

From: Russell Smith <mr-russ(at)pws(dot)com(dot)au>
To: pgsql-general(at)postgresql(dot)org
Subject: Changing the number and type of columns in a view
Date: 2006-11-09 11:59:07
Message-ID: 4553180B.3000708@pws.com.au
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Hi General,

Is there a reason why it is not possible to redefine a view with a
different number of columns or a different column type?

It's been possible to change the datatypes of a table, and the column
numbers for a long time. What are the restrictions on making this
possible for views.

I know you can drop an recreate the view, but if the view has dependent
objects it becomes more difficult.

I'm currently running 8.1 when I say it's not possible.

Thanks

Russell Smith

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Thomas H. 2006-11-09 11:59:33 Re: planer picks a bad plan (seq-scan instead of index) when adding an additional join
Previous Message Jorge Godoy 2006-11-09 11:43:11 Re: Can PostgreSQL notify a client that a trigger has fired?