github.com/cockroachdb/cockroach@v20.2.0-alpha.1+incompatible/pkg/sql/unsupported_vars.go (about)

     1  // Copyright 2018 The Cockroach Authors.
     2  //
     3  // Use of this software is governed by the Business Source License
     4  // included in the file licenses/BSL.txt.
     5  //
     6  // As of the Change Date specified in that file, in accordance with
     7  // the Business Source License, use of this software will be governed
     8  // by the Apache License, Version 2.0, included in the file
     9  // licenses/APL.txt.
    10  
    11  package sql
    12  
    13  // UnsupportedVars contains the set of PostgreSQL session variables
    14  // and client parameters that are not supported in CockroachDB.
    15  // These are used to produce error messages and telemetry.
    16  var UnsupportedVars = func(ss ...string) map[string]struct{} {
    17  	m := map[string]struct{}{}
    18  	for _, s := range ss {
    19  		m[s] = struct{}{}
    20  	}
    21  	return m
    22  }(
    23  	// The following list can be regenerated with:
    24  	//
    25  	//    grep ', PGC_\(SUSET\|USERSET\)' src/backend/utils/misc/guc.c | \
    26  	//        sed -e 's/^[^"]*"/"/g;s/"[^"]*$/",/g' | \
    27  	//        tr A-Z a-z \
    28  	//        sort -u
    29  	//
    30  
    31  	"optimize_bounded_sort",
    32  	// "datestyle",
    33  	// "intervalstyle",
    34  	// "timezone",
    35  	// "application_name",
    36  	"array_nulls",
    37  	"backend_flush_after",
    38  	"backslash_quote",
    39  	// "bytea_output",
    40  	"check_function_bodies",
    41  	// "client_encoding",
    42  	// "client_min_messages",
    43  	"commit_delay",
    44  	"commit_siblings",
    45  	"constraint_exclusion",
    46  	"cpu_index_tuple_cost",
    47  	"cpu_operator_cost",
    48  	"cpu_tuple_cost",
    49  	"cursor_tuple_fraction",
    50  	"deadlock_timeout",
    51  	"debug_deadlocks",
    52  	"debug_pretty_print",
    53  	"debug_print_parse",
    54  	"debug_print_plan",
    55  	"debug_print_rewritten",
    56  	"default_statistics_target",
    57  	"default_text_search_config",
    58  	"default_transaction_deferrable",
    59  	// "default_transaction_isolation",
    60  	// "default_transaction_read_only",
    61  	"default_with_oids",
    62  	"dynamic_library_path",
    63  	"effective_cache_size",
    64  	"enable_bitmapscan",
    65  	"enable_gathermerge",
    66  	"enable_hashagg",
    67  	"enable_hashjoin",
    68  	"enable_indexonlyscan",
    69  	"enable_indexscan",
    70  	"enable_material",
    71  	"enable_mergejoin",
    72  	"enable_nestloop",
    73  	"enable_seqscan",
    74  	"enable_sort",
    75  	"enable_tidscan",
    76  	"escape_string_warning",
    77  	"exit_on_error",
    78  	// "extra_float_digits",
    79  	"force_parallel_mode",
    80  	"from_collapse_limit",
    81  	"geqo",
    82  	"geqo_effort",
    83  	"geqo_generations",
    84  	"geqo_pool_size",
    85  	"geqo_seed",
    86  	"geqo_selection_bias",
    87  	"geqo_threshold",
    88  	"gin_fuzzy_search_limit",
    89  	"gin_pending_list_limit",
    90  	// "idle_in_transaction_session_timeout",
    91  	"ignore_checksum_failure",
    92  	"join_collapse_limit",
    93  	"lc_messages",
    94  	"lc_monetary",
    95  	"lc_numeric",
    96  	"lc_time",
    97  	"lo_compat_privileges",
    98  	"local_preload_libraries",
    99  	// "lock_timeout",
   100  	"log_btree_build_stats",
   101  	"log_duration",
   102  	"log_error_verbosity",
   103  	"log_executor_stats",
   104  	"log_lock_waits",
   105  	"log_min_duration_statement",
   106  	"log_min_error_statement",
   107  	"log_min_messages",
   108  	"log_parser_stats",
   109  	"log_planner_stats",
   110  	"log_replication_commands",
   111  	"log_statement",
   112  	"log_statement_stats",
   113  	"log_temp_files",
   114  	"maintenance_work_mem",
   115  	"max_parallel_workers",
   116  	"max_parallel_workers_per_gather",
   117  	"max_stack_depth",
   118  	"min_parallel_index_scan_size",
   119  	"min_parallel_table_scan_size",
   120  	"operator_precedence_warning",
   121  	"parallel_setup_cost",
   122  	"parallel_tuple_cost",
   123  	"password_encryption",
   124  	"quote_all_identifiers",
   125  	"random_page_cost",
   126  	"replacement_sort_tuples",
   127  	"role",
   128  	// "row_security",
   129  	// "search_path",
   130  	"seed",
   131  	"seq_page_cost",
   132  	// "session_authorization",
   133  	"session_preload_libraries",
   134  	"session_replication_role",
   135  	// "ssl_renegotiation_limit",
   136  	// "standard_conforming_strings",
   137  	// "statement_timeout",
   138  	//	"synchronize_seqscans",
   139  	"synchronous_commit",
   140  	"tcp_keepalives_count",
   141  	"tcp_keepalives_idle",
   142  	"tcp_keepalives_interval",
   143  	"temp_buffers",
   144  	"temp_file_limit",
   145  	"temp_tablespaces",
   146  	"timezone_abbreviations",
   147  	"trace_lock_oidmin",
   148  	"trace_lock_table",
   149  	"trace_locks",
   150  	"trace_lwlocks",
   151  	"trace_notify",
   152  	"trace_sort",
   153  	"trace_syncscan",
   154  	"trace_userlocks",
   155  	"track_activities",
   156  	"track_counts",
   157  	"track_functions",
   158  	"track_io_timing",
   159  	"transaction_deferrable",
   160  	// "transaction_isolation",
   161  	// "transaction_read_only",
   162  	"transform_null_equals",
   163  	"update_process_title",
   164  	"vacuum_cost_delay",
   165  	"vacuum_cost_limit",
   166  	"vacuum_cost_page_dirty",
   167  	"vacuum_cost_page_hit",
   168  	"vacuum_cost_page_miss",
   169  	"vacuum_freeze_min_age",
   170  	"vacuum_freeze_table_age",
   171  	"vacuum_multixact_freeze_min_age",
   172  	"vacuum_multixact_freeze_table_age",
   173  	"wal_compression",
   174  	"wal_consistency_checking",
   175  	"wal_debug",
   176  	"work_mem",
   177  	"xmlbinary",
   178  	"xmloption",
   179  	"zero_damaged_pages",
   180  )