On Wed, Jun 2, 2021 at 2:02 AM Bharath Rupireddy <bharath.rupireddyforpostg...@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.
