99 "Enables automatic summarization on this BRIN index",
107 "autovacuum_enabled",
108 "Enables autovacuum in this relation",
116 "user_catalog_table",
117 "Declare a table as an additional catalog table, e.g. for the purpose of logical replication",
126 "Enables \"fast update\" feature for this GIN index",
135 "View acts as a row security barrier",
144 "Privileges on underlying relations are checked as the invoking user, not the view owner",
153 "Enables vacuum to truncate empty pages at the end of this table",
162 "Enables \"deduplicate items\" feature for this btree index",
178 "Packs table pages only to this percentage",
188 "Packs btree index pages only to this percentage",
198 "Packs hash index pages only to this percentage",
208 "Packs gist index pages only to this percentage",
218 "Packs spgist index pages only to this percentage",
227 "autovacuum_vacuum_threshold",
228 "Minimum number of tuple updates or deletes prior to vacuum",
236 "autovacuum_vacuum_insert_threshold",
237 "Minimum number of tuple inserts prior to vacuum, or -1 to disable insert vacuums",
245 "autovacuum_analyze_threshold",
246 "Minimum number of tuple inserts, updates or deletes prior to analyze",
254 "autovacuum_vacuum_cost_limit",
255 "Vacuum cost amount available before napping, for autovacuum",
263 "autovacuum_freeze_min_age",
264 "Minimum age at which VACUUM should freeze a table row, for autovacuum",
272 "autovacuum_multixact_freeze_min_age",
273 "Minimum multixact age at which VACUUM should freeze a row multixact's, for autovacuum",
281 "autovacuum_freeze_max_age",
282 "Age at which to autovacuum a table to prevent transaction ID wraparound",
286 -1, 100000, 2000000000
290 "autovacuum_multixact_freeze_max_age",
291 "Multixact age at which to autovacuum a table to prevent multixact wraparound",
295 -1, 10000, 2000000000
299 "autovacuum_freeze_table_age",
300 "Age at which VACUUM should perform a full table sweep to freeze row versions",
307 "autovacuum_multixact_freeze_table_age",
308 "Age of multixact at which VACUUM should perform a full table sweep to freeze row versions",
315 "log_autovacuum_min_duration",
316 "Sets the minimum execution time above which autovacuum actions will be logged",
324 "toast_tuple_target",
325 "Sets the target tuple length at which external columns will be toasted",
334 "Number of pages that each page range covers in a BRIN index",
341 "gin_pending_list_limit",
342 "Maximum size of the pending list for this GIN index, in kilobytes.",
350 "effective_io_concurrency",
351 "Number of simultaneous requests that can be handled efficiently by the disk subsystem.",
363 "maintenance_io_concurrency",
364 "Number of simultaneous requests that can be handled efficiently by the disk subsystem for maintenance work.",
377 "Number of parallel processes that can be used per executor node for this relation.",
392 "autovacuum_vacuum_cost_delay",
393 "Vacuum cost delay in milliseconds, for autovacuum",
401 "autovacuum_vacuum_scale_factor",
402 "Number of tuple updates or deletes prior to vacuum as a fraction of reltuples",
410 "autovacuum_vacuum_insert_scale_factor",
411 "Number of tuple inserts prior to vacuum as a fraction of reltuples",
419 "autovacuum_analyze_scale_factor",
420 "Number of tuple inserts, updates or deletes prior to analyze as a fraction of reltuples",
429 "Sets the planner's estimate of the cost of a sequentially fetched disk page.",
438 "Sets the planner's estimate of the cost of a nonsequentially fetched disk page.",
447 "Sets the planner's estimate of the number of distinct values appearing in a column (excluding child relations).",
455 "n_distinct_inherited",
456 "Sets the planner's estimate of the number of distinct values appearing in a column (including child relations).",
464 "vacuum_cleanup_index_scale_factor",
465 "Deprecated B-Tree parameter.",
487 {(
const char *) NULL}
496 {(
const char *) NULL}
505 {(
const char *) NULL}
512 "vacuum_index_cleanup",
513 "Controls index vacuuming and index cleanup",
519 gettext_noop(
"Valid values are \"on\", \"off\", and \"auto\".")
524 "Enables buffering build for this GiST index",
530 gettext_noop(
"Valid values are \"on\", \"off\", and \"auto\".")
535 "View has WITH CHECK OPTION defined (local or cascaded).",
541 gettext_noop(
"Valid values are \"local\" and \"cascaded\".")
562 int text_len,
bool validate);
569#define GET_STRING_RELOPTION_LEN(option) \
570 ((option).isset ? strlen((option).values.string_val) : \
571 ((relopt_string *) (option).gen)->default_len)
688 (
errcode(ERRCODE_PROGRAM_LIMIT_EXCEEDED),
689 errmsg(
"user-defined relation parameter types limit exceeded")));
702 static int max_custom_options = 0;
710 if (max_custom_options == 0)
712 max_custom_options = 8;
717 max_custom_options *= 2;
761 Assert(offset < relopts->relopt_struct_size);
815 newoption->
desc = NULL;
816 newoption->
kinds = kinds;
833 bool default_val,
LOCKMODE lockmode)
838 name, desc, lockmode);
850 bool default_val,
LOCKMODE lockmode)
853 default_val, lockmode);
866 const char *desc,
bool default_val,
int offset)
882 int default_val,
int min_val,
int max_val,
888 name, desc, lockmode);
890 newoption->
min = min_val;
905 default_val, min_val,
919 const char *desc,
int default_val,
int min_val,
923 name, desc, default_val,
935 double default_val,
double min_val,
double max_val,
941 name, desc, lockmode);
943 newoption->
min = min_val;
955 double default_val,
double min_val,
double max_val,
959 default_val, min_val,
973 const char *desc,
double default_val,
974 double min_val,
double max_val,
int offset)
978 default_val, min_val,
991 const char *detailmsg,
LOCKMODE lockmode)
996 name, desc, lockmode);
1020 const char *detailmsg,
LOCKMODE lockmode)
1023 members, default_val,
1024 detailmsg, lockmode);
1038 int default_val,
const char *detailmsg,
int offset)
1042 members, default_val,
1054 const char *default_val,
1063 (validator) (default_val);
1066 name, desc, lockmode);
1119 const char *desc,
const char *default_val,
1157 const char *
const validnsps[],
bool acceptOidsOff,
bool isReset)
1180 for (
i = 0;
i < noldoptions;
i++)
1182 char *text_str =
VARDATA(oldoptions[
i]);
1186 foreach(cell, defList)
1192 if (namspace == NULL)
1202 kw_len = strlen(def->
defname);
1203 if (text_len > kw_len && text_str[kw_len] ==
'=' &&
1204 strncmp(text_str, def->
defname, kw_len) == 0)
1222 foreach(cell, defList)
1228 if (def->
arg != NULL)
1230 (
errcode(ERRCODE_SYNTAX_ERROR),
1231 errmsg(
"RESET must not include values for parameters")));
1250 for (
i = 0; validnsps[
i];
i++)
1262 (
errcode(ERRCODE_INVALID_PARAMETER_VALUE),
1263 errmsg(
"unrecognized parameter namespace \"%s\"",
1268 if (namspace == NULL)
1283 if (def->
arg != NULL)
1295 strcmp(def->
defname,
"oids") == 0)
1299 (
errcode(ERRCODE_FEATURE_NOT_SUPPORTED),
1300 errmsg(
"tables declared WITH OIDS are not supported")));
1335 Datum *optiondatums;
1388 Anum_pg_class_reloptions,
1397 switch (classForm->relkind)
1399 case RELKIND_RELATION:
1400 case RELKIND_TOASTVALUE:
1401 case RELKIND_MATVIEW:
1404 case RELKIND_PARTITIONED_TABLE:
1411 case RELKIND_PARTITIONED_INDEX:
1414 case RELKIND_FOREIGN_TABLE:
1431 Datum *optiondatums;
1439 char *text_str =
VARDATA(optiondatums[
i]);
1444 for (
j = 0;
j < numoptions;
j++)
1448 if (text_len > kw_len && text_str[kw_len] ==
'=' &&
1449 strncmp(text_str, reloptions[
j].gen->name, kw_len) == 0)
1457 if (
j >= numoptions && validate)
1467 (
errcode(ERRCODE_INVALID_PARAMETER_VALUE),
1468 errmsg(
"unrecognized parameter \"%s\"", s)));
1473 pfree(optiondatums);
1525 reloptions[
j].
isset =
false;
1535 *numrelopts = numoptions;
1575 bool nofree =
false;
1577 if (
option->isset && validate)
1579 (
errcode(ERRCODE_INVALID_PARAMETER_VALUE),
1580 errmsg(
"parameter \"%s\" specified more than once",
1583 value_len = text_len -
option->gen->namelen - 1;
1585 memcpy(
value, text_str +
option->gen->namelen + 1, value_len);
1586 value[value_len] =
'\0';
1588 switch (
option->gen->type)
1593 if (validate && !parsed)
1595 (
errcode(ERRCODE_INVALID_PARAMETER_VALUE),
1596 errmsg(
"invalid value for boolean option \"%s\": %s",
1605 if (validate && !parsed)
1607 (
errcode(ERRCODE_INVALID_PARAMETER_VALUE),
1608 errmsg(
"invalid value for integer option \"%s\": %s",
1610 if (validate && (
option->values.int_val < optint->
min ||
1613 (
errcode(ERRCODE_INVALID_PARAMETER_VALUE),
1614 errmsg(
"value %s out of bounds for option \"%s\"",
1616 errdetail(
"Valid values are between \"%d\" and \"%d\".",
1617 optint->
min, optint->
max)));
1625 if (validate && !parsed)
1627 (
errcode(ERRCODE_INVALID_PARAMETER_VALUE),
1628 errmsg(
"invalid value for floating point option \"%s\": %s",
1630 if (validate && (
option->values.real_val < optreal->
min ||
1631 option->values.real_val > optreal->
max))
1633 (
errcode(ERRCODE_INVALID_PARAMETER_VALUE),
1634 errmsg(
"value %s out of bounds for option \"%s\"",
1636 errdetail(
"Valid values are between \"%f\" and \"%f\".",
1637 optreal->
min, optreal->
max)));
1650 option->values.enum_val = elt->symbol_val;
1655 if (validate && !parsed)
1657 (
errcode(ERRCODE_INVALID_PARAMETER_VALUE),
1658 errmsg(
"invalid value for enum option \"%s\": %s",
1707 for (
i = 0;
i < numoptions;
i++)
1748 int offset = basesize;
1750 for (
i = 0;
i < numoptions;
i++)
1755 for (
j = 0;
j < numelems;
j++)
1760 char *itempos = ((
char *) rdopts) + elems[
j].
offset;
1766 *(
bool *) itempos =
options[
i].isset ?
1771 *(
int *) itempos =
options[
i].isset ?
1776 *(
double *) itempos =
options[
i].isset ?
1781 *(
int *) itempos =
options[
i].isset ?
1788 string_val =
options[
i].values.string_val;
1797 optstring->
fill_cb(string_val,
1798 (
char *) rdopts + offset);
1802 *(
int *) itempos = offset;
1806 *(
int *) itempos = 0;
1808 else if (string_val == NULL)
1809 *(
int *) itempos = 0;
1812 strcpy((
char *) rdopts + offset, string_val);
1813 *(
int *) itempos = offset;
1814 offset += strlen(string_val) + 1;
1818 elog(
ERROR,
"unsupported reloption type %d",
1826 if (validate && !found)
1827 elog(
ERROR,
"reloption \"%s\" not found in parse table",
1910 Size relopt_struct_size,
1912 int num_relopt_elems)
1920 Assert(numoptions <= num_relopt_elems);
1923 if (numoptions == 0)
1932 validate, relopt_elems, num_relopt_elems);
1986 if (validate && reloptions)
1988 errcode(ERRCODE_WRONG_OBJECT_TYPE),
1989 errmsg(
"cannot specify storage parameters for a partitioned table"),
1990 errhint(
"Specify storage parameters for its leaf partitions instead."));
2025 case RELKIND_TOASTVALUE:
2035 return (
bytea *) rdopts;
2036 case RELKIND_RELATION:
2037 case RELKIND_MATVIEW:
2056 Assert(amoptions != NULL);
2062 return amoptions(reloptions, validate);
2119 foreach(cell, defList)
2130 if (lockmode <
relOpts[
i]->lockmode)
bytea *(* amoptions_function)(Datum reloptions, bool validate)
#define DatumGetArrayTypeP(X)
ArrayBuildState * accumArrayResult(ArrayBuildState *astate, Datum dvalue, bool disnull, Oid element_type, MemoryContext rcontext)
void deconstruct_array_builtin(ArrayType *array, Oid elmtype, Datum **elemsp, bool **nullsp, int *nelemsp)
Datum makeArrayResult(ArrayBuildState *astate, MemoryContext rcontext)
bool parse_bool(const char *value, bool *result)
static Datum values[MAXATTR]
int maintenance_io_concurrency
int effective_io_concurrency
#define MAX_IO_CONCURRENCY
#define TextDatumGetCString(d)
#define Assert(condition)
#define PointerIsValid(pointer)
char * defGetString(DefElem *def)
bool defGetBoolean(DefElem *def)
int errdetail_internal(const char *fmt,...)
int errdetail(const char *fmt,...)
int errhint(const char *fmt,...)
int errcode(int sqlerrcode)
int errmsg(const char *fmt,...)
#define ereport(elevel,...)
@ GIST_OPTION_BUFFERING_OFF
@ GIST_OPTION_BUFFERING_AUTO
@ GIST_OPTION_BUFFERING_ON
#define GIST_MIN_FILLFACTOR
#define GIST_DEFAULT_FILLFACTOR
bool parse_int(const char *value, int *result, int flags, const char **hintmsg)
bool parse_real(const char *value, double *result, int flags, const char **hintmsg)
#define HASH_DEFAULT_FILLFACTOR
#define HASH_MIN_FILLFACTOR
#define TOAST_TUPLE_TARGET
#define TOAST_TUPLE_TARGET_MAIN
static Datum fastgetattr(HeapTuple tup, int attnum, TupleDesc tupleDesc, bool *isnull)
if(TABLE==NULL||TABLE_index==NULL)
List * lappend(List *list, void *datum)
bool DoLockModesConflict(LOCKMODE mode1, LOCKMODE mode2)
#define AccessExclusiveLock
#define ShareUpdateExclusiveLock
DefElem * makeDefElem(char *name, Node *arg, int location)
char * MemoryContextStrdup(MemoryContext context, const char *string)
void * MemoryContextAlloc(MemoryContext context, Size size)
char * pstrdup(const char *in)
void * repalloc(void *pointer, Size size)
void pfree(void *pointer)
void * palloc0(Size size)
MemoryContext TopMemoryContext
MemoryContext CurrentMemoryContext
#define BTREE_MIN_FILLFACTOR
#define BTREE_DEFAULT_FILLFACTOR
static AmcheckOptions opts
FormData_pg_class * Form_pg_class
static int list_length(const List *l)
int pg_strcasecmp(const char *s1, const char *s2)
static Datum PointerGetDatum(const void *X)
static Pointer DatumGetPointer(Datum X)
MemoryContextSwitchTo(old_ctx)
#define HEAP_MIN_FILLFACTOR
@ VIEW_OPTION_CHECK_OPTION_NOT_SET
@ VIEW_OPTION_CHECK_OPTION_LOCAL
@ VIEW_OPTION_CHECK_OPTION_CASCADED
#define HEAP_DEFAULT_FILLFACTOR
@ STDRD_OPTION_VACUUM_INDEX_CLEANUP_AUTO
@ STDRD_OPTION_VACUUM_INDEX_CLEANUP_OFF
@ STDRD_OPTION_VACUUM_INDEX_CLEANUP_ON
static relopt_string * init_string_reloption(bits32 kinds, const char *name, const char *desc, const char *default_val, validate_string_relopt validator, fill_string_relopt filler, LOCKMODE lockmode)
static int num_custom_options
void add_local_string_reloption(local_relopts *relopts, const char *name, const char *desc, const char *default_val, validate_string_relopt validator, fill_string_relopt filler, int offset)
static relopt_real realRelOpts[]
void add_int_reloption(bits32 kinds, const char *name, const char *desc, int default_val, int min_val, int max_val, LOCKMODE lockmode)
static relopt_enum_elt_def gistBufferingOptValues[]
bytea * default_reloptions(Datum reloptions, bool validate, relopt_kind kind)
static relopt_value * parseLocalRelOptions(local_relopts *relopts, Datum options, bool validate)
bytea * tablespace_reloptions(Datum reloptions, bool validate)
static relopt_enum_elt_def StdRdOptIndexCleanupValues[]
#define GET_STRING_RELOPTION_LEN(option)
void add_string_reloption(bits32 kinds, const char *name, const char *desc, const char *default_val, validate_string_relopt validator, LOCKMODE lockmode)
Datum transformRelOptions(Datum oldOptions, List *defList, const char *namspace, const char *const validnsps[], bool acceptOidsOff, bool isReset)
List * untransformRelOptions(Datum options)
static relopt_int intRelOpts[]
static relopt_enum enumRelOpts[]
static void parse_one_reloption(relopt_value *option, char *text_str, int text_len, bool validate)
static relopt_string stringRelOpts[]
bytea * view_reloptions(Datum reloptions, bool validate)
static relopt_int * init_int_reloption(bits32 kinds, const char *name, const char *desc, int default_val, int min_val, int max_val, LOCKMODE lockmode)
bytea * index_reloptions(amoptions_function amoptions, Datum reloptions, bool validate)
void add_enum_reloption(bits32 kinds, const char *name, const char *desc, relopt_enum_elt_def *members, int default_val, const char *detailmsg, LOCKMODE lockmode)
void * build_reloptions(Datum reloptions, bool validate, relopt_kind kind, Size relopt_struct_size, const relopt_parse_elt *relopt_elems, int num_relopt_elems)
bytea * partitioned_table_reloptions(Datum reloptions, bool validate)
void add_real_reloption(bits32 kinds, const char *name, const char *desc, double default_val, double min_val, double max_val, LOCKMODE lockmode)
void add_local_bool_reloption(local_relopts *relopts, const char *name, const char *desc, bool default_val, int offset)
void init_local_reloptions(local_relopts *relopts, Size relopt_struct_size)
static relopt_enum_elt_def viewCheckOptValues[]
void add_local_real_reloption(local_relopts *relopts, const char *name, const char *desc, double default_val, double min_val, double max_val, int offset)
static void add_reloption(relopt_gen *newoption)
static void add_local_reloption(local_relopts *relopts, relopt_gen *newoption, int offset)
void add_bool_reloption(bits32 kinds, const char *name, const char *desc, bool default_val, LOCKMODE lockmode)
void add_local_enum_reloption(local_relopts *relopts, const char *name, const char *desc, relopt_enum_elt_def *members, int default_val, const char *detailmsg, int offset)
bytea * extractRelOptions(HeapTuple tuple, TupleDesc tupdesc, amoptions_function amoptions)
static void parseRelOptionsInternal(Datum options, bool validate, relopt_value *reloptions, int numoptions)
static void fillRelOptions(void *rdopts, Size basesize, relopt_value *options, int numoptions, bool validate, const relopt_parse_elt *elems, int numelems)
static relopt_enum * init_enum_reloption(bits32 kinds, const char *name, const char *desc, relopt_enum_elt_def *members, int default_val, const char *detailmsg, LOCKMODE lockmode)
static void initialize_reloptions(void)
relopt_kind add_reloption_kind(void)
void * build_local_reloptions(local_relopts *relopts, Datum options, bool validate)
void register_reloptions_validator(local_relopts *relopts, relopts_validator validator)
static bool need_initialization
static relopt_value * parseRelOptions(Datum options, bool validate, relopt_kind kind, int *numrelopts)
static relopt_bool * init_bool_reloption(bits32 kinds, const char *name, const char *desc, bool default_val, LOCKMODE lockmode)
static relopt_gen ** relOpts
static relopt_gen ** custom_options
LOCKMODE AlterTableGetRelOptionsLockLevel(List *defList)
static relopt_real * init_real_reloption(bits32 kinds, const char *name, const char *desc, double default_val, double min_val, double max_val, LOCKMODE lockmode)
bytea * attribute_reloptions(Datum reloptions, bool validate)
static relopt_gen * allocate_reloption(bits32 kinds, int type, const char *name, const char *desc, LOCKMODE lockmode)
static relopt_bool boolRelOpts[]
void add_local_int_reloption(local_relopts *relopts, const char *name, const char *desc, int default_val, int min_val, int max_val, int offset)
static void * allocateReloptStruct(Size base, relopt_value *options, int numoptions)
static bits32 last_assigned_kind
bytea * heap_reloptions(char relkind, Datum reloptions, bool validate)
struct relopt_real relopt_real
Size(* fill_string_relopt)(const char *value, void *ptr)
struct relopt_bool relopt_bool
@ RELOPT_KIND_LAST_DEFAULT
struct relopt_string relopt_string
void(* validate_string_relopt)(const char *value)
struct relopt_enum relopt_enum
void(* relopts_validator)(void *parsed_options, relopt_value *vals, int nvals)
struct relopt_int relopt_int
static pg_noinline void Size size
#define SPGIST_DEFAULT_FILLFACTOR
#define SPGIST_MIN_FILLFACTOR
float8 analyze_scale_factor
relopt_enum_elt_def * members
validate_string_relopt validate_cb
fill_string_relopt fill_cb
union relopt_value::@48 values
String * makeString(char *str)
#define SET_VARSIZE(PTR, len)