Re: Re-create dependent views on ALTER TABLE ALTER COLUMN ... TYPE?

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: Re-create dependent views on ALTER TABLE ALTER COLUMN ... TYPE?
Дата
Msg-id 17111.1401730612@sss.pgh.pa.us
обсуждение исходный текст
Ответ на Re: Re-create dependent views on ALTER TABLE ALTER COLUMN ... TYPE?  (Robert Haas <robertmhaas@gmail.com>)
Ответы Re: Re-create dependent views on ALTER TABLE ALTER COLUMN ... TYPE?
Re: Re-create dependent views on ALTER TABLE ALTER COLUMN ... TYPE?
Список pgsql-hackers
Robert Haas <robertmhaas@gmail.com> writes:
> On Mon, Jun 2, 2014 at 10:21 AM, Tom Lane <tgl@sss.pgh.pa.us> wrote:
>> The real problem in my mind is one of user expectations.  If the database
>> silently does something behind your back, people expect that that action
>> will be *right* and they don't have to worry about it.  I don't think
>> that automatically reparsing views has much chance of clearing that bar.

> I agree, but I think it's important to note that Alex's complaint is
> not unique - the way things work now is a real source of frustration
> for users.

Oh, I quite agree with that.  My concern here has to do with automatically
and silently making changes that we can't be very sure will meet the
user's expectations.  Perhaps what we need is some kind of UI/API design
whereby the user can inspect/modify/approve the semantic changes in
advance of pushing the red button.
        regards, tom lane



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

Предыдущее
От: Andres Freund
Дата:
Сообщение: Re: recovery testing for beta
Следующее
От: Peter Geoghegan
Дата:
Сообщение: Re: Jsonb: jbvBinary usage in the convertJsonbValue?