Re: ALTER TABLE ... NOREWRITE option

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: ALTER TABLE ... NOREWRITE option
Дата
Msg-id 2105.1354589073@sss.pgh.pa.us
обсуждение исходный текст
Ответ на Re: ALTER TABLE ... NOREWRITE option  (Josh Berkus <josh@agliodbs.com>)
Ответы Re: ALTER TABLE ... NOREWRITE option
Список pgsql-hackers
Josh Berkus <josh@agliodbs.com> writes:
>> EXPLAIN ALTER TABLE would be the next step I guess. I discovered plenty
>> of magic tricks when working on the rewriting support for that command,
>> and I think exposing them in the EXPLAIN output would go a long way
>> towards reducing some POLA violations.

> I think this would be cool on its own merits.

> However, for a very large user group -- users with ORMs which do their
> own DDL migrations -- we could also use a way to log or WARN for table
> rewrites.  Since the ORMs are not gonna do an EXPLAIN.

An ORM is also quite unlikely to pay attention to a warning, much less a
postmaster log entry ... so your argument seems unfounded from here.
        regards, tom lane



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

Предыдущее
От: Josh Berkus
Дата:
Сообщение: Re: ALTER TABLE ... NOREWRITE option
Следующее
От: Andrew Dunstan
Дата:
Сообщение: Re: json accessors