61 #include "utils/fmgroids.h"
82 const List *exclusionOpNames,
84 const char *accessMethodName,
90 int *ddl_save_nestlevel);
92 const List *colnames,
const List *exclusionOpNames,
93 bool primary,
bool isconstraint);
172 const char *accessMethodName,
173 const List *attributeList,
174 const List *exclusionOpNames)
190 int numberOfAttributes;
206 isconstraint =
false;
209 Assert(numberOfAttributes > 0);
216 (
errcode(ERRCODE_UNDEFINED_OBJECT),
217 errmsg(
"access method \"%s\" does not exist",
220 accessMethodId = accessMethodForm->oid;
235 indexInfo =
makeIndexInfo(numberOfAttributes, numberOfAttributes,
236 accessMethodId,
NIL,
NIL,
false,
false,
237 false,
false, amsummarizing);
243 typeIds, collationIds, opclassIds,
244 coloptions, attributeList,
245 exclusionOpNames, relationId,
246 accessMethodName, accessMethodId,
247 amcanorder, isconstraint,
InvalidOid, 0, NULL);
253 elog(
ERROR,
"cache lookup failed for index %u", oldId);
262 indexForm->indisvalid))
269 old_natts = indexForm->indnkeyatts;
270 Assert(old_natts == numberOfAttributes);
278 ret = (memcmp(old_indclass->
values, opclassIds, old_natts *
sizeof(
Oid)) == 0 &&
279 memcmp(old_indcollation->
values, collationIds, old_natts *
sizeof(
Oid)) == 0);
288 for (
i = 0;
i < old_natts;
i++)
307 pfree(opclassOptions);
319 old_natts *
sizeof(
Oid)) == 0;
324 for (
i = 0;
i < old_natts && ret;
i++)
330 if ((IsPolymorphicType(left) || IsPolymorphicType(right)) &&
355 if (!opts1 && !opts2)
358 for (
i = 0;
i < natts;
i++)
363 if (opt1 == (
Datum) 0)
365 if (opt2 == (
Datum) 0)
370 else if (opt2 == (
Datum) 0)
431 for (
i = 0;
i < n_old_snapshots;
i++)
440 int n_newer_snapshots;
449 for (
j =
i;
j < n_old_snapshots;
j++)
453 for (k = 0; k < n_newer_snapshots; k++)
459 if (k >= n_newer_snapshots)
462 pfree(newer_snapshots);
529 Oid parentConstraintId,
533 bool check_not_in_use,
538 char *indexRelationName;
539 char *accessMethodName;
548 List *allIndexParams;
554 bool amissummarizing;
563 int numberOfAttributes;
564 int numberOfKeyAttributes;
571 Oid root_save_userid;
572 int root_save_sec_context;
573 int root_save_nestlevel;
582 if (
stmt->reset_default_tblspc)
632 stmt->indexIncludingParams);
635 if (numberOfKeyAttributes <= 0)
637 (
errcode(ERRCODE_INVALID_OBJECT_DEFINITION),
638 errmsg(
"must specify at least one column")));
641 (
errcode(ERRCODE_TOO_MANY_COLUMNS),
642 errmsg(
"cannot use more than %d columns in an index",
675 switch (rel->
rd_rel->relkind)
677 case RELKIND_RELATION:
678 case RELKIND_MATVIEW:
679 case RELKIND_PARTITIONED_TABLE:
684 (
errcode(ERRCODE_WRONG_OBJECT_TYPE),
685 errmsg(
"cannot create index on relation \"%s\"",
699 partitioned = rel->
rd_rel->relkind == RELKIND_PARTITIONED_TABLE;
708 if (
stmt->concurrent)
710 (
errcode(ERRCODE_FEATURE_NOT_SUPPORTED),
711 errmsg(
"cannot create index on partitioned table \"%s\" concurrently",
720 (
errcode(ERRCODE_FEATURE_NOT_SUPPORTED),
721 errmsg(
"cannot create indexes on temporary tables of other sessions")));
729 if (check_not_in_use)
742 aclresult =
object_aclcheck(NamespaceRelationId, namespaceId, root_save_userid,
753 if (
stmt->tableSpace)
758 (
errcode(ERRCODE_FEATURE_NOT_SUPPORTED),
759 errmsg(
"cannot specify default tablespace for partitioned relations")));
774 aclresult =
object_aclcheck(TableSpaceRelationId, tablespaceId, root_save_userid,
786 if (rel->
rd_rel->relisshared)
787 tablespaceId = GLOBALTABLESPACE_OID;
788 else if (tablespaceId == GLOBALTABLESPACE_OID)
790 (
errcode(ERRCODE_INVALID_PARAMETER_VALUE),
791 errmsg(
"only shared relations can be placed in pg_global tablespace")));
801 indexRelationName =
stmt->idxname;
802 if (indexRelationName == NULL)
806 stmt->excludeOpNames,
813 accessMethodName =
stmt->accessMethod;
821 if (strcmp(accessMethodName,
"rtree") == 0)
824 (
errmsg(
"substituting access method \"gist\" for obsolete method \"rtree\"")));
825 accessMethodName =
"gist";
831 (
errcode(ERRCODE_UNDEFINED_OBJECT),
832 errmsg(
"access method \"%s\" does not exist",
836 accessMethodId = accessMethodForm->oid;
844 (
errcode(ERRCODE_FEATURE_NOT_SUPPORTED),
845 errmsg(
"access method \"%s\" does not support unique indexes",
849 (
errcode(ERRCODE_FEATURE_NOT_SUPPORTED),
850 errmsg(
"access method \"%s\" does not support included columns",
854 (
errcode(ERRCODE_FEATURE_NOT_SUPPORTED),
855 errmsg(
"access method \"%s\" does not support multicolumn indexes",
859 (
errcode(ERRCODE_FEATURE_NOT_SUPPORTED),
860 errmsg(
"access method \"%s\" does not support exclusion constraints",
873 if (
stmt->whereClause)
880 NULL, NULL,
false,
false);
890 numberOfKeyAttributes,
895 stmt->nulls_not_distinct,
905 typeIds, collationIds, opclassIds,
906 coloptions, allIndexParams,
907 stmt->excludeOpNames, tableId,
908 accessMethodName, accessMethodId,
909 amcanorder,
stmt->isconstraint, root_save_userid,
910 root_save_sec_context, &root_save_nestlevel);
928 if (partitioned && (
stmt->unique ||
stmt->excludeOpNames))
931 const char *constraint_type;
935 constraint_type =
"PRIMARY KEY";
936 else if (
stmt->unique)
937 constraint_type =
"UNIQUE";
938 else if (
stmt->excludeOpNames)
939 constraint_type =
"EXCLUDE";
943 constraint_type = NULL;
950 for (
i = 0;
i <
key->partnatts;
i++)
969 key->partopcintype[
i],
970 key->partopcintype[
i],
973 elog(
ERROR,
"missing operator %d(%u,%u) in partition opfamily %u",
974 eq_strategy,
key->partopcintype[
i],
key->partopcintype[
i],
975 key->partopfamily[
i]);
985 if (
stmt->unique && accessMethodId != BTREE_AM_OID)
987 (
errcode(ERRCODE_FEATURE_NOT_SUPPORTED),
988 errmsg(
"cannot match partition key to an index using access method \"%s\"",
995 if (
key->partattrs[
i] == 0)
997 (
errcode(ERRCODE_FEATURE_NOT_SUPPORTED),
998 errmsg(
"unsupported %s constraint with partition key definition",
1000 errdetail(
"%s constraints cannot be used when partition keys include expressions.",
1023 else if (
stmt->excludeOpNames)
1027 if (ptkey_eqop == idx_eqop)
1032 else if (
stmt->excludeOpNames)
1043 (
errcode(ERRCODE_FEATURE_NOT_SUPPORTED),
1044 errmsg(
"cannot match partition key to index on column \"%s\" using non-equal operator \"%s\"",
1057 key->partattrs[
i] - 1);
1059 (
errcode(ERRCODE_FEATURE_NOT_SUPPORTED),
1060 errmsg(
"unique constraint on partitioned table must include all partitioning columns"),
1061 errdetail(
"%s constraint on table \"%s\" lacks column \"%s\" which is part of the partition key.",
1079 (
errcode(ERRCODE_FEATURE_NOT_SUPPORTED),
1080 errmsg(
"index creation on system columns is not supported")));
1098 (
errcode(ERRCODE_FEATURE_NOT_SUPPORTED),
1099 errmsg(
"index creation on system columns is not supported")));
1111 if (
stmt->isconstraint && !quiet)
1113 const char *constraint_type;
1116 constraint_type =
"PRIMARY KEY";
1117 else if (
stmt->unique)
1118 constraint_type =
"UNIQUE";
1119 else if (
stmt->excludeOpNames)
1120 constraint_type =
"EXCLUDE";
1124 constraint_type = NULL;
1128 (
errmsg_internal(
"%s %s will create implicit index \"%s\" for table \"%s\"",
1129 is_alter_table ?
"ALTER TABLE / ADD" :
"CREATE TABLE /",
1146 flags = constr_flags = 0;
1147 if (
stmt->isconstraint)
1149 if (skip_build || concurrent || partitioned)
1151 if (
stmt->if_not_exists)
1164 if (partitioned &&
stmt->relation && !
stmt->relation->inh)
1172 if (
stmt->deferrable)
1174 if (
stmt->initdeferred)
1178 index_create(rel, indexRelationName, indexRelationId, parentIndexId,
1180 stmt->oldNumber, indexInfo, indexColNames,
1181 accessMethodId, tablespaceId,
1182 collationIds, opclassIds,
1183 coloptions, reloptions,
1184 flags, constr_flags,
1186 &createdConstraintId);
1219 if (
stmt->idxcomment != NULL)
1234 if ((!
stmt->relation ||
stmt->relation->inh) && partdesc->
nparts > 0)
1236 int nparts = partdesc->
nparts;
1238 bool invalidate_parent =
false;
1261 if (total_parts < 0)
1274 memcpy(part_oids, partdesc->
oids,
sizeof(
Oid) * nparts);
1284 parentIndex =
index_open(indexRelationId, lockmode);
1297 for (
int i = 0;
i < nparts;
i++)
1299 Oid childRelid = part_oids[
i];
1301 Oid child_save_userid;
1302 int child_save_sec_context;
1303 int child_save_nestlevel;
1312 &child_save_sec_context);
1322 if (childrel->
rd_rel->relkind == RELKIND_FOREIGN_TABLE)
1326 (
errcode(ERRCODE_WRONG_OBJECT_TYPE),
1327 errmsg(
"cannot create unique index on partitioned table \"%s\"",
1329 errdetail(
"Table \"%s\" contains partitions that are foreign tables.",
1334 child_save_sec_context);
1345 foreach(cell, childidxs)
1391 createdConstraintId,
1395 invalidate_parent =
true;
1421 child_save_sec_context);
1430 bool found_whole_row;
1468 if (found_whole_row)
1469 elog(
ERROR,
"cannot convert whole-row table reference");
1476 if (found_whole_row)
1477 elog(
ERROR,
"cannot convert whole-row table reference");
1485 root_save_sec_context);
1490 createdConstraintId,
1492 is_alter_table, check_rights,
1496 child_save_sec_context);
1504 invalidate_parent =
true;
1517 if (invalidate_parent)
1526 elog(
ERROR,
"cache lookup failed for index %u",
1622 const int progress_cols[] = {
1626 const int64 progress_vals[] = {
1729 limitXmin = snapshot->
xmin;
1840 (
errcode(ERRCODE_INVALID_OBJECT_DEFINITION),
1841 errmsg(
"functions in index predicate must be marked IMMUTABLE")));
1859 const List *attList,
1860 const List *exclusionOpNames,
1862 const char *accessMethodName,
1867 int ddl_sec_context,
1868 int *ddl_save_nestlevel)
1875 int save_sec_context;
1878 if (exclusionOpNames)
1884 nextExclOp =
list_head(exclusionOpNames);
1896 foreach(lc, attList)
1905 if (attribute->
name != NULL)
1918 (
errcode(ERRCODE_UNDEFINED_COLUMN),
1919 errmsg(
"column \"%s\" named in key does not exist",
1923 (
errcode(ERRCODE_UNDEFINED_COLUMN),
1924 errmsg(
"column \"%s\" does not exist",
1929 atttype = attform->atttypid;
1930 attcollation = attform->attcollation;
1940 if (attn >= nkeycols)
1942 (
errcode(ERRCODE_FEATURE_NOT_SUPPORTED),
1943 errmsg(
"expressions are not supported in included columns")));
1983 (
errcode(ERRCODE_INVALID_OBJECT_DEFINITION),
1984 errmsg(
"functions in index expression must be marked IMMUTABLE")));
1988 typeOids[attn] = atttype;
1994 if (attn >= nkeycols)
1998 (
errcode(ERRCODE_INVALID_OBJECT_DEFINITION),
1999 errmsg(
"including column does not support a collation")));
2002 (
errcode(ERRCODE_INVALID_OBJECT_DEFINITION),
2003 errmsg(
"including column does not support an operator class")));
2006 (
errcode(ERRCODE_INVALID_OBJECT_DEFINITION),
2007 errmsg(
"including column does not support ASC/DESC options")));
2010 (
errcode(ERRCODE_INVALID_OBJECT_DEFINITION),
2011 errmsg(
"including column does not support NULLS FIRST/LAST options")));
2014 colOptions[attn] = 0;
2051 (
errcode(ERRCODE_INDETERMINATE_COLLATION),
2052 errmsg(
"could not determine which collation to use for index expression"),
2053 errhint(
"Use the COLLATE clause to set the collation explicitly.")));
2059 (
errcode(ERRCODE_DATATYPE_MISMATCH),
2060 errmsg(
"collations are not supported by type %s",
2064 collationOids[attn] = attcollation;
2124 (
errcode(ERRCODE_WRONG_OBJECT_TYPE),
2125 errmsg(
"operator %s is not commutative",
2127 errdetail(
"Only commutative operators can be used in exclusion constraints.")));
2147 elog(
ERROR,
"cache lookup failed for opfamily %u",
2152 (
errcode(ERRCODE_WRONG_OBJECT_TYPE),
2153 errmsg(
"operator %s is not a member of operator family \"%s\"",
2156 errdetail(
"The exclusion operator must be related to the index operator class for the constraint.")));
2162 nextExclOp =
lnext(exclusionOpNames, nextExclOp);
2170 colOptions[attn] = 0;
2175 colOptions[attn] |= INDOPTION_DESC;
2180 colOptions[attn] |= INDOPTION_NULLS_FIRST;
2183 colOptions[attn] |= INDOPTION_NULLS_FIRST;
2190 (
errcode(ERRCODE_FEATURE_NOT_SUPPORTED),
2191 errmsg(
"access method \"%s\" does not support ASC/DESC options",
2192 accessMethodName)));
2195 (
errcode(ERRCODE_FEATURE_NOT_SUPPORTED),
2196 errmsg(
"access method \"%s\" does not support NULLS FIRST/LAST options",
2197 accessMethodName)));
2211 NULL, NULL,
false,
false);
2226 const char *accessMethodName,
Oid accessMethodId)
2241 (
errcode(ERRCODE_UNDEFINED_OBJECT),
2242 errmsg(
"data type %s has no default operator class for access method \"%s\"",
2244 errhint(
"You must specify an operator class for the index or define a default operator class for the data type.")));
2272 (
errcode(ERRCODE_UNDEFINED_OBJECT),
2273 errmsg(
"operator class \"%s\" does not exist for access method \"%s\"",
2274 opcname, accessMethodName)));
2280 (
errcode(ERRCODE_UNDEFINED_OBJECT),
2281 errmsg(
"operator class \"%s\" does not exist for access method \"%s\"",
2289 opClassId = opform->oid;
2290 opInputType = opform->opcintype;
2294 (
errcode(ERRCODE_DATATYPE_MISMATCH),
2295 errmsg(
"operator class \"%s\" does not accept data type %s",
2314 int ncompatible = 0;
2315 int ncompatiblepreferred = 0;
2342 Anum_pg_opclass_opcmethod,
2354 if (!opclass->opcdefault)
2356 if (opclass->opcintype == type_id)
2359 result = opclass->oid;
2361 else if (nexact == 0 &&
2366 ncompatiblepreferred++;
2367 result = opclass->oid;
2369 else if (ncompatiblepreferred == 0)
2372 result = opclass->oid;
2385 errmsg(
"there are multiple default operator classes for data type %s",
2389 ncompatiblepreferred == 1 ||
2390 (ncompatiblepreferred == 0 && ncompatible == 1))
2428 name1chars = strlen(name1);
2431 name2chars = strlen(name2);
2437 overhead += strlen(
label) + 1;
2447 while (name1chars + name2chars > availchars)
2449 if (name1chars > name2chars)
2455 name1chars =
pg_mbcliplen(name1, name1chars, name1chars);
2457 name2chars =
pg_mbcliplen(name2, name2chars, name2chars);
2460 name =
palloc(name1chars + name2chars + overhead + 1);
2461 memcpy(
name, name1, name1chars);
2466 memcpy(
name + ndx, name2, name2chars);
2506 const char *
label,
Oid namespaceid,
2522 if (!isconstraint ||
2529 snprintf(modlabel,
sizeof(modlabel),
"%s%d",
label, ++pass);
2542 const List *colnames,
const List *exclusionOpNames,
2543 bool primary,
bool isconstraint)
2556 else if (exclusionOpNames !=
NIL)
2564 else if (isconstraint)
2603 foreach(lc, colnames)
2605 const char *
name = (
const char *)
lfirst(lc);
2608 buf[buflen++] =
'_';
2615 buflen += strlen(
buf + buflen);
2635 foreach(lc, indexElems)
2638 const char *origname;
2639 const char *curname;
2646 else if (ielem->
name)
2647 origname = ielem->
name;
2659 foreach(lc2, result)
2661 if (strcmp(curname, (
char *)
lfirst(lc2)) == 0)
2672 memcpy(
buf, origname, nlen);
2673 strcpy(
buf + nlen, nbuf);
2695 bool concurrently =
false;
2697 char *tablespacename = NULL;
2700 foreach(lc,
stmt->params)
2704 if (strcmp(opt->
defname,
"verbose") == 0)
2706 else if (strcmp(opt->
defname,
"concurrently") == 0)
2708 else if (strcmp(opt->
defname,
"tablespace") == 0)
2712 (
errcode(ERRCODE_SYNTAX_ERROR),
2713 errmsg(
"unrecognized REINDEX option \"%s\"",
2720 "REINDEX CONCURRENTLY");
2730 if (tablespacename != NULL)
2771 "REINDEX DATABASE");
2775 elog(
ERROR,
"unrecognized object type: %d",
2819 if (relkind == RELKIND_PARTITIONED_INDEX)
2822 persistence != RELPERSISTENCE_TEMP)
2859 if (relId != oldRelId &&
OidIsValid(oldRelId))
2877 if (relkind != RELKIND_INDEX &&
2878 relkind != RELKIND_PARTITIONED_INDEX)
2880 (
errcode(ERRCODE_WRONG_OBJECT_TYPE),
2888 if (relId != oldRelId)
2899 state->locked_table_oid = table_oid;
2937 (
errmsg(
"table \"%s\" has no indexes that can be reindexed concurrently",
2951 (
errmsg(
"table \"%s\" has no indexes to reindex",
2979 bool concurrent_warning =
false;
2980 bool tablespace_warning =
false;
2995 (
errcode(ERRCODE_FEATURE_NOT_SUPPORTED),
2996 errmsg(
"cannot reindex system catalogs concurrently")));
3018 (
errcode(ERRCODE_FEATURE_NOT_SUPPORTED),
3019 errmsg(
"can only reindex the currently open database")));
3032 "ReindexMultipleTables",
3044 Anum_pg_class_relnamespace,
3062 Oid relid = classtuple->oid;
3071 if (classtuple->relkind != RELKIND_RELATION &&
3072 classtuple->relkind != RELKIND_MATVIEW)
3076 if (classtuple->relpersistence == RELPERSISTENCE_TEMP &&
3099 if (classtuple->relisshared &&
3110 if (!concurrent_warning)
3112 (
errcode(ERRCODE_FEATURE_NOT_SUPPORTED),
3113 errmsg(
"cannot reindex system catalogs concurrently, skipping all")));
3114 concurrent_warning =
true;
3124 bool skip_rel =
false;
3130 if (RELKIND_HAS_STORAGE(classtuple->relkind) &&
3143 if (!tablespace_warning)
3145 (
errcode(ERRCODE_INSUFFICIENT_PRIVILEGE),
3146 errmsg(
"cannot move system relations, skipping all")));
3147 tablespace_warning =
true;
3162 if (relid == RelationRelationId)
3191 if (errinfo->
relkind == RELKIND_PARTITIONED_TABLE)
3192 errcontext(
"while reindexing partitioned table \"%s.%s\"",
3194 else if (errinfo->
relkind == RELKIND_PARTITIONED_INDEX)
3195 errcontext(
"while reindexing partitioned index \"%s.%s\"",
3218 Assert(RELKIND_HAS_PARTITIONS(relkind));
3228 errcallback.
arg = (
void *) &errinfo;
3233 relkind == RELKIND_PARTITIONED_TABLE ?
3234 "REINDEX TABLE" :
"REINDEX INDEX");
3256 foreach(lc, inhoids)
3266 if (!RELKIND_HAS_STORAGE(partkind))
3269 Assert(partkind == RELKIND_INDEX ||
3270 partkind == RELKIND_RELATION);
3311 char relpersistence;
3351 Assert(!RELKIND_HAS_PARTITIONS(relkind));
3354 relpersistence != RELPERSISTENCE_TEMP)
3362 else if (relkind == RELKIND_INDEX)
3386 (
errmsg(
"table \"%s.%s\" was reindexed",
3426 typedef struct ReindexIndexInfo
3443 char *relationName = NULL;
3444 char *relationNamespace = NULL;
3446 const int progress_index[] = {
3452 int64 progress_vals[4];
3461 "ReindexConcurrent",
3485 case RELKIND_RELATION:
3486 case RELKIND_MATVIEW:
3487 case RELKIND_TOASTVALUE:
3499 heapRelationIds =
lappend_oid(heapRelationIds, relationOid);
3505 (
errcode(ERRCODE_FEATURE_NOT_SUPPORTED),
3506 errmsg(
"cannot reindex system catalogs concurrently")));
3524 (
errcode(ERRCODE_FEATURE_NOT_SUPPORTED),
3525 errmsg(
"cannot move system relation \"%s\"",
3535 if (!indexRelation->
rd_index->indisvalid)
3537 (
errcode(ERRCODE_FEATURE_NOT_SUPPORTED),
3538 errmsg(
"cannot reindex invalid index \"%s.%s\" concurrently, skipping",
3541 else if (indexRelation->
rd_index->indisexclusion)
3543 (
errcode(ERRCODE_FEATURE_NOT_SUPPORTED),
3544 errmsg(
"cannot reindex exclusion constraint index \"%s.%s\" concurrently, skipping",
3549 ReindexIndexInfo *
idx;
3555 idx->indexId = cellOid;
3569 Oid toastOid = heapRelation->
rd_rel->reltoastrelid;
3577 heapRelationIds =
lappend_oid(heapRelationIds, toastOid);
3587 if (!indexRelation->
rd_index->indisvalid)
3589 (
errcode(ERRCODE_INDEX_CORRUPTED),
3590 errmsg(
"cannot reindex invalid index \"%s.%s\" concurrently, skipping",
3595 ReindexIndexInfo *
idx;
3604 idx->indexId = cellOid;
3625 ReindexIndexInfo *
idx;
3633 (
errcode(ERRCODE_FEATURE_NOT_SUPPORTED),
3634 errmsg(
"cannot reindex system catalogs concurrently")));
3644 (
errcode(ERRCODE_FEATURE_NOT_SUPPORTED),
3645 errmsg(
"cannot reindex invalid index on TOAST table")));
3668 (
errcode(ERRCODE_FEATURE_NOT_SUPPORTED),
3669 errmsg(
"cannot move system relation \"%s\"",
3685 idx->indexId = relationOid;
3693 case RELKIND_PARTITIONED_TABLE:
3694 case RELKIND_PARTITIONED_INDEX:
3698 (
errcode(ERRCODE_WRONG_OBJECT_TYPE),
3699 errmsg(
"cannot reindex this type of relation concurrently")));
3710 if (indexIds ==
NIL)
3719 (
errcode(ERRCODE_FEATURE_NOT_SUPPORTED),
3720 errmsg(
"cannot move non-shared relation to tablespace \"%s\"",
3750 foreach(lc, indexIds)
3752 char *concurrentName;
3754 ReindexIndexInfo *newidx;
3759 int save_sec_context;
3786 if (indexRel->
rd_rel->relpersistence == RELPERSISTENCE_TEMP)
3787 elog(
ERROR,
"cannot reindex a temporary table concurrently");
3792 progress_vals[1] = 0;
3793 progress_vals[2] =
idx->indexId;
3794 progress_vals[3] =
idx->amId;
3806 heapRel->
rd_rel->relkind != RELKIND_TOASTVALUE)
3809 tablespaceid = indexRel->
rd_rel->reltablespace;
3829 newidx->indexId = newIndexId;
3830 newidx->safe =
idx->safe;
3831 newidx->tableId =
idx->tableId;
3832 newidx->amId =
idx->amId;
3834 newIndexIds =
lappend(newIndexIds, newidx);
3844 relationLocks =
lappend(relationLocks, lockrelid);
3847 relationLocks =
lappend(relationLocks, lockrelid);
3867 foreach(lc, heapRelationIds)
3879 relationLocks =
lappend(relationLocks, lockrelid);
3885 lockTags =
lappend(lockTags, heaplocktag);
3894 foreach(lc, relationLocks)
3925 foreach(lc, newIndexIds)
3927 ReindexIndexInfo *newidx =
lfirst(lc);
3953 progress_vals[2] = newidx->indexId;
3954 progress_vals[3] = newidx->amId;
3984 foreach(lc, newIndexIds)
3986 ReindexIndexInfo *newidx =
lfirst(lc);
4017 progress_vals[2] = newidx->indexId;
4018 progress_vals[3] = newidx->amId;
4027 limitXmin = snapshot->
xmin;
4076 forboth(lc, indexIds, lc2, newIndexIds)
4078 ReindexIndexInfo *oldidx =
lfirst(lc);
4079 ReindexIndexInfo *newidx =
lfirst(lc2);
4141 foreach(lc, indexIds)
4143 ReindexIndexInfo *oldidx =
lfirst(lc);
4180 foreach(lc, indexIds)
4185 object.
classId = RelationRelationId;
4186 object.objectId =
idx->indexId;
4187 object.objectSubId = 0;
4206 foreach(lc, relationLocks)
4219 if (relkind == RELKIND_INDEX)
4221 (
errmsg(
"index \"%s.%s\" was reindexed",
4222 relationNamespace, relationName),
4227 foreach(lc, newIndexIds)
4230 Oid indOid =
idx->indexId;
4233 (
errmsg(
"index \"%s.%s\" was reindexed",
4240 (
errmsg(
"table \"%s.%s\" was reindexed",
4241 relationNamespace, relationName),
4271 Assert(partitionIdx->
rd_rel->relkind == RELKIND_INDEX ||
4272 partitionIdx->
rd_rel->relkind == RELKIND_PARTITIONED_INDEX);
4279 Anum_pg_inherits_inhrelid,
4283 Anum_pg_inherits_inhseqno,
4325 if (inhForm->inhparent != parentOid)
4328 elog(
ERROR,
"bogus pg_inherit row: inhrelid %u inhparent %u",
4329 inhForm->inhrelid, inhForm->inhparent);
4398 elog(
ERROR,
"cache lookup failed for relation %u", relationId);
Datum idx(PG_FUNCTION_ARGS)
void aclcheck_error(AclResult aclerr, ObjectType objtype, const char *objectname)
AclResult object_aclcheck(Oid classid, Oid objectid, Oid roleid, AclMode mode)
bool object_ownercheck(Oid classid, Oid objectid, Oid roleid)
IndexAmRoutine * GetIndexAmRoutine(Oid amhandler)
bytea *(* amoptions_function)(Datum reloptions, bool validate)
Datum array_eq(PG_FUNCTION_ARGS)
void free_attrmap(AttrMap *map)
AttrMap * build_attrmap_by_name(TupleDesc indesc, TupleDesc outdesc, bool missing_ok)
#define InvalidAttrNumber
char * get_tablespace_name(Oid spc_oid)
Oid get_tablespace_oid(const char *tablespacename, bool missing_ok)
Oid GetDefaultTablespace(char relpersistence, bool partitioned)
void pgstat_progress_start_command(ProgressCommandType cmdtype, Oid relid)
void pgstat_progress_incr_param(int index, int64 incr)
void pgstat_progress_update_param(int index, int64 val)
void pgstat_progress_update_multi_param(int nparam, const int *index, const int64 *val)
void pgstat_progress_end_command(void)
@ PROGRESS_COMMAND_CREATE_INDEX
bool bms_is_member(int x, const Bitmapset *a)
#define InvalidSubTransactionId
#define OidIsValid(objectId)
bool IsToastNamespace(Oid namespaceId)
bool IsSystemRelation(Relation relation)
bool IsCatalogRelationOid(Oid relid)
bool IsSystemClass(Oid relid, Form_pg_class reltuple)
bool contain_mutable_functions(Node *clause)
char * get_database_name(Oid dbid)
elog(ERROR, "%s: %s", p2, msg)
bool defGetBoolean(DefElem *def)
char * defGetString(DefElem *def)
void performMultipleDeletions(const ObjectAddresses *objects, DropBehavior behavior, int flags)
ObjectAddresses * new_object_addresses(void)
void add_exact_object_address(const ObjectAddress *object, ObjectAddresses *addrs)
@ DEPENDENCY_PARTITION_PRI
@ DEPENDENCY_PARTITION_SEC
#define PERFORM_DELETION_CONCURRENT_LOCK
#define PERFORM_DELETION_INTERNAL
int errmsg_internal(const char *fmt,...)
int errdetail(const char *fmt,...)
ErrorContextCallback * error_context_stack
int errhint(const char *fmt,...)
int errcode(int sqlerrcode)
int errmsg(const char *fmt,...)
#define ereport(elevel,...)
#define palloc_object(type)
#define palloc_array(type, count)
#define palloc0_array(type, count)
#define DirectFunctionCall2(func, arg1, arg2)
void systable_endscan(SysScanDesc sysscan)
HeapTuple systable_getnext(SysScanDesc sysscan)
SysScanDesc systable_beginscan(Relation heapRelation, Oid indexId, bool indexOK, Snapshot snapshot, int nkeys, ScanKey key)
bool allowSystemTableMods
int NewGUCNestLevel(void)
void AtEOXact_GUC(bool isCommit, int nestLevel)
int set_config_option(const char *name, const char *value, GucContext context, GucSource source, GucAction action, bool changeVal, int elevel, bool is_reload)
HeapTuple heap_getnext(TableScanDesc sscan, ScanDirection direction)
HeapTuple heap_copytuple(HeapTuple tuple)
bool heap_attisnull(HeapTuple tup, int attnum, TupleDesc tupleDesc)
void heap_freetuple(HeapTuple htup)
#define HeapTupleIsValid(tuple)
void validate_index(Oid heapId, Oid indexId, Snapshot snapshot)
Oid IndexGetRelation(Oid indexId, bool missing_ok)
void index_concurrently_set_dead(Oid heapId, Oid indexId)
void index_concurrently_swap(Oid newIndexId, Oid oldIndexId, const char *oldName)
void index_set_state_flags(Oid indexId, IndexStateFlagsAction action)
bool CompareIndexInfo(const IndexInfo *info1, const IndexInfo *info2, const Oid *collations1, const Oid *collations2, const Oid *opfamilies1, const Oid *opfamilies2, const AttrMap *attmap)
bool reindex_relation(Oid relid, int flags, const ReindexParams *params)
Oid index_concurrently_create_copy(Relation heapRelation, Oid oldIndexId, Oid tablespaceOid, const char *newName)
void index_check_primary_key(Relation heapRel, const IndexInfo *indexInfo, bool is_alter_table, const IndexStmt *stmt)
void index_concurrently_build(Oid heapRelationId, Oid indexRelationId)
void reindex_index(Oid indexId, bool skip_constraint_checks, char persistence, const ReindexParams *params)
Oid index_create(Relation heapRelation, const char *indexRelationName, Oid indexRelationId, Oid parentIndexRelid, Oid parentConstraintId, RelFileNumber relFileNumber, IndexInfo *indexInfo, const List *indexColNames, Oid accessMethodId, Oid tableSpaceId, const Oid *collationIds, const Oid *opclassIds, const int16 *coloptions, Datum reloptions, bits16 flags, bits16 constr_flags, bool allow_system_table_mods, bool is_internal, Oid *constraintId)
IndexInfo * BuildIndexInfo(Relation index)
#define INDEX_CREATE_IS_PRIMARY
#define INDEX_CREATE_IF_NOT_EXISTS
#define REINDEX_REL_PROCESS_TOAST
#define INDEX_CREATE_PARTITIONED
#define REINDEXOPT_CONCURRENTLY
#define REINDEXOPT_MISSING_OK
#define INDEX_CREATE_INVALID
#define INDEX_CREATE_ADD_CONSTRAINT
#define INDEX_CREATE_SKIP_BUILD
#define INDEX_CONSTR_CREATE_DEFERRABLE
#define REINDEXOPT_REPORT_PROGRESS
#define INDEX_CONSTR_CREATE_INIT_DEFERRED
#define INDEX_CREATE_CONCURRENT
#define REINDEXOPT_VERBOSE
#define REINDEX_REL_CHECK_CONSTRAINTS
void index_close(Relation relation, LOCKMODE lockmode)
Relation index_open(Oid relationId, LOCKMODE lockmode)
static void ReindexMultipleTables(const char *objectName, ReindexObjectType objectKind, const ReindexParams *params)
char * makeObjectName(const char *name1, const char *name2, const char *label)
void ExecReindex(ParseState *pstate, const ReindexStmt *stmt, bool isTopLevel)
static void ReindexMultipleInternal(const List *relids, const ReindexParams *params)
bool CheckIndexCompatible(Oid oldId, const char *accessMethodName, const List *attributeList, const List *exclusionOpNames)
ObjectAddress DefineIndex(Oid tableId, IndexStmt *stmt, Oid indexRelationId, Oid parentIndexId, Oid parentConstraintId, int total_parts, bool is_alter_table, bool check_rights, bool check_not_in_use, bool skip_build, bool quiet)
static void ReindexPartitions(Oid relid, const ReindexParams *params, bool isTopLevel)
static void set_indexsafe_procflags(void)
static void reindex_error_callback(void *arg)
void IndexSetParentIndex(Relation partitionIdx, Oid parentOid)
Oid GetDefaultOpClass(Oid type_id, Oid am_id)
static void ReindexIndex(const RangeVar *indexRelation, const ReindexParams *params, bool isTopLevel)
static char * ChooseIndexNameAddition(const List *colnames)
static bool CompareOpclassOptions(const Datum *opts1, const Datum *opts2, int natts)
static bool ReindexRelationConcurrently(Oid relationOid, const ReindexParams *params)
static Oid ReindexTable(const RangeVar *relation, const ReindexParams *params, bool isTopLevel)
static bool CheckMutability(Expr *expr)
static void update_relispartition(Oid relationId, bool newval)
static void ComputeIndexAttrs(IndexInfo *indexInfo, Oid *typeOids, Oid *collationOids, Oid *opclassOids, int16 *colOptions, const List *attList, const List *exclusionOpNames, Oid relId, const char *accessMethodName, Oid accessMethodId, bool amcanorder, bool isconstraint, Oid ddl_userid, int ddl_sec_context, int *ddl_save_nestlevel)
void WaitForOlderSnapshots(TransactionId limitXmin, bool progress)
Oid ResolveOpClass(const List *opclass, Oid attrType, const char *accessMethodName, Oid accessMethodId)
struct ReindexErrorInfo ReindexErrorInfo
static void CheckPredicate(Expr *predicate)
static void RangeVarCallbackForReindexIndex(const RangeVar *relation, Oid relId, Oid oldRelId, void *arg)
static List * ChooseIndexColumnNames(const List *indexElems)
static char * ChooseIndexName(const char *tabname, Oid namespaceId, const List *colnames, const List *exclusionOpNames, bool primary, bool isconstraint)
char * ChooseRelationName(const char *name1, const char *name2, const char *label, Oid namespaceid, bool isconstraint)
void CatalogTupleUpdate(Relation heapRel, ItemPointer otid, HeapTuple tup)
void CatalogTupleDelete(Relation heapRel, ItemPointer tid)
void CacheInvalidateRelcacheByRelid(Oid relid)
Assert(fmt[strlen(fmt) - 1] !='\n')
List * lappend(List *list, void *datum)
List * lappend_oid(List *list, Oid datum)
void list_free(List *list)
List * lcons_oid(Oid datum, List *list)
List * list_concat_copy(const List *list1, const List *list2)
void UnlockRelationOid(Oid relid, LOCKMODE lockmode)
void WaitForLockersMultiple(List *locktags, LOCKMODE lockmode, bool progress)
void LockRelationIdForSession(LockRelId *relid, LOCKMODE lockmode)
void LockRelationOid(Oid relid, LOCKMODE lockmode)
void WaitForLockers(LOCKTAG heaplocktag, LOCKMODE lockmode, bool progress)
void UnlockRelationIdForSession(LockRelId *relid, LOCKMODE lockmode)
bool VirtualXactLock(VirtualTransactionId vxid, bool wait)
#define VirtualTransactionIdIsValid(vxid)
#define SET_LOCKTAG_RELATION(locktag, dboid, reloid)
#define VirtualTransactionIdEquals(vxid1, vxid2)
#define SetInvalidVirtualTransactionId(vxid)
#define AccessExclusiveLock
#define ShareUpdateExclusiveLock
char get_rel_persistence(Oid relid)
char * get_opname(Oid opno)
bool get_index_isvalid(Oid index_oid)
Oid get_opclass_input_type(Oid opclass)
Oid get_opclass_family(Oid opclass)
char * get_namespace_name(Oid nspid)
bool get_opclass_opfamily_and_input_type(Oid opclass, Oid *opfamily, Oid *opcintype)
char get_rel_relkind(Oid relid)
Oid get_rel_namespace(Oid relid)
RegProcedure get_opcode(Oid opno)
int get_op_opfamily_strategy(Oid opno, Oid opfamily)
char * get_rel_name(Oid relid)
Oid get_opfamily_member(Oid opfamily, Oid lefttype, Oid righttype, int16 strategy)
bool type_is_collatable(Oid typid)
Oid getBaseType(Oid typid)
Oid get_relname_relid(const char *relname, Oid relnamespace)
Oid get_commutator(Oid opno)
void op_input_types(Oid opno, Oid *lefttype, Oid *righttype)
bool LWLockAcquire(LWLock *lock, LWLockMode mode)
void LWLockRelease(LWLock *lock)
List * make_ands_implicit(Expr *clause)
IndexInfo * makeIndexInfo(int numattrs, int numkeyattrs, Oid amoid, List *expressions, List *predicates, bool unique, bool nulls_not_distinct, bool isready, bool concurrent, bool summarizing)
int pg_mbcliplen(const char *mbstr, int len, int limit)
char * pstrdup(const char *in)
void pfree(void *pointer)
void MemoryContextDelete(MemoryContext context)
MemoryContext PortalContext
#define AllocSetContextCreate
#define ALLOCSET_DEFAULT_SIZES
#define ALLOCSET_SMALL_SIZES
#define IsBootstrapProcessingMode()
#define SECURITY_RESTRICTED_OPERATION
#define CHECK_FOR_INTERRUPTS()
void GetUserIdAndSecContext(Oid *userid, int *sec_context)
void SetUserIdAndSecContext(Oid userid, int sec_context)
Oid OpclassnameGetOpcid(Oid amid, const char *opcname)
Oid LookupExplicitNamespace(const char *nspname, bool missing_ok)
bool isTempNamespace(Oid namespaceId)
Oid get_collation_oid(List *collname, bool missing_ok)
void DeconstructQualifiedName(const List *names, char **nspname_p, char **objname_p)
Oid get_namespace_oid(const char *nspname, bool missing_ok)
char * NameListToString(const List *names)
Oid RangeVarGetRelidExtended(const RangeVar *relation, LOCKMODE lockmode, uint32 flags, RangeVarGetRelidCallback callback, void *callback_arg)
Oid exprType(const Node *expr)
Oid exprCollation(const Node *expr)
#define IsA(nodeptr, _type_)
#define ObjectAddressSet(addr, class_id, object_id)
static MemoryContext MemoryContextSwitchTo(MemoryContext context)
TYPCATEGORY TypeCategory(Oid type)
bool IsBinaryCoercible(Oid srctype, Oid targettype)
bool IsPreferredType(TYPCATEGORY category, Oid type)
int parser_errposition(ParseState *pstate, int location)
Oid compatible_oper_opid(List *op, Oid arg1, Oid arg2, bool noError)
@ PARTITION_STRATEGY_HASH
@ REINDEX_OBJECT_DATABASE
PartitionKey RelationGetPartitionKey(Relation rel)
PartitionDesc RelationGetPartitionDesc(Relation rel, bool omit_detached)
FormData_pg_am * Form_pg_am
FormData_pg_attribute * Form_pg_attribute
static void fix_dependencies(ArchiveHandle *AH)
int errdetail_relkind_not_supported(char relkind)
FormData_pg_class * Form_pg_class
Oid get_relation_idx_constraint_oid(Oid relationId, Oid indexId)
void ConstraintSetParentConstraint(Oid childConstrId, Oid parentConstrId, Oid childTableId)
bool ConstraintNameExists(const char *conname, Oid namespaceid)
void recordDependencyOn(const ObjectAddress *depender, const ObjectAddress *referenced, DependencyType behavior)
long deleteDependencyRecordsForClass(Oid classId, Oid objectId, Oid refclassId, char deptype)
FormData_pg_index * Form_pg_index
List * find_all_inheritors(Oid parentrelId, LOCKMODE lockmode, List **numparents)
void StoreSingleInheritance(Oid relationId, Oid parentOid, int32 seqNumber)
bool has_superclass(Oid relationId)
FormData_pg_inherits * Form_pg_inherits
static int list_length(const List *l)
#define forboth(cell1, list1, cell2, list2)
#define list_make1_oid(x1)
static ListCell * list_head(const List *l)
static ListCell * lnext(const List *l, const ListCell *c)
FormData_pg_opclass * Form_pg_opclass
FormData_pg_opfamily * Form_pg_opfamily
const char * pg_rusage_show(const PGRUsage *ru0)
void pg_rusage_init(PGRUsage *ru0)
Expr * expression_planner(Expr *expr)
size_t strlcpy(char *dst, const char *src, size_t siz)
static bool DatumGetBool(Datum X)
static Datum PointerGetDatum(const void *X)
static Datum ObjectIdGetDatum(Oid X)
static Pointer DatumGetPointer(Datum X)
static Datum Int32GetDatum(int32 X)
#define PROC_IS_AUTOVACUUM
VirtualTransactionId * GetCurrentVirtualXIDs(TransactionId limitXmin, bool excludeXmin0, bool allDbs, int excludeVacuum, int *nvxids)
#define PROGRESS_CREATEIDX_PHASE_WAIT_4
#define PROGRESS_CREATEIDX_PHASE_BUILD
#define PROGRESS_CREATEIDX_PARTITIONS_DONE
#define PROGRESS_CREATEIDX_PHASE_WAIT_1
#define PROGRESS_CREATEIDX_COMMAND_CREATE_CONCURRENTLY
#define PROGRESS_CREATEIDX_ACCESS_METHOD_OID
#define PROGRESS_WAITFOR_DONE
#define PROGRESS_CREATEIDX_PHASE_WAIT_3
#define PROGRESS_WAITFOR_TOTAL
#define PROGRESS_CREATEIDX_COMMAND_REINDEX_CONCURRENTLY
#define PROGRESS_CREATEIDX_COMMAND_CREATE
#define PROGRESS_WAITFOR_CURRENT_PID
#define PROGRESS_CREATEIDX_PHASE_WAIT_2
#define PROGRESS_CREATEIDX_PHASE
#define PROGRESS_CREATEIDX_PHASE_VALIDATE_IDXSCAN
#define PROGRESS_CREATEIDX_PHASE_WAIT_5
#define PROGRESS_CREATEIDX_INDEX_OID
#define PROGRESS_CREATEIDX_PARTITIONS_TOTAL
#define PROGRESS_CREATEIDX_COMMAND
char * format_operator(Oid operator_oid)
#define RelationGetRelid(relation)
#define RelationGetDescr(relation)
#define RelationGetRelationName(relation)
#define RELATION_IS_OTHER_TEMP(relation)
#define RelationGetNamespace(relation)
List * RelationGetIndexList(Relation relation)
Datum * RelationGetIndexRawAttOptions(Relation indexrel)
void RelationGetExclusionInfo(Relation indexRelation, Oid **operators, Oid **procs, uint16 **strategies)
bytea * index_reloptions(amoptions_function amoptions, Datum reloptions, bool validate)
Datum transformRelOptions(Datum oldOptions, List *defList, const char *namspace, char *validnsps[], bool acceptOidsOff, bool isReset)
#define InvalidRelFileNumber
#define RelFileNumberIsValid(relnumber)
Node * map_variable_attnos(Node *node, int target_varno, int sublevels_up, const AttrMap *attno_map, Oid to_rowtype, bool *found_whole_row)
void ScanKeyInit(ScanKey entry, AttrNumber attributeNumber, StrategyNumber strategy, RegProcedure procedure, Datum argument)
PGPROC * BackendIdGetProc(int backendID)
Snapshot GetTransactionSnapshot(void)
void UnregisterSnapshot(Snapshot snapshot)
void PushActiveSnapshot(Snapshot snapshot)
Snapshot RegisterSnapshot(Snapshot snapshot)
void PopActiveSnapshot(void)
void relation_close(Relation relation, LOCKMODE lockmode)
Relation relation_open(Oid relationId, LOCKMODE lockmode)
#define HTEqualStrategyNumber
#define BTEqualStrategyNumber
#define ERRCODE_DUPLICATE_OBJECT
struct ErrorContextCallback * previous
void(* callback)(void *arg)
amoptions_function amoptions
amgettuple_function amgettuple
SortByNulls nulls_ordering
uint16 * ii_ExclusionStrats
Datum * ii_OpclassOptions
AttrNumber ii_IndexAttrNumbers[INDEX_MAX_KEYS]
SubTransactionId oldFirstRelfilelocatorSubid
SubTransactionId oldCreateSubid
Oid values[FLEXIBLE_ARRAY_MEMBER]
#define FirstLowInvalidHeapAttributeNumber
void ReleaseSysCache(HeapTuple tuple)
HeapTuple SearchSysCache1(int cacheId, Datum key1)
HeapTuple SearchSysCache3(int cacheId, Datum key1, Datum key2, Datum key3)
HeapTuple SearchSysCacheAttName(Oid relid, const char *attname)
Datum SysCacheGetAttrNotNull(int cacheId, HeapTuple tup, AttrNumber attributeNumber)
#define SearchSysCacheCopy1(cacheId, key1)
#define SearchSysCacheExists1(cacheId, key1)
Relation try_table_open(Oid relationId, LOCKMODE lockmode)
void table_close(Relation relation, LOCKMODE lockmode)
Relation table_open(Oid relationId, LOCKMODE lockmode)
TableScanDesc table_beginscan_catalog(Relation relation, int nkeys, struct ScanKeyData *key)
static void table_endscan(TableScanDesc scan)
void RangeVarCallbackOwnsTable(const RangeVar *relation, Oid relId, Oid oldRelId, void *arg)
void CheckTableNotInUse(Relation rel, const char *stmt)
void SetRelationHasSubclass(Oid relationId, bool relhassubclass)
#define InvalidTransactionId
#define TupleDescAttr(tupdesc, i)
void pull_varattnos(Node *node, Index varno, Bitmapset **varattnos)
void CommandCounterIncrement(void)
void PreventInTransactionBlock(bool isTopLevel, const char *stmtType)
void StartTransactionCommand(void)
void CommitTransactionCommand(void)