Changing the number and type of columns in a view

Поиск
Список
Период
Сортировка
От Russell Smith
Тема Changing the number and type of columns in a view
Дата
Msg-id 4553180B.3000708@pws.com.au
обсуждение исходный текст
Ответы Re: Changing the number and type of columns in a view  (Richard Huxton <dev@archonet.com>)
Список 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

В списке pgsql-general по дате отправления:

Предыдущее
От: Jorge Godoy
Дата:
Сообщение: Re: Can PostgreSQL notify a client that a trigger has fired?
Следующее
От: "Thomas H."
Дата:
Сообщение: Re: planer picks a bad plan (seq-scan instead of index) when adding an additional join