Re: Skip ExecCheckRTPerms in CTAS with no data

Поиск
Список
Период
Сортировка
От Michael Paquier
Тема Re: Skip ExecCheckRTPerms in CTAS with no data
Дата
Msg-id 20201111063525.GF2276@paquier.xyz
обсуждение исходный текст
Ответ на Re: Skip ExecCheckRTPerms in CTAS with no data  (Anastasia Lubennikova <a.lubennikova@postgrespro.ru>)
Ответы Re: Skip ExecCheckRTPerms in CTAS with no data
Список pgsql-hackers
On Mon, Nov 09, 2020 at 10:48:09PM +0300, Anastasia Lubennikova wrote:
> I see Tom's objection above. Still, I tend to agree that if 'WITH NO DATA'
> was specified explicitly, CREATE AS should behave more like a utility
> statement rather than a regular query. So I think that this patch can be
> useful in some use-cases and I definitely don't see any harm it could cause.
> Even the comment in the current code suggests that it is an option.

I agree with Tom's point to leave this stuff alone, and just remove
this XXX comment.  An extra issue I can see is that you would bypass
ExecutorCheckPerms_hook_type when using WITH NO DATA.  This could
silently break the users of this hook.
--
Michael

Вложения

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

Предыдущее
От: Michael Paquier
Дата:
Сообщение: Sloppiness around failure handling of parsePGArray in pg_dump
Следующее
От: Pavel Stehule
Дата:
Сообщение: Re: proposal: possibility to read dumped table's name from file