Postgres Pro
Downloads
Home   >   mailing lists

Changing the number and type of columns in a view - Mailing list pgsql-general

From Russell Smith
Subject Changing the number and type of columns in a view
Date
Msg-id 4553180B.3000708@pws.com.au
Whole thread Raw
Responses Re: Changing the number and type of columns in a view
List pgsql-general
Tree view 
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

pgsql-general by date:

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