pgsql: Disallow "=" in names of reloptions and foreign-data options. - Mailing list pgsql-committers

From Tom Lane
Subject pgsql: Disallow "=" in names of reloptions and foreign-data options.
Date
Msg-id E1uMAkQ-00040i-2d@gemulon.postgresql.org
Whole thread Raw
List pgsql-committers
Disallow "=" in names of reloptions and foreign-data options.

We store values for these options as array elements with the syntax
"name=value", hence a name containing "=" confuses matters when
it's time to read the array back in.  Since validation of the
options is often done (long) after this conversion to array format,
that leads to confusing and off-point error messages.  We can
improve matters by rejecting names containing "=" up-front.

(Probably a better design would have involved pairs of array
elements, but it's too late now --- and anyway, there's no
evident use-case for option names like this.  We already
reject such names in some other contexts such as GUCs.)

Reported-by: Chapman Flack <jcflack@acm.org>
Author: Tom Lane <tgl@sss.pgh.pa.us>
Reviewed-by: Chapman Flack <jcflack@acm.org>
Discussion: https://postgr.es/m/6830EB30.8090904@acm.org
Backpatch-through: 13

Branch
------
REL_14_STABLE

Details
-------
https://git.postgresql.org/pg/commitdiff/eb423464753f5a853ec47209aab05f74fafa9328

Modified Files
--------------
contrib/file_fdw/input/file_fdw.source  |  2 ++
contrib/file_fdw/output/file_fdw.source |  5 +++++
src/backend/access/common/reloptions.c  | 17 +++++++++++++----
src/backend/commands/foreigncmds.c      | 15 +++++++++++++--
4 files changed, 33 insertions(+), 6 deletions(-)


pgsql-committers by date:

Previous
From: Melanie Plageman
Date:
Subject: pgsql: Correct heap vacuum boundary state setup ordering
Next
From: Fujii Masao
Date:
Subject: pgsql: Rename log_lock_failure GUC to log_lock_failures for consistency