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

From: Robert Haas <robertmhaas(at)gmail(dot)com>
To: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
Cc: Stephen Frost <sfrost(at)snowman(dot)net>, ash <ash(at)commandprompt(dot)com>, "pgsql-hackers(at)postgresql(dot)org" <pgsql-hackers(at)postgresql(dot)org>
Subject: Re: Re-create dependent views on ALTER TABLE ALTER COLUMN ... TYPE?
Date: 2014-06-03 20:31:55
Message-ID: CA+TgmoaFzxF4fHZf4RFatNuJjk9b8C5xjva3CSsymQUZAaV9DA@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

On Tue, Jun 3, 2014 at 10:14 AM, Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> wrote:
>> If we had such a mechanism,
>> then perhaps someone could build a UI providing the sort of user
>> feedback you're suggesting to help them use it more safely. But isn't
>> the core server support the first thing?
>
> 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.

--
Robert Haas
EnterpriseDB: http://www.enterprisedb.com
The Enterprise PostgreSQL Company

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Robert Haas 2014-06-03 20:38:11 Re: avoiding tuple copying in btree index builds
Previous Message Tom Lane 2014-06-03 20:24:58 Re: Hide 'Execution time' in EXPLAIN (COSTS OFF)