Re: Alias collision in `refresh materialized view concurrently` - Mailing list pgsql-hackers

From Thomas Munro
Subject Re: Alias collision in `refresh materialized view concurrently`
Date
Msg-id CA+hUKGK=TgR3hefhjzsVGZzXQ+A2TtgekFtQ3aGEso82LJab5w@mail.gmail.com
Whole thread Raw
In response to Re: Alias collision in `refresh materialized view concurrently`  (Bharath Rupireddy <bharath.rupireddyforpostgres@gmail.com>)
Responses Re: Alias collision in `refresh materialized view concurrently`
List 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 by date:

Previous
From: Tom Lane
Date:
Subject: Re: CALL versus procedures with output-only arguments
Next
From: Michael Paquier
Date:
Subject: Re: Alias collision in `refresh materialized view concurrently`