Re: pg_get_functiondef forgets about most GUC_LIST_INPUT GUCs
Tom Lane <tgl@sss.pgh.pa.us>
From: Tom Lane <tgl@sss.pgh.pa.us>
To: Michael Paquier <michael.paquier@gmail.com>
Cc: Postgres hackers <pgsql-hackers@postgresql.org>
Date: 2018-01-11T15:42:38Z
Lists: pgsql-hackers
Michael Paquier <michael.paquier@gmail.com> writes: > While reviewing another patch related to the use of pg_strcasecmp in the > backend, I have noticed this bit in ruleutils.c: > /* > * Some GUC variable names are 'LIST' type and hence must not > * be quoted. > */ > if (pg_strcasecmp(configitem, "DateStyle") == 0 > || pg_strcasecmp(configitem, "search_path") == 0) > appendStringInfoString(&buf, pos); > else > simple_quote_literal(&buf, pos); > However this fails to consider all GUCs marked as GUC_LIST_INPUT, like > the recent wal_consistency_checking. Mmm, yeah, probably time to find a more maintainable solution to that. > guc.c already holds a find_option() > which can be used to retrieve the flags of a parameter. What about using > that and filtering by GUC_LIST_INPUT? This requires exposing the > function, and I am not sure what people think about that. Don't like exposing find_option directly, but I think it would make sense to provide an API along the lines of int GetConfigOptionFlags(const char *name, bool missing_ok). regards, tom lane
Commits
-
Prevent extensions from creating custom GUCs that are GUC_LIST_QUOTE.
- 846b5a525746 11.0 landed
-
Fix mishandling of quoted-list GUC values in pg_dump and ruleutils.c.
- be677bb5aa79 9.3.23 landed
- a35d72923165 9.5.13 landed
- 8132f0f3856d 9.6.9 landed
- 742869946f4f 11.0 landed
- 67e02cde7373 9.4.18 landed
- 66e92878aaec 10.4 landed