Re: Alias collision in `refresh materialized view concurrently`

Поиск
Список
Период
Сортировка
От Thomas Munro
Тема Re: Alias collision in `refresh materialized view concurrently`
Дата
Msg-id CA+hUKGK=TgR3hefhjzsVGZzXQ+A2TtgekFtQ3aGEso82LJab5w@mail.gmail.com
обсуждение исходный текст
Ответ на Re: Alias collision in `refresh materialized view concurrently`  (Bharath Rupireddy <bharath.rupireddyforpostgres@gmail.com>)
Ответы Re: Alias collision in `refresh materialized view concurrently`  (Michael Paquier <michael@paquier.xyz>)
Список pgsql-hackers
On Wed, Jun 2, 2021 at 2:02 AM Bharath Rupireddy
<bharath.rupireddyforpostgres@gmail.com> wrote:
> PSA v3 patch. I added a commit message and made some cosmetic adjustments.

Reminds me of this fun topic in Lisp:

https://en.wikipedia.org/wiki/Hygienic_macro#Strategies_used_in_languages_that_lack_hygienic_macros

I wondered if we could find a way to make identifiers that regular
queries are prohibited from using, at least by documentation.  You
could take advantage of the various constraints on unquoted
identifiers in the standard (for example, something involving $), but
it does seem a shame to remove the ability for users to put absolutely
anything except NUL in quoted identifiers.  I do wonder if at least
using something like _$mv would be slightly more principled than
pg_mv_1234, since nothing says pg_XXX is reserved (except in some very
specific places like schema names), and the number on the end seems a
bit cargo-cultish.



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

Предыдущее
От: Tom Lane
Дата:
Сообщение: Re: CALL versus procedures with output-only arguments
Следующее
От: Michael Paquier
Дата:
Сообщение: Re: Alias collision in `refresh materialized view concurrently`