pgsql: Fix ALTER SYSTEM to cope with duplicate entries inpostgresql.au
От | Tom Lane |
---|---|
Тема | pgsql: Fix ALTER SYSTEM to cope with duplicate entries inpostgresql.au |
Дата | |
Msg-id | E1hxyf0-00023L-6u@gemulon.postgresql.org обсуждение исходный текст |
Список | pgsql-committers |
Fix ALTER SYSTEM to cope with duplicate entries in postgresql.auto.conf. ALTER SYSTEM itself normally won't make duplicate entries (although up till this patch, it was possible to confuse it by writing case variants of a GUC's name). However, if some external tool has appended entries to the file, that could result in duplicate entries for a single GUC name. In such a situation, ALTER SYSTEM did exactly the wrong thing, because it replaced or removed only the first matching entry, leaving the later one(s) still there and hence still determining the active value. This patch fixes that by making ALTER SYSTEM sweep through the file and remove all matching entries, then (if not ALTER SYSTEM RESET) append the new setting to the end. This means entries will be in order of last setting rather than first setting, but that shouldn't hurt anything. Also, make the comparisons case-insensitive so that the right things happen if you do, say, ALTER SYSTEM SET "TimeZone" = 'whatever'. This has been broken since ALTER SYSTEM was invented, so back-patch to all supported branches. Ian Barwick, with minor mods by me Discussion: https://postgr.es/m/aed6cc9f-98f3-2693-ac81-52bb0052307e@2ndquadrant.com Branch ------ REL9_4_STABLE Details ------- https://git.postgresql.org/pg/commitdiff/a4b0d955bd23bf82d461417d084d7d7abb397cb8 Modified Files -------------- src/backend/utils/misc/guc.c | 47 +++++++++++++++++++++----------------------- 1 file changed, 22 insertions(+), 25 deletions(-)
В списке pgsql-committers по дате отправления: