diff options
| author | Peter Eisentraut | 2024-05-17 09:23:08 +0000 |
|---|---|---|
| committer | Peter Eisentraut | 2024-05-17 09:44:26 +0000 |
| commit | 17974ec259463869bb6bb4885d46847422fbc9ec (patch) | |
| tree | 11cd393058415b42093277f2e15de7bf1e186579 /src/test | |
| parent | be5942aee7a012ce7f30bc7a6617903127f29e89 (diff) | |
Revise GUC names quoting in messages again
After further review, we want to move in the direction of always
quoting GUC names in error messages, rather than the previous (PG16)
wildly mixed practice or the intermittent (mid-PG17) idea of doing
this depending on how possibly confusing the GUC name is.
This commit applies appropriate quotes to (almost?) all mentions of
GUC names in error messages. It partially supersedes a243569bf65 and
8d9978a7176, which had moved things a bit in the opposite direction
but which then were abandoned in a partial state.
Author: Peter Smith <smithpb2250@gmail.com>
Discussion: https://www.postgresql.org/message-id/flat/CAHut%2BPv-kSN8SkxSdoHano_wPubqcg5789ejhCDZAcLFceBR-w%40mail.gmail.com
Diffstat (limited to 'src/test')
| -rw-r--r-- | src/test/modules/commit_ts/expected/commit_timestamp_1.out | 12 | ||||
| -rw-r--r-- | src/test/modules/libpq_pipeline/libpq_pipeline.c | 4 | ||||
| -rw-r--r-- | src/test/modules/ssl_passphrase_callback/ssl_passphrase_func.c | 2 | ||||
| -rw-r--r-- | src/test/modules/ssl_passphrase_callback/t/001_testfunc.pl | 2 | ||||
| -rw-r--r-- | src/test/modules/test_shm_mq/setup.c | 2 | ||||
| -rw-r--r-- | src/test/modules/test_slru/test_slru.c | 2 | ||||
| -rw-r--r-- | src/test/recovery/t/024_archive_recovery.pl | 4 | ||||
| -rw-r--r-- | src/test/recovery/t/035_standby_logical_decoding.pl | 2 | ||||
| -rw-r--r-- | src/test/regress/expected/collate.icu.utf8.out | 4 | ||||
| -rw-r--r-- | src/test/regress/expected/create_am.out | 2 | ||||
| -rw-r--r-- | src/test/regress/expected/json.out | 4 | ||||
| -rw-r--r-- | src/test/regress/expected/jsonb.out | 4 | ||||
| -rw-r--r-- | src/test/regress/expected/prepared_xacts_1.out | 18 | ||||
| -rw-r--r-- | src/test/regress/expected/strings.out | 12 | ||||
| -rw-r--r-- | src/test/ssl/t/001_ssltests.pl | 4 | ||||
| -rw-r--r-- | src/test/subscription/t/001_rep_changes.pl | 4 |
16 files changed, 41 insertions, 41 deletions
diff --git a/src/test/modules/commit_ts/expected/commit_timestamp_1.out b/src/test/modules/commit_ts/expected/commit_timestamp_1.out index 4c62bc95f9f..f37e701f37a 100644 --- a/src/test/modules/commit_ts/expected/commit_timestamp_1.out +++ b/src/test/modules/commit_ts/expected/commit_timestamp_1.out @@ -18,7 +18,7 @@ SELECT id, FROM committs_test ORDER BY id; ERROR: could not get commit timestamp data -HINT: Make sure the configuration parameter track_commit_timestamp is set. +HINT: Make sure the configuration parameter "track_commit_timestamp" is set. DROP TABLE committs_test; SELECT pg_xact_commit_timestamp('0'::xid); ERROR: cannot retrieve commit timestamp for transaction 0 @@ -40,7 +40,7 @@ SELECT x.xid::text::bigint > 0 as xid_valid, roident != 0 AS valid_roident FROM pg_last_committed_xact() x; ERROR: could not get commit timestamp data -HINT: Make sure the configuration parameter track_commit_timestamp is set. +HINT: Make sure the configuration parameter "track_commit_timestamp" is set. -- Test non-normal transaction ids. SELECT * FROM pg_xact_commit_timestamp_origin(NULL); -- ok, NULL timestamp | roident @@ -69,13 +69,13 @@ SELECT x.timestamp > '-infinity'::timestamptz AS ts_low, roident != 0 AS valid_roident FROM pg_last_committed_xact() x; ERROR: could not get commit timestamp data -HINT: Make sure the configuration parameter track_commit_timestamp is set. +HINT: Make sure the configuration parameter "track_commit_timestamp" is set. SELECT x.timestamp > '-infinity'::timestamptz AS ts_low, x.timestamp <= now() AS ts_high, roident != 0 AS valid_roident FROM pg_xact_commit_timestamp_origin(:'txid_no_origin') x; ERROR: could not get commit timestamp data -HINT: Make sure the configuration parameter track_commit_timestamp is set. +HINT: Make sure the configuration parameter "track_commit_timestamp" is set. -- Test transaction with replication origin SELECT pg_replication_origin_create('regress_commit_ts: get_origin') != 0 AS valid_roident; @@ -97,14 +97,14 @@ SELECT x.timestamp > '-infinity'::timestamptz AS ts_low, FROM pg_last_committed_xact() x, pg_replication_origin r WHERE r.roident = x.roident; ERROR: could not get commit timestamp data -HINT: Make sure the configuration parameter track_commit_timestamp is set. +HINT: Make sure the configuration parameter "track_commit_timestamp" is set. SELECT x.timestamp > '-infinity'::timestamptz AS ts_low, x.timestamp <= now() AS ts_high, r.roname FROM pg_xact_commit_timestamp_origin(:'txid_with_origin') x, pg_replication_origin r WHERE r.roident = x.roident; ERROR: could not get commit timestamp data -HINT: Make sure the configuration parameter track_commit_timestamp is set. +HINT: Make sure the configuration parameter "track_commit_timestamp" is set. SELECT pg_replication_origin_session_reset(); pg_replication_origin_session_reset ------------------------------------- diff --git a/src/test/modules/libpq_pipeline/libpq_pipeline.c b/src/test/modules/libpq_pipeline/libpq_pipeline.c index 928ef6b1700..ac4d26302cc 100644 --- a/src/test/modules/libpq_pipeline/libpq_pipeline.c +++ b/src/test/modules/libpq_pipeline/libpq_pipeline.c @@ -2227,10 +2227,10 @@ main(int argc, char **argv) res = PQexec(conn, "SET lc_messages TO \"C\""); if (PQresultStatus(res) != PGRES_COMMAND_OK) - pg_fatal("failed to set lc_messages: %s", PQerrorMessage(conn)); + pg_fatal("failed to set \"lc_messages\": %s", PQerrorMessage(conn)); res = PQexec(conn, "SET debug_parallel_query = off"); if (PQresultStatus(res) != PGRES_COMMAND_OK) - pg_fatal("failed to set debug_parallel_query: %s", PQerrorMessage(conn)); + pg_fatal("failed to set \"debug_parallel_query\": %s", PQerrorMessage(conn)); /* Set the trace file, if requested */ if (tracefile != NULL) diff --git a/src/test/modules/ssl_passphrase_callback/ssl_passphrase_func.c b/src/test/modules/ssl_passphrase_callback/ssl_passphrase_func.c index 948706af852..d5992149821 100644 --- a/src/test/modules/ssl_passphrase_callback/ssl_passphrase_func.c +++ b/src/test/modules/ssl_passphrase_callback/ssl_passphrase_func.c @@ -58,7 +58,7 @@ set_rot13(SSL_CTX *context, bool isServerStart) /* warn if the user has set ssl_passphrase_command */ if (ssl_passphrase_command[0]) ereport(WARNING, - (errmsg("ssl_passphrase_command setting ignored by ssl_passphrase_func module"))); + (errmsg("\"ssl_passphrase_command\" setting ignored by ssl_passphrase_func module"))); SSL_CTX_set_default_passwd_cb(context, rot13_passphrase); } diff --git a/src/test/modules/ssl_passphrase_callback/t/001_testfunc.pl b/src/test/modules/ssl_passphrase_callback/t/001_testfunc.pl index a2bfb645760..7a63539f39c 100644 --- a/src/test/modules/ssl_passphrase_callback/t/001_testfunc.pl +++ b/src/test/modules/ssl_passphrase_callback/t/001_testfunc.pl @@ -56,7 +56,7 @@ my $log_contents = slurp_file($log); like( $log_contents, - qr/WARNING.*ssl_passphrase_command setting ignored by ssl_passphrase_func module/, + qr/WARNING.*"ssl_passphrase_command" setting ignored by ssl_passphrase_func module/, "ssl_passphrase_command set warning"); # set the wrong passphrase diff --git a/src/test/modules/test_shm_mq/setup.c b/src/test/modules/test_shm_mq/setup.c index 3de5d01e305..b3dac44d97a 100644 --- a/src/test/modules/test_shm_mq/setup.c +++ b/src/test/modules/test_shm_mq/setup.c @@ -233,7 +233,7 @@ setup_background_workers(int nworkers, dsm_segment *seg) ereport(ERROR, (errcode(ERRCODE_INSUFFICIENT_RESOURCES), errmsg("could not register background process"), - errhint("You may need to increase max_worker_processes."))); + errhint("You may need to increase \"max_worker_processes\"."))); ++wstate->nworkers; } diff --git a/src/test/modules/test_slru/test_slru.c b/src/test/modules/test_slru/test_slru.c index 068a21f125f..d227b067034 100644 --- a/src/test/modules/test_slru/test_slru.c +++ b/src/test/modules/test_slru/test_slru.c @@ -251,7 +251,7 @@ _PG_init(void) if (!process_shared_preload_libraries_in_progress) ereport(ERROR, (errmsg("cannot load \"%s\" after startup", "test_slru"), - errdetail("\"%s\" must be loaded with shared_preload_libraries.", + errdetail("\"%s\" must be loaded with \"shared_preload_libraries\".", "test_slru"))); prev_shmem_request_hook = shmem_request_hook; diff --git a/src/test/recovery/t/024_archive_recovery.pl b/src/test/recovery/t/024_archive_recovery.pl index c7318d92e8c..c6480bbdcd6 100644 --- a/src/test/recovery/t/024_archive_recovery.pl +++ b/src/test/recovery/t/024_archive_recovery.pl @@ -91,8 +91,8 @@ sub test_recovery_wal_level_minimal # Confirm that the archive recovery fails with an expected error my $logfile = slurp_file($recovery_node->logfile()); ok( $logfile =~ - qr/FATAL: .* WAL was generated with wal_level=minimal, cannot continue recovering/, - "$node_text ends with an error because it finds WAL generated with wal_level=minimal" + qr/FATAL: .* WAL was generated with "wal_level=minimal", cannot continue recovering/, + "$node_text ends with an error because it finds WAL generated with \"wal_level=minimal\"" ); } diff --git a/src/test/recovery/t/035_standby_logical_decoding.pl b/src/test/recovery/t/035_standby_logical_decoding.pl index 07ff5231d33..4628f9fb806 100644 --- a/src/test/recovery/t/035_standby_logical_decoding.pl +++ b/src/test/recovery/t/035_standby_logical_decoding.pl @@ -794,7 +794,7 @@ $handle = make_slot_active($node_standby, 'wal_level_', 0, \$stdout, \$stderr); # We are not able to read from the slot as it requires wal_level >= logical on the primary server check_pg_recvlogical_stderr($handle, - "logical decoding on standby requires wal_level >= logical on the primary" + "logical decoding on standby requires \"wal_level\" >= \"logical\" on the primary" ); # Restore primary wal_level diff --git a/src/test/regress/expected/collate.icu.utf8.out b/src/test/regress/expected/collate.icu.utf8.out index 4b8c8f143f3..7d59fb44316 100644 --- a/src/test/regress/expected/collate.icu.utf8.out +++ b/src/test/regress/expected/collate.icu.utf8.out @@ -1042,7 +1042,7 @@ ERROR: parameter "locale" must be specified SET icu_validation_level = ERROR; CREATE COLLATION testx (provider = icu, locale = 'nonsense-nowhere'); -- fails ERROR: ICU locale "nonsense-nowhere" has unknown language "nonsense" -HINT: To disable ICU locale validation, set the parameter icu_validation_level to "disabled". +HINT: To disable ICU locale validation, set the parameter "icu_validation_level" to "disabled". CREATE COLLATION testx (provider = icu, locale = '@colStrength=primary;nonsense=yes'); -- fails ERROR: could not convert locale name "@colStrength=primary;nonsense=yes" to language tag: U_ILLEGAL_ARGUMENT_ERROR RESET icu_validation_level; @@ -1050,7 +1050,7 @@ CREATE COLLATION testx (provider = icu, locale = '@colStrength=primary;nonsense= WARNING: could not convert locale name "@colStrength=primary;nonsense=yes" to language tag: U_ILLEGAL_ARGUMENT_ERROR CREATE COLLATION testx (provider = icu, locale = 'nonsense-nowhere'); DROP COLLATION testx; WARNING: ICU locale "nonsense-nowhere" has unknown language "nonsense" -HINT: To disable ICU locale validation, set the parameter icu_validation_level to "disabled". +HINT: To disable ICU locale validation, set the parameter "icu_validation_level" to "disabled". CREATE COLLATION test4 FROM nonsense; ERROR: collation "nonsense" for encoding "UTF8" does not exist CREATE COLLATION test5 FROM test0; diff --git a/src/test/regress/expected/create_am.out b/src/test/regress/expected/create_am.out index 9762c332ce0..35d4cf1d467 100644 --- a/src/test/regress/expected/create_am.out +++ b/src/test/regress/expected/create_am.out @@ -113,7 +113,7 @@ COMMIT; -- prevent empty values SET default_table_access_method = ''; ERROR: invalid value for parameter "default_table_access_method": "" -DETAIL: default_table_access_method cannot be empty. +DETAIL: "default_table_access_method" cannot be empty. -- prevent nonexistent values SET default_table_access_method = 'I do not exist AM'; ERROR: invalid value for parameter "default_table_access_method": "I do not exist AM" diff --git a/src/test/regress/expected/json.out b/src/test/regress/expected/json.out index 7cb28f106d7..aa29bc597bd 100644 --- a/src/test/regress/expected/json.out +++ b/src/test/regress/expected/json.out @@ -219,10 +219,10 @@ CONTEXT: JSON data, line 1: {"abc":1,3... SET max_stack_depth = '100kB'; SELECT repeat('[', 10000)::json; ERROR: stack depth limit exceeded -HINT: Increase the configuration parameter max_stack_depth (currently 100kB), after ensuring the platform's stack depth limit is adequate. +HINT: Increase the configuration parameter "max_stack_depth" (currently 100kB), after ensuring the platform's stack depth limit is adequate. SELECT repeat('{"a":', 10000)::json; ERROR: stack depth limit exceeded -HINT: Increase the configuration parameter max_stack_depth (currently 100kB), after ensuring the platform's stack depth limit is adequate. +HINT: Increase the configuration parameter "max_stack_depth" (currently 100kB), after ensuring the platform's stack depth limit is adequate. RESET max_stack_depth; -- Miscellaneous stuff. SELECT 'true'::json; -- OK diff --git a/src/test/regress/expected/jsonb.out b/src/test/regress/expected/jsonb.out index 66bee5162b4..e66d7601899 100644 --- a/src/test/regress/expected/jsonb.out +++ b/src/test/regress/expected/jsonb.out @@ -213,10 +213,10 @@ CONTEXT: JSON data, line 1: {"abc":1,3... SET max_stack_depth = '100kB'; SELECT repeat('[', 10000)::jsonb; ERROR: stack depth limit exceeded -HINT: Increase the configuration parameter max_stack_depth (currently 100kB), after ensuring the platform's stack depth limit is adequate. +HINT: Increase the configuration parameter "max_stack_depth" (currently 100kB), after ensuring the platform's stack depth limit is adequate. SELECT repeat('{"a":', 10000)::jsonb; ERROR: stack depth limit exceeded -HINT: Increase the configuration parameter max_stack_depth (currently 100kB), after ensuring the platform's stack depth limit is adequate. +HINT: Increase the configuration parameter "max_stack_depth" (currently 100kB), after ensuring the platform's stack depth limit is adequate. RESET max_stack_depth; -- Miscellaneous stuff. SELECT 'true'::jsonb; -- OK diff --git a/src/test/regress/expected/prepared_xacts_1.out b/src/test/regress/expected/prepared_xacts_1.out index 7168f86bf94..6ad3d11898a 100644 --- a/src/test/regress/expected/prepared_xacts_1.out +++ b/src/test/regress/expected/prepared_xacts_1.out @@ -19,7 +19,7 @@ SELECT * FROM pxtest1; PREPARE TRANSACTION 'regress_foo1'; ERROR: prepared transactions are disabled -HINT: Set max_prepared_transactions to a nonzero value. +HINT: Set "max_prepared_transactions" to a nonzero value. SELECT * FROM pxtest1; foobar -------- @@ -58,7 +58,7 @@ SELECT * FROM pxtest1; PREPARE TRANSACTION 'regress_foo2'; ERROR: prepared transactions are disabled -HINT: Set max_prepared_transactions to a nonzero value. +HINT: Set "max_prepared_transactions" to a nonzero value. SELECT * FROM pxtest1; foobar -------- @@ -84,7 +84,7 @@ SELECT * FROM pxtest1; PREPARE TRANSACTION 'regress_foo3'; ERROR: prepared transactions are disabled -HINT: Set max_prepared_transactions to a nonzero value. +HINT: Set "max_prepared_transactions" to a nonzero value. SELECT gid FROM pg_prepared_xacts WHERE gid ~ '^regress_' ORDER BY gid; gid ----- @@ -95,7 +95,7 @@ INSERT INTO pxtest1 VALUES ('fff'); -- This should fail, because the gid foo3 is already in use PREPARE TRANSACTION 'regress_foo3'; ERROR: prepared transactions are disabled -HINT: Set max_prepared_transactions to a nonzero value. +HINT: Set "max_prepared_transactions" to a nonzero value. SELECT * FROM pxtest1; foobar -------- @@ -121,7 +121,7 @@ SELECT * FROM pxtest1; PREPARE TRANSACTION 'regress_foo4'; ERROR: prepared transactions are disabled -HINT: Set max_prepared_transactions to a nonzero value. +HINT: Set "max_prepared_transactions" to a nonzero value. SELECT gid FROM pg_prepared_xacts WHERE gid ~ '^regress_' ORDER BY gid; gid ----- @@ -138,7 +138,7 @@ SELECT * FROM pxtest1; INSERT INTO pxtest1 VALUES ('fff'); PREPARE TRANSACTION 'regress_foo5'; ERROR: prepared transactions are disabled -HINT: Set max_prepared_transactions to a nonzero value. +HINT: Set "max_prepared_transactions" to a nonzero value. SELECT gid FROM pg_prepared_xacts WHERE gid ~ '^regress_' ORDER BY gid; gid ----- @@ -169,7 +169,7 @@ SELECT pg_advisory_xact_lock_shared(1); PREPARE TRANSACTION 'regress_foo6'; -- fails ERROR: prepared transactions are disabled -HINT: Set max_prepared_transactions to a nonzero value. +HINT: Set "max_prepared_transactions" to a nonzero value. -- Test subtransactions BEGIN TRANSACTION ISOLATION LEVEL SERIALIZABLE; CREATE TABLE pxtest2 (a int); @@ -181,7 +181,7 @@ BEGIN TRANSACTION ISOLATION LEVEL SERIALIZABLE; INSERT INTO pxtest2 VALUES (3); PREPARE TRANSACTION 'regress_sub1'; ERROR: prepared transactions are disabled -HINT: Set max_prepared_transactions to a nonzero value. +HINT: Set "max_prepared_transactions" to a nonzero value. CREATE TABLE pxtest3(fff int); -- Test shared invalidation BEGIN TRANSACTION ISOLATION LEVEL SERIALIZABLE; @@ -199,7 +199,7 @@ BEGIN TRANSACTION ISOLATION LEVEL SERIALIZABLE; PREPARE TRANSACTION 'regress_sub2'; ERROR: prepared transactions are disabled -HINT: Set max_prepared_transactions to a nonzero value. +HINT: Set "max_prepared_transactions" to a nonzero value. -- No such cursor FETCH 1 FROM foo; ERROR: cursor "foo" does not exist diff --git a/src/test/regress/expected/strings.out b/src/test/regress/expected/strings.out index b7500d9c0e7..52b69a107fb 100644 --- a/src/test/regress/expected/strings.out +++ b/src/test/regress/expected/strings.out @@ -147,17 +147,17 @@ SELECT U&'d\0061t\+000061' AS U&"d\0061t\+000061"; ERROR: unsafe use of string constant with Unicode escapes LINE 1: SELECT U&'d\0061t\+000061' AS U&"d\0061t\+000061"; ^ -DETAIL: String constants with Unicode escapes cannot be used when standard_conforming_strings is off. +DETAIL: String constants with Unicode escapes cannot be used when "standard_conforming_strings" is off. SELECT U&'d!0061t\+000061' UESCAPE '!' AS U&"d*0061t\+000061" UESCAPE '*'; ERROR: unsafe use of string constant with Unicode escapes LINE 1: SELECT U&'d!0061t\+000061' UESCAPE '!' AS U&"d*0061t\+000061... ^ -DETAIL: String constants with Unicode escapes cannot be used when standard_conforming_strings is off. +DETAIL: String constants with Unicode escapes cannot be used when "standard_conforming_strings" is off. SELECT U&' \' UESCAPE '!' AS "tricky"; ERROR: unsafe use of string constant with Unicode escapes LINE 1: SELECT U&' \' UESCAPE '!' AS "tricky"; ^ -DETAIL: String constants with Unicode escapes cannot be used when standard_conforming_strings is off. +DETAIL: String constants with Unicode escapes cannot be used when "standard_conforming_strings" is off. SELECT 'tricky' AS U&"\" UESCAPE '!'; \ -------- @@ -168,17 +168,17 @@ SELECT U&'wrong: \061'; ERROR: unsafe use of string constant with Unicode escapes LINE 1: SELECT U&'wrong: \061'; ^ -DETAIL: String constants with Unicode escapes cannot be used when standard_conforming_strings is off. +DETAIL: String constants with Unicode escapes cannot be used when "standard_conforming_strings" is off. SELECT U&'wrong: \+0061'; ERROR: unsafe use of string constant with Unicode escapes LINE 1: SELECT U&'wrong: \+0061'; ^ -DETAIL: String constants with Unicode escapes cannot be used when standard_conforming_strings is off. +DETAIL: String constants with Unicode escapes cannot be used when "standard_conforming_strings" is off. SELECT U&'wrong: +0061' UESCAPE '+'; ERROR: unsafe use of string constant with Unicode escapes LINE 1: SELECT U&'wrong: +0061' UESCAPE '+'; ^ -DETAIL: String constants with Unicode escapes cannot be used when standard_conforming_strings is off. +DETAIL: String constants with Unicode escapes cannot be used when "standard_conforming_strings" is off. RESET standard_conforming_strings; -- bytea SET bytea_output TO hex; diff --git a/src/test/ssl/t/001_ssltests.pl b/src/test/ssl/t/001_ssltests.pl index 68c1b6b41f6..b8773270235 100644 --- a/src/test/ssl/t/001_ssltests.pl +++ b/src/test/ssl/t/001_ssltests.pl @@ -554,11 +554,11 @@ $node->connect_fails( $node->connect_fails( "$common_connstr sslrootcert=ssl/root+server_ca.crt sslmode=require ssl_min_protocol_version=incorrect_tls", "connection failure with an incorrect SSL protocol minimum bound", - expected_stderr => qr/invalid ssl_min_protocol_version value/); + expected_stderr => qr/invalid "ssl_min_protocol_version" value/); $node->connect_fails( "$common_connstr sslrootcert=ssl/root+server_ca.crt sslmode=require ssl_max_protocol_version=incorrect_tls", "connection failure with an incorrect SSL protocol maximum bound", - expected_stderr => qr/invalid ssl_max_protocol_version value/); + expected_stderr => qr/invalid "ssl_max_protocol_version" value/); ### Server-side tests. ### diff --git a/src/test/subscription/t/001_rep_changes.pl b/src/test/subscription/t/001_rep_changes.pl index 9ccebd890a1..471e9819628 100644 --- a/src/test/subscription/t/001_rep_changes.pl +++ b/src/test/subscription/t/001_rep_changes.pl @@ -573,7 +573,7 @@ CREATE PUBLICATION tap_pub2 FOR TABLE skip_wal; ROLLBACK; }); ok( $reterr =~ - m/WARNING: wal_level is insufficient to publish logical changes/, - 'CREATE PUBLICATION while wal_level=minimal'); + m/WARNING: "wal_level" is insufficient to publish logical changes/, + 'CREATE PUBLICATION while "wal_level=minimal"'); done_testing(); |
