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 28663.1401828238@sss.pgh.pa.us
обсуждение исходный текст
Ответ на Re: Re-create dependent views on ALTER TABLE ALTER COLUMN ... TYPE?  (Robert Haas <robertmhaas@gmail.com>)
Список pgsql-hackers
Robert Haas <robertmhaas@gmail.com> writes:
> On Tue, Jun 3, 2014 at 10:14 AM, Tom Lane <tgl@sss.pgh.pa.us> wrote:
>> I'm guessing you did not read
>> http://www.postgresql.org/message-id/18723.1401734537@sss.pgh.pa.us

> Argh, sorry, I saw that go by and it went past my eyes but obviously I
> didn't really absorb it.  I guess we could do it that way.  But it
> seems like quite a hassle to me; I think we're going to continue to
> get complaints here until this is Easy.  And if it can't be made Easy,
> then we're going to continue to get complaints forever.

Well, my vision of it is that it *is* easy, if you're using the tool
(or, perhaps, one of several tools), and you have a case that doesn't
really require careful semantic review.  But trying to build this sort
of thing into the backend is the wrong approach: it's going to lead
to unpleasant compromises and/or surprises.  And we'd still have to
build that tool someday.
        regards, tom lane



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

Предыдущее
От: Peter Eisentraut
Дата:
Сообщение: Re: json casts
Следующее
От: Tom Lane
Дата:
Сообщение: Re: json casts