PostgreSQL Source Code  git master
indexing.h File Reference
#include "access/htup.h"
#include "nodes/execnodes.h"
#include "utils/relcache.h"
Include dependency graph for indexing.h:
This graph shows which files directly or indirectly include this file:

Go to the source code of this file.

Macros

#define MAX_CATALOG_MULTI_INSERT_BYTES   65535
 
#define DECLARE_INDEX(name, oid, decl)   extern int no_such_variable
 
#define DECLARE_UNIQUE_INDEX(name, oid, decl)   extern int no_such_variable
 
#define AggregateFnoidIndexId   2650
 
#define AmNameIndexId   2651
 
#define AmOidIndexId   2652
 
#define AccessMethodStrategyIndexId   2653
 
#define AccessMethodOperatorIndexId   2654
 
#define AccessMethodOperatorOidIndexId   2756
 
#define AccessMethodProcedureIndexId   2655
 
#define AccessMethodProcedureOidIndexId   2757
 
#define AttrDefaultIndexId   2656
 
#define AttrDefaultOidIndexId   2657
 
#define AttributeRelidNameIndexId   2658
 
#define AttributeRelidNumIndexId   2659
 
#define AuthIdRolnameIndexId   2676
 
#define AuthIdOidIndexId   2677
 
#define AuthMemRoleMemIndexId   2694
 
#define AuthMemMemRoleIndexId   2695
 
#define CastOidIndexId   2660
 
#define CastSourceTargetIndexId   2661
 
#define ClassOidIndexId   2662
 
#define ClassNameNspIndexId   2663
 
#define ClassTblspcRelfilenodeIndexId   3455
 
#define CollationNameEncNspIndexId   3164
 
#define CollationOidIndexId   3085
 
#define ConstraintNameNspIndexId   2664
 
#define ConstraintRelidTypidNameIndexId   2665
 
#define ConstraintTypidIndexId   2666
 
#define ConstraintOidIndexId   2667
 
#define ConstraintParentIndexId   2579
 
#define ConversionDefaultIndexId   2668
 
#define ConversionNameNspIndexId   2669
 
#define ConversionOidIndexId   2670
 
#define DatabaseNameIndexId   2671
 
#define DatabaseOidIndexId   2672
 
#define DependDependerIndexId   2673
 
#define DependReferenceIndexId   2674
 
#define DescriptionObjIndexId   2675
 
#define SharedDescriptionObjIndexId   2397
 
#define EnumOidIndexId   3502
 
#define EnumTypIdLabelIndexId   3503
 
#define EnumTypIdSortOrderIndexId   3534
 
#define IndexIndrelidIndexId   2678
 
#define IndexRelidIndexId   2679
 
#define InheritsRelidSeqnoIndexId   2680
 
#define InheritsParentIndexId   2187
 
#define InitPrivsObjIndexId   3395
 
#define LanguageNameIndexId   2681
 
#define LanguageOidIndexId   2682
 
#define LargeObjectLOidPNIndexId   2683
 
#define LargeObjectMetadataOidIndexId   2996
 
#define NamespaceNameIndexId   2684
 
#define NamespaceOidIndexId   2685
 
#define OpclassAmNameNspIndexId   2686
 
#define OpclassOidIndexId   2687
 
#define OperatorOidIndexId   2688
 
#define OperatorNameNspIndexId   2689
 
#define OpfamilyAmNameNspIndexId   2754
 
#define OpfamilyOidIndexId   2755
 
#define ProcedureOidIndexId   2690
 
#define ProcedureNameArgsNspIndexId   2691
 
#define RewriteOidIndexId   2692
 
#define RewriteRelRulenameIndexId   2693
 
#define SequenceRelidIndexId   5002
 
#define SharedDependDependerIndexId   1232
 
#define SharedDependReferenceIndexId   1233
 
#define StatisticRelidAttnumInhIndexId   2696
 
#define StatisticExtOidIndexId   3380
 
#define StatisticExtNameIndexId   3997
 
#define StatisticExtRelidIndexId   3379
 
#define StatisticExtDataStxoidIndexId   3433
 
#define TablespaceOidIndexId   2697
 
#define TablespaceNameIndexId   2698
 
#define TransformOidIndexId   3574
 
#define TransformTypeLangIndexId   3575
 
#define TriggerConstraintIndexId   2699
 
#define TriggerRelidNameIndexId   2701
 
#define TriggerOidIndexId   2702
 
#define EventTriggerNameIndexId   3467
 
#define EventTriggerOidIndexId   3468
 
#define TSConfigNameNspIndexId   3608
 
#define TSConfigOidIndexId   3712
 
#define TSConfigMapIndexId   3609
 
#define TSDictionaryNameNspIndexId   3604
 
#define TSDictionaryOidIndexId   3605
 
#define TSParserNameNspIndexId   3606
 
#define TSParserOidIndexId   3607
 
#define TSTemplateNameNspIndexId   3766
 
#define TSTemplateOidIndexId   3767
 
#define TypeOidIndexId   2703
 
#define TypeNameNspIndexId   2704
 
#define ForeignDataWrapperOidIndexId   112
 
#define ForeignDataWrapperNameIndexId   548
 
#define ForeignServerOidIndexId   113
 
#define ForeignServerNameIndexId   549
 
#define UserMappingOidIndexId   174
 
#define UserMappingUserServerIndexId   175
 
#define ForeignTableRelidIndexId   3119
 
#define DefaultAclRoleNspObjIndexId   827
 
#define DefaultAclOidIndexId   828
 
#define DbRoleSettingDatidRolidIndexId   2965
 
#define SecLabelObjectIndexId   3597
 
#define SharedSecLabelObjectIndexId   3593
 
#define ExtensionOidIndexId   3080
 
#define ExtensionNameIndexId   3081
 
#define RangeTypidIndexId   3542
 
#define PolicyOidIndexId   3257
 
#define PolicyPolrelidPolnameIndexId   3258
 
#define ReplicationOriginIdentIndex   6001
 
#define ReplicationOriginNameIndex   6002
 
#define PartitionedRelidIndexId   3351
 
#define PublicationObjectIndexId   6110
 
#define PublicationNameIndexId   6111
 
#define PublicationRelObjectIndexId   6112
 
#define PublicationRelPrrelidPrpubidIndexId   6113
 
#define SubscriptionObjectIndexId   6114
 
#define SubscriptionNameIndexId   6115
 
#define SubscriptionRelSrrelidSrsubidIndexId   6117
 

Typedefs

typedef struct ResultRelInfoCatalogIndexState
 

Functions

CatalogIndexState CatalogOpenIndexes (Relation heapRel)
 
void CatalogCloseIndexes (CatalogIndexState indstate)
 
void CatalogTupleInsert (Relation heapRel, HeapTuple tup)
 
void CatalogTupleInsertWithInfo (Relation heapRel, HeapTuple tup, CatalogIndexState indstate)
 
void CatalogTuplesMultiInsertWithInfo (Relation heapRel, TupleTableSlot **slot, int ntuples, CatalogIndexState indstate)
 
void CatalogTupleUpdate (Relation heapRel, ItemPointer otid, HeapTuple tup)
 
void CatalogTupleUpdateWithInfo (Relation heapRel, ItemPointer otid, HeapTuple tup, CatalogIndexState indstate)
 
void CatalogTupleDelete (Relation heapRel, ItemPointer tid)
 
 DECLARE_UNIQUE_INDEX (pg_aggregate_fnoid_index, 2650, on pg_aggregate using btree(aggfnoid oid_ops))
 
 DECLARE_UNIQUE_INDEX (pg_am_name_index, 2651, on pg_am using btree(amname name_ops))
 
 DECLARE_UNIQUE_INDEX (pg_am_oid_index, 2652, on pg_am using btree(oid oid_ops))
 
 DECLARE_UNIQUE_INDEX (pg_amop_fam_strat_index, 2653, on pg_amop using btree(amopfamily oid_ops, amoplefttype oid_ops, amoprighttype oid_ops, amopstrategy int2_ops))
 
 DECLARE_UNIQUE_INDEX (pg_amop_opr_fam_index, 2654, on pg_amop using btree(amopopr oid_ops, amoppurpose char_ops, amopfamily oid_ops))
 
 DECLARE_UNIQUE_INDEX (pg_amop_oid_index, 2756, on pg_amop using btree(oid oid_ops))
 
 DECLARE_UNIQUE_INDEX (pg_amproc_fam_proc_index, 2655, on pg_amproc using btree(amprocfamily oid_ops, amproclefttype oid_ops, amprocrighttype oid_ops, amprocnum int2_ops))
 
 DECLARE_UNIQUE_INDEX (pg_amproc_oid_index, 2757, on pg_amproc using btree(oid oid_ops))
 
 DECLARE_UNIQUE_INDEX (pg_attrdef_adrelid_adnum_index, 2656, on pg_attrdef using btree(adrelid oid_ops, adnum int2_ops))
 
 DECLARE_UNIQUE_INDEX (pg_attrdef_oid_index, 2657, on pg_attrdef using btree(oid oid_ops))
 
 DECLARE_UNIQUE_INDEX (pg_attribute_relid_attnam_index, 2658, on pg_attribute using btree(attrelid oid_ops, attname name_ops))
 
 DECLARE_UNIQUE_INDEX (pg_attribute_relid_attnum_index, 2659, on pg_attribute using btree(attrelid oid_ops, attnum int2_ops))
 
 DECLARE_UNIQUE_INDEX (pg_authid_rolname_index, 2676, on pg_authid using btree(rolname name_ops))
 
 DECLARE_UNIQUE_INDEX (pg_authid_oid_index, 2677, on pg_authid using btree(oid oid_ops))
 
 DECLARE_UNIQUE_INDEX (pg_auth_members_role_member_index, 2694, on pg_auth_members using btree(roleid oid_ops, member oid_ops))
 
 DECLARE_UNIQUE_INDEX (pg_auth_members_member_role_index, 2695, on pg_auth_members using btree(member oid_ops, roleid oid_ops))
 
 DECLARE_UNIQUE_INDEX (pg_cast_oid_index, 2660, on pg_cast using btree(oid oid_ops))
 
 DECLARE_UNIQUE_INDEX (pg_cast_source_target_index, 2661, on pg_cast using btree(castsource oid_ops, casttarget oid_ops))
 
 DECLARE_UNIQUE_INDEX (pg_class_oid_index, 2662, on pg_class using btree(oid oid_ops))
 
 DECLARE_UNIQUE_INDEX (pg_class_relname_nsp_index, 2663, on pg_class using btree(relname name_ops, relnamespace oid_ops))
 
 DECLARE_INDEX (pg_class_tblspc_relfilenode_index, 3455, on pg_class using btree(reltablespace oid_ops, relfilenode oid_ops))
 
 DECLARE_UNIQUE_INDEX (pg_collation_name_enc_nsp_index, 3164, on pg_collation using btree(collname name_ops, collencoding int4_ops, collnamespace oid_ops))
 
 DECLARE_UNIQUE_INDEX (pg_collation_oid_index, 3085, on pg_collation using btree(oid oid_ops))
 
 DECLARE_INDEX (pg_constraint_conname_nsp_index, 2664, on pg_constraint using btree(conname name_ops, connamespace oid_ops))
 
 DECLARE_UNIQUE_INDEX (pg_constraint_conrelid_contypid_conname_index, 2665, on pg_constraint using btree(conrelid oid_ops, contypid oid_ops, conname name_ops))
 
 DECLARE_INDEX (pg_constraint_contypid_index, 2666, on pg_constraint using btree(contypid oid_ops))
 
 DECLARE_UNIQUE_INDEX (pg_constraint_oid_index, 2667, on pg_constraint using btree(oid oid_ops))
 
 DECLARE_INDEX (pg_constraint_conparentid_index, 2579, on pg_constraint using btree(conparentid oid_ops))
 
 DECLARE_UNIQUE_INDEX (pg_conversion_default_index, 2668, on pg_conversion using btree(connamespace oid_ops, conforencoding int4_ops, contoencoding int4_ops, oid oid_ops))
 
 DECLARE_UNIQUE_INDEX (pg_conversion_name_nsp_index, 2669, on pg_conversion using btree(conname name_ops, connamespace oid_ops))
 
 DECLARE_UNIQUE_INDEX (pg_conversion_oid_index, 2670, on pg_conversion using btree(oid oid_ops))
 
 DECLARE_UNIQUE_INDEX (pg_database_datname_index, 2671, on pg_database using btree(datname name_ops))
 
 DECLARE_UNIQUE_INDEX (pg_database_oid_index, 2672, on pg_database using btree(oid oid_ops))
 
 DECLARE_INDEX (pg_depend_depender_index, 2673, on pg_depend using btree(classid oid_ops, objid oid_ops, objsubid int4_ops))
 
 DECLARE_INDEX (pg_depend_reference_index, 2674, on pg_depend using btree(refclassid oid_ops, refobjid oid_ops, refobjsubid int4_ops))
 
 DECLARE_UNIQUE_INDEX (pg_description_o_c_o_index, 2675, on pg_description using btree(objoid oid_ops, classoid oid_ops, objsubid int4_ops))
 
 DECLARE_UNIQUE_INDEX (pg_shdescription_o_c_index, 2397, on pg_shdescription using btree(objoid oid_ops, classoid oid_ops))
 
 DECLARE_UNIQUE_INDEX (pg_enum_oid_index, 3502, on pg_enum using btree(oid oid_ops))
 
 DECLARE_UNIQUE_INDEX (pg_enum_typid_label_index, 3503, on pg_enum using btree(enumtypid oid_ops, enumlabel name_ops))
 
 DECLARE_UNIQUE_INDEX (pg_enum_typid_sortorder_index, 3534, on pg_enum using btree(enumtypid oid_ops, enumsortorder float4_ops))
 
 DECLARE_INDEX (pg_index_indrelid_index, 2678, on pg_index using btree(indrelid oid_ops))
 
 DECLARE_UNIQUE_INDEX (pg_index_indexrelid_index, 2679, on pg_index using btree(indexrelid oid_ops))
 
 DECLARE_UNIQUE_INDEX (pg_inherits_relid_seqno_index, 2680, on pg_inherits using btree(inhrelid oid_ops, inhseqno int4_ops))
 
 DECLARE_INDEX (pg_inherits_parent_index, 2187, on pg_inherits using btree(inhparent oid_ops))
 
 DECLARE_UNIQUE_INDEX (pg_init_privs_o_c_o_index, 3395, on pg_init_privs using btree(objoid oid_ops, classoid oid_ops, objsubid int4_ops))
 
 DECLARE_UNIQUE_INDEX (pg_language_name_index, 2681, on pg_language using btree(lanname name_ops))
 
 DECLARE_UNIQUE_INDEX (pg_language_oid_index, 2682, on pg_language using btree(oid oid_ops))
 
 DECLARE_UNIQUE_INDEX (pg_largeobject_loid_pn_index, 2683, on pg_largeobject using btree(loid oid_ops, pageno int4_ops))
 
 DECLARE_UNIQUE_INDEX (pg_largeobject_metadata_oid_index, 2996, on pg_largeobject_metadata using btree(oid oid_ops))
 
 DECLARE_UNIQUE_INDEX (pg_namespace_nspname_index, 2684, on pg_namespace using btree(nspname name_ops))
 
 DECLARE_UNIQUE_INDEX (pg_namespace_oid_index, 2685, on pg_namespace using btree(oid oid_ops))
 
 DECLARE_UNIQUE_INDEX (pg_opclass_am_name_nsp_index, 2686, on pg_opclass using btree(opcmethod oid_ops, opcname name_ops, opcnamespace oid_ops))
 
 DECLARE_UNIQUE_INDEX (pg_opclass_oid_index, 2687, on pg_opclass using btree(oid oid_ops))
 
 DECLARE_UNIQUE_INDEX (pg_operator_oid_index, 2688, on pg_operator using btree(oid oid_ops))
 
 DECLARE_UNIQUE_INDEX (pg_operator_oprname_l_r_n_index, 2689, on pg_operator using btree(oprname name_ops, oprleft oid_ops, oprright oid_ops, oprnamespace oid_ops))
 
 DECLARE_UNIQUE_INDEX (pg_opfamily_am_name_nsp_index, 2754, on pg_opfamily using btree(opfmethod oid_ops, opfname name_ops, opfnamespace oid_ops))
 
 DECLARE_UNIQUE_INDEX (pg_opfamily_oid_index, 2755, on pg_opfamily using btree(oid oid_ops))
 
 DECLARE_UNIQUE_INDEX (pg_proc_oid_index, 2690, on pg_proc using btree(oid oid_ops))
 
 DECLARE_UNIQUE_INDEX (pg_proc_proname_args_nsp_index, 2691, on pg_proc using btree(proname name_ops, proargtypes oidvector_ops, pronamespace oid_ops))
 
 DECLARE_UNIQUE_INDEX (pg_rewrite_oid_index, 2692, on pg_rewrite using btree(oid oid_ops))
 
 DECLARE_UNIQUE_INDEX (pg_rewrite_rel_rulename_index, 2693, on pg_rewrite using btree(ev_class oid_ops, rulename name_ops))
 
 DECLARE_UNIQUE_INDEX (pg_sequence_seqrelid_index, 5002, on pg_sequence using btree(seqrelid oid_ops))
 
 DECLARE_INDEX (pg_shdepend_depender_index, 1232, on pg_shdepend using btree(dbid oid_ops, classid oid_ops, objid oid_ops, objsubid int4_ops))
 
 DECLARE_INDEX (pg_shdepend_reference_index, 1233, on pg_shdepend using btree(refclassid oid_ops, refobjid oid_ops))
 
 DECLARE_UNIQUE_INDEX (pg_statistic_relid_att_inh_index, 2696, on pg_statistic using btree(starelid oid_ops, staattnum int2_ops, stainherit bool_ops))
 
 DECLARE_UNIQUE_INDEX (pg_statistic_ext_oid_index, 3380, on pg_statistic_ext using btree(oid oid_ops))
 
 DECLARE_UNIQUE_INDEX (pg_statistic_ext_name_index, 3997, on pg_statistic_ext using btree(stxname name_ops, stxnamespace oid_ops))
 
 DECLARE_INDEX (pg_statistic_ext_relid_index, 3379, on pg_statistic_ext using btree(stxrelid oid_ops))
 
 DECLARE_UNIQUE_INDEX (pg_statistic_ext_data_stxoid_index, 3433, on pg_statistic_ext_data using btree(stxoid oid_ops))
 
 DECLARE_UNIQUE_INDEX (pg_tablespace_oid_index, 2697, on pg_tablespace using btree(oid oid_ops))
 
 DECLARE_UNIQUE_INDEX (pg_tablespace_spcname_index, 2698, on pg_tablespace using btree(spcname name_ops))
 
 DECLARE_UNIQUE_INDEX (pg_transform_oid_index, 3574, on pg_transform using btree(oid oid_ops))
 
 DECLARE_UNIQUE_INDEX (pg_transform_type_lang_index, 3575, on pg_transform using btree(trftype oid_ops, trflang oid_ops))
 
 DECLARE_INDEX (pg_trigger_tgconstraint_index, 2699, on pg_trigger using btree(tgconstraint oid_ops))
 
 DECLARE_UNIQUE_INDEX (pg_trigger_tgrelid_tgname_index, 2701, on pg_trigger using btree(tgrelid oid_ops, tgname name_ops))
 
 DECLARE_UNIQUE_INDEX (pg_trigger_oid_index, 2702, on pg_trigger using btree(oid oid_ops))
 
 DECLARE_UNIQUE_INDEX (pg_event_trigger_evtname_index, 3467, on pg_event_trigger using btree(evtname name_ops))
 
 DECLARE_UNIQUE_INDEX (pg_event_trigger_oid_index, 3468, on pg_event_trigger using btree(oid oid_ops))
 
 DECLARE_UNIQUE_INDEX (pg_ts_config_cfgname_index, 3608, on pg_ts_config using btree(cfgname name_ops, cfgnamespace oid_ops))
 
 DECLARE_UNIQUE_INDEX (pg_ts_config_oid_index, 3712, on pg_ts_config using btree(oid oid_ops))
 
 DECLARE_UNIQUE_INDEX (pg_ts_config_map_index, 3609, on pg_ts_config_map using btree(mapcfg oid_ops, maptokentype int4_ops, mapseqno int4_ops))
 
 DECLARE_UNIQUE_INDEX (pg_ts_dict_dictname_index, 3604, on pg_ts_dict using btree(dictname name_ops, dictnamespace oid_ops))
 
 DECLARE_UNIQUE_INDEX (pg_ts_dict_oid_index, 3605, on pg_ts_dict using btree(oid oid_ops))
 
 DECLARE_UNIQUE_INDEX (pg_ts_parser_prsname_index, 3606, on pg_ts_parser using btree(prsname name_ops, prsnamespace oid_ops))
 
 DECLARE_UNIQUE_INDEX (pg_ts_parser_oid_index, 3607, on pg_ts_parser using btree(oid oid_ops))
 
 DECLARE_UNIQUE_INDEX (pg_ts_template_tmplname_index, 3766, on pg_ts_template using btree(tmplname name_ops, tmplnamespace oid_ops))
 
 DECLARE_UNIQUE_INDEX (pg_ts_template_oid_index, 3767, on pg_ts_template using btree(oid oid_ops))
 
 DECLARE_UNIQUE_INDEX (pg_type_oid_index, 2703, on pg_type using btree(oid oid_ops))
 
 DECLARE_UNIQUE_INDEX (pg_type_typname_nsp_index, 2704, on pg_type using btree(typname name_ops, typnamespace oid_ops))
 
 DECLARE_UNIQUE_INDEX (pg_foreign_data_wrapper_oid_index, 112, on pg_foreign_data_wrapper using btree(oid oid_ops))
 
 DECLARE_UNIQUE_INDEX (pg_foreign_data_wrapper_name_index, 548, on pg_foreign_data_wrapper using btree(fdwname name_ops))
 
 DECLARE_UNIQUE_INDEX (pg_foreign_server_oid_index, 113, on pg_foreign_server using btree(oid oid_ops))
 
 DECLARE_UNIQUE_INDEX (pg_foreign_server_name_index, 549, on pg_foreign_server using btree(srvname name_ops))
 
 DECLARE_UNIQUE_INDEX (pg_user_mapping_oid_index, 174, on pg_user_mapping using btree(oid oid_ops))
 
 DECLARE_UNIQUE_INDEX (pg_user_mapping_user_server_index, 175, on pg_user_mapping using btree(umuser oid_ops, umserver oid_ops))
 
 DECLARE_UNIQUE_INDEX (pg_foreign_table_relid_index, 3119, on pg_foreign_table using btree(ftrelid oid_ops))
 
 DECLARE_UNIQUE_INDEX (pg_default_acl_role_nsp_obj_index, 827, on pg_default_acl using btree(defaclrole oid_ops, defaclnamespace oid_ops, defaclobjtype char_ops))
 
 DECLARE_UNIQUE_INDEX (pg_default_acl_oid_index, 828, on pg_default_acl using btree(oid oid_ops))
 
 DECLARE_UNIQUE_INDEX (pg_db_role_setting_databaseid_rol_index, 2965, on pg_db_role_setting using btree(setdatabase oid_ops, setrole oid_ops))
 
 DECLARE_UNIQUE_INDEX (pg_seclabel_object_index, 3597, on pg_seclabel using btree(objoid oid_ops, classoid oid_ops, objsubid int4_ops, provider text_ops))
 
 DECLARE_UNIQUE_INDEX (pg_shseclabel_object_index, 3593, on pg_shseclabel using btree(objoid oid_ops, classoid oid_ops, provider text_ops))
 
 DECLARE_UNIQUE_INDEX (pg_extension_oid_index, 3080, on pg_extension using btree(oid oid_ops))
 
 DECLARE_UNIQUE_INDEX (pg_extension_name_index, 3081, on pg_extension using btree(extname name_ops))
 
 DECLARE_UNIQUE_INDEX (pg_range_rngtypid_index, 3542, on pg_range using btree(rngtypid oid_ops))
 
 DECLARE_UNIQUE_INDEX (pg_policy_oid_index, 3257, on pg_policy using btree(oid oid_ops))
 
 DECLARE_UNIQUE_INDEX (pg_policy_polrelid_polname_index, 3258, on pg_policy using btree(polrelid oid_ops, polname name_ops))
 
 DECLARE_UNIQUE_INDEX (pg_replication_origin_roiident_index, 6001, on pg_replication_origin using btree(roident oid_ops))
 
 DECLARE_UNIQUE_INDEX (pg_replication_origin_roname_index, 6002, on pg_replication_origin using btree(roname text_ops))
 
 DECLARE_UNIQUE_INDEX (pg_partitioned_table_partrelid_index, 3351, on pg_partitioned_table using btree(partrelid oid_ops))
 
 DECLARE_UNIQUE_INDEX (pg_publication_oid_index, 6110, on pg_publication using btree(oid oid_ops))
 
 DECLARE_UNIQUE_INDEX (pg_publication_pubname_index, 6111, on pg_publication using btree(pubname name_ops))
 
 DECLARE_UNIQUE_INDEX (pg_publication_rel_oid_index, 6112, on pg_publication_rel using btree(oid oid_ops))
 
 DECLARE_UNIQUE_INDEX (pg_publication_rel_prrelid_prpubid_index, 6113, on pg_publication_rel using btree(prrelid oid_ops, prpubid oid_ops))
 
 DECLARE_UNIQUE_INDEX (pg_subscription_oid_index, 6114, on pg_subscription using btree(oid oid_ops))
 
 DECLARE_UNIQUE_INDEX (pg_subscription_subname_index, 6115, on pg_subscription using btree(subdbid oid_ops, subname name_ops))
 
 DECLARE_UNIQUE_INDEX (pg_subscription_rel_srrelid_srsubid_index, 6117, on pg_subscription_rel using btree(srrelid oid_ops, srsubid oid_ops))
 

Macro Definition Documentation

◆ AccessMethodOperatorIndexId

#define AccessMethodOperatorIndexId   2654

Definition at line 90 of file indexing.h.

◆ AccessMethodOperatorOidIndexId

#define AccessMethodOperatorOidIndexId   2756

Definition at line 92 of file indexing.h.

Referenced by getObjectDescription(), getObjectIdentityParts(), and storeOperators().

◆ AccessMethodProcedureIndexId

#define AccessMethodProcedureIndexId   2655

Definition at line 95 of file indexing.h.

Referenced by LookupOpclassInfo(), and RelationCacheInitializePhase3().

◆ AccessMethodProcedureOidIndexId

#define AccessMethodProcedureOidIndexId   2757

Definition at line 97 of file indexing.h.

Referenced by getObjectDescription(), getObjectIdentityParts(), and storeProcedures().

◆ AccessMethodStrategyIndexId

#define AccessMethodStrategyIndexId   2653

Definition at line 88 of file indexing.h.

◆ AggregateFnoidIndexId

#define AggregateFnoidIndexId   2650

Definition at line 80 of file indexing.h.

◆ AmNameIndexId

#define AmNameIndexId   2651

Definition at line 83 of file indexing.h.

◆ AmOidIndexId

#define AmOidIndexId   2652

Definition at line 85 of file indexing.h.

Referenced by CreateAccessMethod().

◆ AttrDefaultIndexId

#define AttrDefaultIndexId   2656

Definition at line 100 of file indexing.h.

Referenced by AttrDefaultFetch(), get_object_address_attrdef(), and RemoveAttrDefault().

◆ AttrDefaultOidIndexId

#define AttrDefaultOidIndexId   2657

◆ AttributeRelidNameIndexId

#define AttributeRelidNameIndexId   2658

Definition at line 105 of file indexing.h.

◆ AttributeRelidNumIndexId

◆ AuthIdOidIndexId

#define AuthIdOidIndexId   2677

Definition at line 112 of file indexing.h.

Referenced by CreateRole(), IsSharedRelation(), and RelationCacheInitializePhase3().

◆ AuthIdRolnameIndexId

#define AuthIdRolnameIndexId   2676

Definition at line 110 of file indexing.h.

Referenced by IsSharedRelation(), and RelationCacheInitializePhase3().

◆ AuthMemMemRoleIndexId

#define AuthMemMemRoleIndexId   2695

Definition at line 117 of file indexing.h.

Referenced by DropRole(), IsSharedRelation(), and RelationCacheInitializePhase3().

◆ AuthMemRoleMemIndexId

#define AuthMemRoleMemIndexId   2694

Definition at line 115 of file indexing.h.

Referenced by DropRole(), and IsSharedRelation().

◆ CastOidIndexId

#define CastOidIndexId   2660

Definition at line 120 of file indexing.h.

Referenced by CastCreate(), and getObjectDescription().

◆ CastSourceTargetIndexId

#define CastSourceTargetIndexId   2661

Definition at line 122 of file indexing.h.

◆ ClassNameNspIndexId

#define ClassNameNspIndexId   2663

Definition at line 127 of file indexing.h.

◆ ClassOidIndexId

◆ ClassTblspcRelfilenodeIndexId

#define ClassTblspcRelfilenodeIndexId   3455

Definition at line 129 of file indexing.h.

Referenced by RelidByRelfilenode().

◆ CollationNameEncNspIndexId

#define CollationNameEncNspIndexId   3164

Definition at line 132 of file indexing.h.

◆ CollationOidIndexId

#define CollationOidIndexId   3085

Definition at line 134 of file indexing.h.

Referenced by CollationCreate().

◆ ConstraintNameNspIndexId

#define ConstraintNameNspIndexId   2664

Definition at line 137 of file indexing.h.

Referenced by AfterTriggerSetState(), ChooseConstraintName(), and ConstraintNameExists().

◆ ConstraintOidIndexId

#define ConstraintOidIndexId   2667

◆ ConstraintParentIndexId

#define ConstraintParentIndexId   2579

Definition at line 145 of file indexing.h.

Referenced by AfterTriggerSetState().

◆ ConstraintRelidTypidNameIndexId

◆ ConstraintTypidIndexId

#define ConstraintTypidIndexId   2666

Definition at line 141 of file indexing.h.

Referenced by load_domaintype_info().

◆ ConversionDefaultIndexId

#define ConversionDefaultIndexId   2668

Definition at line 148 of file indexing.h.

◆ ConversionNameNspIndexId

#define ConversionNameNspIndexId   2669

Definition at line 150 of file indexing.h.

◆ ConversionOidIndexId

#define ConversionOidIndexId   2670

Definition at line 152 of file indexing.h.

Referenced by ConversionCreate().

◆ DatabaseNameIndexId

◆ DatabaseOidIndexId

#define DatabaseOidIndexId   2672

◆ DbRoleSettingDatidRolidIndexId

#define DbRoleSettingDatidRolidIndexId   2965

Definition at line 325 of file indexing.h.

Referenced by AlterSetting(), ApplySetting(), and IsSharedRelation().

◆ DECLARE_INDEX

#define DECLARE_INDEX (   name,
  oid,
  decl 
)    extern int no_such_variable

Definition at line 62 of file indexing.h.

◆ DECLARE_UNIQUE_INDEX

#define DECLARE_UNIQUE_INDEX (   name,
  oid,
  decl 
)    extern int no_such_variable

Definition at line 63 of file indexing.h.

◆ DefaultAclOidIndexId

#define DefaultAclOidIndexId   828

◆ DefaultAclRoleNspObjIndexId

#define DefaultAclRoleNspObjIndexId   827

Definition at line 320 of file indexing.h.

◆ DependDependerIndexId

◆ DependReferenceIndexId

◆ DescriptionObjIndexId

#define DescriptionObjIndexId   2675

Definition at line 165 of file indexing.h.

Referenced by CreateComments(), DeleteComments(), GetComment(), and index_concurrently_swap().

◆ EnumOidIndexId

#define EnumOidIndexId   3502

Definition at line 170 of file indexing.h.

Referenced by AddEnumLabel(), and EnumValuesCreate().

◆ EnumTypIdLabelIndexId

#define EnumTypIdLabelIndexId   3503

Definition at line 172 of file indexing.h.

Referenced by EnumValuesDelete(), and load_enum_cache_data().

◆ EnumTypIdSortOrderIndexId

#define EnumTypIdSortOrderIndexId   3534

Definition at line 174 of file indexing.h.

Referenced by enum_endpoint(), and enum_range_internal().

◆ EventTriggerNameIndexId

#define EventTriggerNameIndexId   3467

Definition at line 269 of file indexing.h.

Referenced by BuildEventTriggerCache().

◆ EventTriggerOidIndexId

#define EventTriggerOidIndexId   3468

Definition at line 271 of file indexing.h.

Referenced by insert_event_trigger_tuple().

◆ ExtensionNameIndexId

#define ExtensionNameIndexId   3081

Definition at line 336 of file indexing.h.

Referenced by ExecAlterExtensionStmt(), and get_extension_oid().

◆ ExtensionOidIndexId

◆ ForeignDataWrapperNameIndexId

#define ForeignDataWrapperNameIndexId   548

Definition at line 304 of file indexing.h.

◆ ForeignDataWrapperOidIndexId

#define ForeignDataWrapperOidIndexId   112

Definition at line 302 of file indexing.h.

Referenced by CreateForeignDataWrapper().

◆ ForeignServerNameIndexId

#define ForeignServerNameIndexId   549

Definition at line 309 of file indexing.h.

◆ ForeignServerOidIndexId

#define ForeignServerOidIndexId   113

Definition at line 307 of file indexing.h.

Referenced by CreateForeignServer().

◆ ForeignTableRelidIndexId

#define ForeignTableRelidIndexId   3119

Definition at line 317 of file indexing.h.

◆ IndexIndrelidIndexId

#define IndexIndrelidIndexId   2678

Definition at line 177 of file indexing.h.

Referenced by get_pkey_attnames(), and RelationGetIndexList().

◆ IndexRelidIndexId

#define IndexRelidIndexId   2679

Definition at line 179 of file indexing.h.

Referenced by RelationCacheInitializePhase3(), and sepgsql_index_modify().

◆ InheritsParentIndexId

#define InheritsParentIndexId   2187

◆ InheritsRelidSeqnoIndexId

◆ InitPrivsObjIndexId

#define InitPrivsObjIndexId   3395

Definition at line 187 of file indexing.h.

Referenced by DeleteInitPrivs(), and recordExtensionInitPrivWorker().

◆ LanguageNameIndexId

#define LanguageNameIndexId   2681

Definition at line 190 of file indexing.h.

◆ LanguageOidIndexId

#define LanguageOidIndexId   2682

Definition at line 192 of file indexing.h.

Referenced by CreateProceduralLanguage().

◆ LargeObjectLOidPNIndexId

#define LargeObjectLOidPNIndexId   2683

Definition at line 195 of file indexing.h.

Referenced by LargeObjectDrop(), and open_lo_relation().

◆ LargeObjectMetadataOidIndexId

◆ MAX_CATALOG_MULTI_INSERT_BYTES

#define MAX_CATALOG_MULTI_INSERT_BYTES   65535

◆ NamespaceNameIndexId

#define NamespaceNameIndexId   2684

Definition at line 201 of file indexing.h.

◆ NamespaceOidIndexId

#define NamespaceOidIndexId   2685

Definition at line 203 of file indexing.h.

Referenced by NamespaceCreate(), and sepgsql_schema_post_create().

◆ OpclassAmNameNspIndexId

#define OpclassAmNameNspIndexId   2686

Definition at line 206 of file indexing.h.

Referenced by DefineOpClass(), and GetDefaultOpClass().

◆ OpclassOidIndexId

#define OpclassOidIndexId   2687

Definition at line 208 of file indexing.h.

Referenced by DefineOpClass(), LookupOpclassInfo(), and RelationCacheInitializePhase3().

◆ OperatorNameNspIndexId

#define OperatorNameNspIndexId   2689

Definition at line 213 of file indexing.h.

◆ OperatorOidIndexId

#define OperatorOidIndexId   2688

Definition at line 211 of file indexing.h.

Referenced by OperatorCreate(), and OperatorShellMake().

◆ OpfamilyAmNameNspIndexId

#define OpfamilyAmNameNspIndexId   2754

Definition at line 216 of file indexing.h.

◆ OpfamilyOidIndexId

#define OpfamilyOidIndexId   2755

Definition at line 218 of file indexing.h.

Referenced by CreateOpFamily().

◆ PartitionedRelidIndexId

#define PartitionedRelidIndexId   3351

Definition at line 354 of file indexing.h.

◆ PolicyOidIndexId

#define PolicyOidIndexId   3257

◆ PolicyPolrelidPolnameIndexId

#define PolicyPolrelidPolnameIndexId   3258

◆ ProcedureNameArgsNspIndexId

#define ProcedureNameArgsNspIndexId   2691

Definition at line 223 of file indexing.h.

◆ ProcedureOidIndexId

#define ProcedureOidIndexId   2690

Definition at line 221 of file indexing.h.

Referenced by ProcedureCreate(), sepgsql_proc_post_create(), and sepgsql_proc_setattr().

◆ PublicationNameIndexId

#define PublicationNameIndexId   6111

Definition at line 360 of file indexing.h.

◆ PublicationObjectIndexId

#define PublicationObjectIndexId   6110

Definition at line 357 of file indexing.h.

Referenced by CreatePublication().

◆ PublicationRelObjectIndexId

#define PublicationRelObjectIndexId   6112

Definition at line 363 of file indexing.h.

Referenced by publication_add_relation().

◆ PublicationRelPrrelidPrpubidIndexId

#define PublicationRelPrrelidPrpubidIndexId   6113

Definition at line 366 of file indexing.h.

Referenced by GetPublicationRelations().

◆ RangeTypidIndexId

#define RangeTypidIndexId   3542

Definition at line 339 of file indexing.h.

Referenced by RangeDelete().

◆ ReplicationOriginIdentIndex

#define ReplicationOriginIdentIndex   6001

Definition at line 348 of file indexing.h.

Referenced by IsSharedRelation(), and replorigin_create().

◆ ReplicationOriginNameIndex

#define ReplicationOriginNameIndex   6002

Definition at line 351 of file indexing.h.

Referenced by IsSharedRelation().

◆ RewriteOidIndexId

#define RewriteOidIndexId   2692

Definition at line 226 of file indexing.h.

Referenced by getObjectDescription(), InsertRule(), and RemoveRewriteRuleById().

◆ RewriteRelRulenameIndexId

#define RewriteRelRulenameIndexId   2693

Definition at line 228 of file indexing.h.

Referenced by RelationBuildRuleLock(), and RelationCacheInitializePhase3().

◆ SecLabelObjectIndexId

#define SecLabelObjectIndexId   3597

Definition at line 328 of file indexing.h.

Referenced by DeleteSecurityLabel(), GetSecurityLabel(), and SetSecurityLabel().

◆ SequenceRelidIndexId

#define SequenceRelidIndexId   5002

Definition at line 231 of file indexing.h.

◆ SharedDependDependerIndexId

#define SharedDependDependerIndexId   1232

◆ SharedDependReferenceIndexId

#define SharedDependReferenceIndexId   1233

◆ SharedDescriptionObjIndexId

#define SharedDescriptionObjIndexId   2397

Definition at line 167 of file indexing.h.

Referenced by CreateSharedComments(), DeleteSharedComments(), and IsSharedRelation().

◆ SharedSecLabelObjectIndexId

◆ StatisticExtDataStxoidIndexId

#define StatisticExtDataStxoidIndexId   3433

Definition at line 249 of file indexing.h.

◆ StatisticExtNameIndexId

#define StatisticExtNameIndexId   3997

Definition at line 244 of file indexing.h.

◆ StatisticExtOidIndexId

#define StatisticExtOidIndexId   3380

Definition at line 242 of file indexing.h.

Referenced by CreateStatistics().

◆ StatisticExtRelidIndexId

#define StatisticExtRelidIndexId   3379

Definition at line 246 of file indexing.h.

Referenced by fetch_statentries_for_relation(), and RelationGetStatExtList().

◆ StatisticRelidAttnumInhIndexId

#define StatisticRelidAttnumInhIndexId   2696

Definition at line 239 of file indexing.h.

Referenced by RemoveStatistics().

◆ SubscriptionNameIndexId

#define SubscriptionNameIndexId   6115

Definition at line 372 of file indexing.h.

Referenced by IsSharedRelation().

◆ SubscriptionObjectIndexId

#define SubscriptionObjectIndexId   6114

Definition at line 369 of file indexing.h.

Referenced by CreateSubscription(), and IsSharedRelation().

◆ SubscriptionRelSrrelidSrsubidIndexId

#define SubscriptionRelSrrelidSrsubidIndexId   6117

Definition at line 375 of file indexing.h.

◆ TablespaceNameIndexId

#define TablespaceNameIndexId   2698

Definition at line 254 of file indexing.h.

Referenced by IsSharedRelation().

◆ TablespaceOidIndexId

#define TablespaceOidIndexId   2697

Definition at line 252 of file indexing.h.

Referenced by CreateTableSpace(), and IsSharedRelation().

◆ TransformOidIndexId

#define TransformOidIndexId   3574

Definition at line 257 of file indexing.h.

Referenced by CreateTransform().

◆ TransformTypeLangIndexId

#define TransformTypeLangIndexId   3575

Definition at line 259 of file indexing.h.

◆ TriggerConstraintIndexId

#define TriggerConstraintIndexId   2699

◆ TriggerOidIndexId

#define TriggerOidIndexId   2702

◆ TriggerRelidNameIndexId

◆ TSConfigMapIndexId

◆ TSConfigNameNspIndexId

#define TSConfigNameNspIndexId   3608

Definition at line 274 of file indexing.h.

◆ TSConfigOidIndexId

#define TSConfigOidIndexId   3712

Definition at line 276 of file indexing.h.

Referenced by DefineTSConfiguration().

◆ TSDictionaryNameNspIndexId

#define TSDictionaryNameNspIndexId   3604

Definition at line 282 of file indexing.h.

◆ TSDictionaryOidIndexId

#define TSDictionaryOidIndexId   3605

Definition at line 284 of file indexing.h.

Referenced by DefineTSDictionary().

◆ TSParserNameNspIndexId

#define TSParserNameNspIndexId   3606

Definition at line 287 of file indexing.h.

◆ TSParserOidIndexId

#define TSParserOidIndexId   3607

Definition at line 289 of file indexing.h.

Referenced by DefineTSParser().

◆ TSTemplateNameNspIndexId

#define TSTemplateNameNspIndexId   3766

Definition at line 292 of file indexing.h.

◆ TSTemplateOidIndexId

#define TSTemplateOidIndexId   3767

Definition at line 294 of file indexing.h.

Referenced by DefineTSTemplate().

◆ TypeNameNspIndexId

#define TypeNameNspIndexId   2704

Definition at line 299 of file indexing.h.

◆ TypeOidIndexId

#define TypeOidIndexId   2703

Definition at line 297 of file indexing.h.

Referenced by AssignTypeArrayOid(), TypeCreate(), and TypeShellMake().

◆ UserMappingOidIndexId

#define UserMappingOidIndexId   174

Definition at line 312 of file indexing.h.

Referenced by CreateUserMapping().

◆ UserMappingUserServerIndexId

#define UserMappingUserServerIndexId   175

Definition at line 314 of file indexing.h.

Typedef Documentation

◆ CatalogIndexState

Definition at line 30 of file indexing.h.

Function Documentation

◆ CatalogCloseIndexes()

void CatalogCloseIndexes ( CatalogIndexState  indstate)

Definition at line 61 of file indexing.c.

References ExecCloseIndices(), and pfree().

Referenced by AddNewAttributeTuples(), AppendAttributeTuples(), CatalogTupleInsert(), CatalogTupleUpdate(), copyTemplateDependencies(), InsertPgAttributeTuples(), inv_truncate(), inv_write(), recordMultipleDependencies(), and swap_relation_files().

62 {
63  ExecCloseIndices(indstate);
64  pfree(indstate);
65 }
void pfree(void *pointer)
Definition: mcxt.c:1057
void ExecCloseIndices(ResultRelInfo *resultRelInfo)
Definition: execIndexing.c:226

◆ CatalogOpenIndexes()

CatalogIndexState CatalogOpenIndexes ( Relation  heapRel)

Definition at line 43 of file indexing.c.

References ExecOpenIndices(), makeNode, ResultRelInfo::ri_RangeTableIndex, ResultRelInfo::ri_RelationDesc, and ResultRelInfo::ri_TrigDesc.

Referenced by AddNewAttributeTuples(), AppendAttributeTuples(), CatalogTupleInsert(), CatalogTupleUpdate(), copyTemplateDependencies(), InsertPgAttributeTuples(), inv_truncate(), inv_write(), recordMultipleDependencies(), and swap_relation_files().

44 {
45  ResultRelInfo *resultRelInfo;
46 
47  resultRelInfo = makeNode(ResultRelInfo);
48  resultRelInfo->ri_RangeTableIndex = 0; /* dummy */
49  resultRelInfo->ri_RelationDesc = heapRel;
50  resultRelInfo->ri_TrigDesc = NULL; /* we don't fire triggers */
51 
52  ExecOpenIndices(resultRelInfo, false);
53 
54  return resultRelInfo;
55 }
Relation ri_RelationDesc
Definition: execnodes.h:413
Index ri_RangeTableIndex
Definition: execnodes.h:410
void ExecOpenIndices(ResultRelInfo *resultRelInfo, bool speculative)
Definition: execIndexing.c:151
TriggerDesc * ri_TrigDesc
Definition: execnodes.h:425
#define makeNode(_type_)
Definition: nodes.h:576

◆ CatalogTupleDelete()

void CatalogTupleDelete ( Relation  heapRel,
ItemPointer  tid 
)

Definition at line 350 of file indexing.c.

References simple_heap_delete().

Referenced by AlterSetting(), ATExecAlterColumnType(), ATExecDropExpression(), changeDependenciesOn(), changeDependencyFor(), CreateComments(), CreateSharedComments(), DeleteAttributeTuples(), DeleteComments(), deleteDependencyRecordsFor(), deleteDependencyRecordsForClass(), deleteDependencyRecordsForSpecific(), DeleteInheritsTuple(), DeleteInitPrivs(), deleteOneObject(), DeleteRelationTuple(), DeleteSecurityLabel(), DeleteSequenceTuple(), DeleteSharedComments(), DeleteSharedSecurityLabel(), DeleteSystemAttributeTuples(), DelRoleMems(), drop_parent_dependency(), DropConfigurationMapping(), dropDatabaseDependencies(), dropdb(), DropObjectById(), DropRole(), DropSetting(), DropSubscription(), DropTableSpace(), EnumValuesDelete(), heap_drop_with_catalog(), index_drop(), IndexSetParentIndex(), inv_truncate(), LargeObjectDrop(), MakeConfigurationMapping(), RangeDelete(), recordExtensionInitPrivWorker(), RelationRemoveInheritance(), RemoveAttrDefaultById(), RemoveAttributeById(), RemoveConstraintById(), RemoveExtensionById(), RemoveFunctionById(), RemoveOperatorById(), RemovePartitionKeyByRelId(), RemovePolicyById(), RemovePublicationRelById(), RemoveRewriteRuleById(), RemoveStatistics(), RemoveStatisticsById(), RemoveSubscriptionRel(), RemoveTriggerById(), RemoveTSConfigurationById(), RemoveTypeById(), replorigin_drop(), SetSecurityLabel(), SetSharedSecurityLabel(), shdepChangeDep(), and shdepDropDependency().

351 {
352  simple_heap_delete(heapRel, tid);
353 }
void simple_heap_delete(Relation relation, ItemPointer tid)
Definition: heapam.c:2847

◆ CatalogTupleInsert()

void CatalogTupleInsert ( Relation  heapRel,
HeapTuple  tup 
)

Definition at line 221 of file indexing.c.

References CatalogCloseIndexes(), CatalogIndexInsert(), CatalogOpenIndexes(), CatalogTupleCheckConstraints, and simple_heap_insert().

Referenced by AddEnumLabel(), AddRoleMems(), AddSubscriptionRelState(), AggregateCreate(), AlterSetting(), CastCreate(), CollationCreate(), ConversionCreate(), CreateAccessMethod(), CreateComments(), CreateConstraintEntry(), createdb(), CreateForeignDataWrapper(), CreateForeignServer(), CreateForeignTable(), CreateOpFamily(), CreatePolicy(), CreateProceduralLanguage(), CreatePublication(), CreateRole(), CreateSharedComments(), CreateStatistics(), CreateSubscription(), CreateTableSpace(), CreateTransform(), CreateTrigger(), CreateUserMapping(), DefineOpClass(), DefineSequence(), DefineTSConfiguration(), DefineTSDictionary(), DefineTSParser(), DefineTSTemplate(), EnumValuesCreate(), IndexSetParentIndex(), insert_event_trigger_tuple(), InsertExtensionTuple(), InsertPgClassTuple(), InsertRule(), LargeObjectCreate(), MakeConfigurationMapping(), NamespaceCreate(), OperatorCreate(), OperatorShellMake(), ProcedureCreate(), publication_add_relation(), RangeCreate(), recordExtensionInitPrivWorker(), replorigin_create(), SetDefaultACL(), SetSecurityLabel(), SetSharedSecurityLabel(), shdepAddDependency(), shdepChangeDep(), StoreAttrDefault(), storeOperators(), StorePartitionKey(), storeProcedures(), StoreSingleInheritance(), TypeCreate(), TypeShellMake(), update_attstats(), and UpdateIndexRelation().

222 {
223  CatalogIndexState indstate;
224 
225  CatalogTupleCheckConstraints(heapRel, tup);
226 
227  indstate = CatalogOpenIndexes(heapRel);
228 
229  simple_heap_insert(heapRel, tup);
230 
231  CatalogIndexInsert(indstate, tup);
232  CatalogCloseIndexes(indstate);
233 }
static void CatalogIndexInsert(CatalogIndexState indstate, HeapTuple heapTuple)
Definition: indexing.c:75
void simple_heap_insert(Relation relation, HeapTuple tup)
Definition: heapam.c:2384
CatalogIndexState CatalogOpenIndexes(Relation heapRel)
Definition: indexing.c:43
void CatalogCloseIndexes(CatalogIndexState indstate)
Definition: indexing.c:61
#define CatalogTupleCheckConstraints(heapRel, tup)
Definition: indexing.c:204

◆ CatalogTupleInsertWithInfo()

void CatalogTupleInsertWithInfo ( Relation  heapRel,
HeapTuple  tup,
CatalogIndexState  indstate 
)

Definition at line 244 of file indexing.c.

References CatalogIndexInsert(), CatalogTupleCheckConstraints, and simple_heap_insert().

Referenced by inv_truncate(), and inv_write().

246 {
247  CatalogTupleCheckConstraints(heapRel, tup);
248 
249  simple_heap_insert(heapRel, tup);
250 
251  CatalogIndexInsert(indstate, tup);
252 }
static void CatalogIndexInsert(CatalogIndexState indstate, HeapTuple heapTuple)
Definition: indexing.c:75
void simple_heap_insert(Relation relation, HeapTuple tup)
Definition: heapam.c:2384
#define CatalogTupleCheckConstraints(heapRel, tup)
Definition: indexing.c:204

◆ CatalogTuplesMultiInsertWithInfo()

void CatalogTuplesMultiInsertWithInfo ( Relation  heapRel,
TupleTableSlot **  slot,
int  ntuples,
CatalogIndexState  indstate 
)

Definition at line 261 of file indexing.c.

References CatalogIndexInsert(), ExecFetchSlotHeapTuple(), GetCurrentCommandId(), heap_freetuple(), heap_multi_insert(), i, HeapTupleData::t_tableOid, and TupleTableSlot::tts_tableOid.

Referenced by copyTemplateDependencies(), InsertPgAttributeTuples(), and recordMultipleDependencies().

263 {
264  /* Nothing to do */
265  if (ntuples <= 0)
266  return;
267 
268  heap_multi_insert(heapRel, slot, ntuples,
269  GetCurrentCommandId(true), 0, NULL);
270 
271  /*
272  * There is no equivalent to heap_multi_insert for the catalog indexes, so
273  * we must loop over and insert individually.
274  */
275  for (int i = 0; i < ntuples; i++)
276  {
277  bool should_free;
278  HeapTuple tuple;
279 
280  tuple = ExecFetchSlotHeapTuple(slot[i], true, &should_free);
281  tuple->t_tableOid = slot[i]->tts_tableOid;
282  CatalogIndexInsert(indstate, tuple);
283 
284  if (should_free)
285  heap_freetuple(tuple);
286  }
287 }
Oid tts_tableOid
Definition: tuptable.h:131
static void CatalogIndexInsert(CatalogIndexState indstate, HeapTuple heapTuple)
Definition: indexing.c:75
void heap_freetuple(HeapTuple htup)
Definition: heaptuple.c:1338
Oid t_tableOid
Definition: htup.h:66
HeapTuple ExecFetchSlotHeapTuple(TupleTableSlot *slot, bool materialize, bool *shouldFree)
Definition: execTuples.c:1614
int i
void heap_multi_insert(Relation relation, TupleTableSlot **slots, int ntuples, CommandId cid, int options, BulkInsertState bistate)
Definition: heapam.c:2097
CommandId GetCurrentCommandId(bool used)
Definition: xact.c:761

◆ CatalogTupleUpdate()

void CatalogTupleUpdate ( Relation  heapRel,
ItemPointer  otid,
HeapTuple  tup 
)

Definition at line 301 of file indexing.c.

References CatalogCloseIndexes(), CatalogIndexInsert(), CatalogOpenIndexes(), CatalogTupleCheckConstraints, and simple_heap_update().

Referenced by AddRoleMems(), AggregateCreate(), AlterCollation(), AlterConstraintNamespaces(), AlterDatabase(), AlterDatabaseOwner(), AlterDomainDefault(), AlterDomainNotNull(), AlterDomainValidateConstraint(), AlterEventTrigger(), AlterEventTriggerOwner_internal(), AlterExtensionNamespace(), AlterForeignDataWrapper(), AlterForeignDataWrapperOwner_internal(), AlterForeignServer(), AlterForeignServerOwner_internal(), AlterFunction(), AlterObjectNamespace_internal(), AlterObjectOwner_internal(), AlterObjectRename_internal(), AlterOperator(), AlterPolicy(), AlterPublicationOptions(), AlterPublicationOwner_internal(), AlterRelationNamespaceInternal(), AlterRole(), AlterSchemaOwner_internal(), AlterSequence(), AlterSetting(), AlterStatistics(), AlterSubscription(), AlterSubscriptionOwner_internal(), AlterTableSpaceOptions(), AlterTSDictionary(), AlterTypeNamespaceInternal(), AlterTypeOwnerInternal(), AlterTypeRecurse(), AlterUserMapping(), ApplyExtensionUpdates(), ATExecAddColumn(), ATExecAddIdentity(), ATExecAddOf(), ATExecAlterColumnGenericOptions(), ATExecAlterColumnType(), ATExecAlterConstraint(), ATExecChangeOwner(), ATExecDetachPartition(), ATExecDisableRowSecurity(), ATExecDropColumn(), ATExecDropConstraint(), ATExecDropExpression(), ATExecDropIdentity(), ATExecDropNotNull(), ATExecDropOf(), ATExecEnableRowSecurity(), ATExecForceNoForceRowSecurity(), ATExecGenericOptions(), ATExecSetIdentity(), ATExecSetNotNull(), ATExecSetOptions(), ATExecSetRelOptions(), ATExecSetStatistics(), ATExecSetStorage(), ATExecSetTableSpace(), ATExecSetTableSpaceNoStorage(), ATExecValidateConstraint(), change_owner_fix_column_acls(), changeDependenciesOf(), changeDependenciesOn(), changeDependencyFor(), ConstraintSetParentConstraint(), copy_table_data(), create_toast_table(), CreateComments(), CreateProceduralLanguage(), CreateSharedComments(), CreateTransform(), CreateTrigger(), DefineIndex(), DefineQueryRewrite(), DelRoleMems(), EnableDisableRule(), EnableDisableTrigger(), ExecGrant_Attribute(), ExecGrant_Database(), ExecGrant_Fdw(), ExecGrant_ForeignServer(), ExecGrant_Function(), ExecGrant_Language(), ExecGrant_Largeobject(), ExecGrant_Namespace(), ExecGrant_Relation(), ExecGrant_Tablespace(), ExecGrant_Type(), extension_config_remove(), finish_heap_swap(), index_build(), index_concurrently_swap(), index_constraint_create(), index_set_state_flags(), InsertRule(), MakeConfigurationMapping(), mark_index_clustered(), MergeAttributesIntoExisting(), MergeConstraintsIntoExisting(), MergeWithExistingConstraint(), movedb(), OperatorCreate(), OperatorUpd(), pg_extension_config_dump(), ProcedureCreate(), recordExtensionInitPrivWorker(), reindex_index(), relation_mark_replica_identity(), RelationClearMissing(), RelationSetNewRelfilenode(), RemoveAttrDefaultById(), RemoveAttributeById(), RemoveConstraintById(), RemoveInheritance(), RemoveRoleFromObjectPolicy(), rename_policy(), renameatt_internal(), RenameConstraintById(), RenameDatabase(), RenameEnumLabel(), RenameRelationInternal(), RenameRewriteRule(), RenameRole(), RenameSchema(), RenameTableSpace(), renametrig(), RenameTypeInternal(), RenumberEnumType(), SetAttrMissing(), SetDefaultACL(), SetMatViewPopulatedState(), SetRelationHasSubclass(), SetRelationNumChecks(), SetRelationRuleStatus(), SetSecurityLabel(), SetSharedSecurityLabel(), shdepChangeDep(), statext_store(), StoreAttrDefault(), StorePartitionBound(), TypeCreate(), update_attstats(), update_default_partition_oid(), update_relispartition(), UpdateStatisticsForTypeChange(), UpdateSubscriptionRelState(), and validatePartitionedIndex().

302 {
303  CatalogIndexState indstate;
304 
305  CatalogTupleCheckConstraints(heapRel, tup);
306 
307  indstate = CatalogOpenIndexes(heapRel);
308 
309  simple_heap_update(heapRel, otid, tup);
310 
311  CatalogIndexInsert(indstate, tup);
312  CatalogCloseIndexes(indstate);
313 }
static void CatalogIndexInsert(CatalogIndexState indstate, HeapTuple heapTuple)
Definition: indexing.c:75
CatalogIndexState CatalogOpenIndexes(Relation heapRel)
Definition: indexing.c:43
void simple_heap_update(Relation relation, ItemPointer otid, HeapTuple tup)
Definition: heapam.c:3885
void CatalogCloseIndexes(CatalogIndexState indstate)
Definition: indexing.c:61
#define CatalogTupleCheckConstraints(heapRel, tup)
Definition: indexing.c:204

◆ CatalogTupleUpdateWithInfo()

void CatalogTupleUpdateWithInfo ( Relation  heapRel,
ItemPointer  otid,
HeapTuple  tup,
CatalogIndexState  indstate 
)

Definition at line 324 of file indexing.c.

References CatalogIndexInsert(), CatalogTupleCheckConstraints, and simple_heap_update().

Referenced by inv_truncate(), inv_write(), and swap_relation_files().

326 {
327  CatalogTupleCheckConstraints(heapRel, tup);
328 
329  simple_heap_update(heapRel, otid, tup);
330 
331  CatalogIndexInsert(indstate, tup);
332 }
static void CatalogIndexInsert(CatalogIndexState indstate, HeapTuple heapTuple)
Definition: indexing.c:75
void simple_heap_update(Relation relation, ItemPointer otid, HeapTuple tup)
Definition: heapam.c:3885
#define CatalogTupleCheckConstraints(heapRel, tup)
Definition: indexing.c:204

◆ DECLARE_INDEX() [1/12]

DECLARE_INDEX ( pg_class_tblspc_relfilenode_index  ,
3455  ,
on pg_class using   btreereltablespace oid_ops, relfilenode oid_ops 
)

◆ DECLARE_INDEX() [2/12]

DECLARE_INDEX ( pg_constraint_conname_nsp_index  ,
2664  ,
on pg_constraint using   btreeconname name_ops, connamespace oid_ops 
)

◆ DECLARE_INDEX() [3/12]

DECLARE_INDEX ( pg_constraint_contypid_index  ,
2666  ,
on pg_constraint using   btreecontypid oid_ops 
)

◆ DECLARE_INDEX() [4/12]

DECLARE_INDEX ( pg_constraint_conparentid_index  ,
2579  ,
on pg_constraint using   btreeconparentid oid_ops 
)

◆ DECLARE_INDEX() [5/12]

DECLARE_INDEX ( pg_depend_depender_index  ,
2673  ,
on pg_depend using   btreeclassid oid_ops, objid oid_ops, objsubid int4_ops 
)

◆ DECLARE_INDEX() [6/12]

DECLARE_INDEX ( pg_depend_reference_index  ,
2674  ,
on pg_depend using   btreerefclassid oid_ops, refobjid oid_ops, refobjsubid int4_ops 
)

◆ DECLARE_INDEX() [7/12]

DECLARE_INDEX ( pg_index_indrelid_index  ,
2678  ,
on pg_index using   btreeindrelid oid_ops 
)

◆ DECLARE_INDEX() [8/12]

DECLARE_INDEX ( pg_inherits_parent_index  ,
2187  ,
on pg_inherits using   btreeinhparent oid_ops 
)

◆ DECLARE_INDEX() [9/12]

DECLARE_INDEX ( pg_shdepend_depender_index  ,
1232  ,
on pg_shdepend using   btreedbid oid_ops, classid oid_ops, objid oid_ops, objsubid int4_ops 
)

◆ DECLARE_INDEX() [10/12]

DECLARE_INDEX ( pg_shdepend_reference_index  ,
1233  ,
on pg_shdepend using   btreerefclassid oid_ops, refobjid oid_ops 
)

◆ DECLARE_INDEX() [11/12]

DECLARE_INDEX ( pg_statistic_ext_relid_index  ,
3379  ,
on pg_statistic_ext using   btreestxrelid oid_ops 
)

◆ DECLARE_INDEX() [12/12]

DECLARE_INDEX ( pg_trigger_tgconstraint_index  ,
2699  ,
on pg_trigger using   btreetgconstraint oid_ops 
)

◆ DECLARE_UNIQUE_INDEX() [1/104]

DECLARE_UNIQUE_INDEX ( pg_aggregate_fnoid_index  ,
2650  ,
on pg_aggregate using   btreeaggfnoid oid_ops 
)

◆ DECLARE_UNIQUE_INDEX() [2/104]

DECLARE_UNIQUE_INDEX ( pg_am_name_index  ,
2651  ,
on pg_am using   btreeamname name_ops 
)

◆ DECLARE_UNIQUE_INDEX() [3/104]

DECLARE_UNIQUE_INDEX ( pg_am_oid_index  ,
2652  ,
on pg_am using   btreeoid oid_ops 
)

◆ DECLARE_UNIQUE_INDEX() [4/104]

DECLARE_UNIQUE_INDEX ( pg_amop_fam_strat_index  ,
2653  ,
on pg_amop using   btreeamopfamily oid_ops, amoplefttype oid_ops, amoprighttype oid_ops, amopstrategy int2_ops 
)

◆ DECLARE_UNIQUE_INDEX() [5/104]

DECLARE_UNIQUE_INDEX ( pg_amop_opr_fam_index  ,
2654  ,
on pg_amop using   btreeamopopr oid_ops, amoppurpose char_ops, amopfamily oid_ops 
)

◆ DECLARE_UNIQUE_INDEX() [6/104]

DECLARE_UNIQUE_INDEX ( pg_amop_oid_index  ,
2756  ,
on pg_amop using   btreeoid oid_ops 
)

◆ DECLARE_UNIQUE_INDEX() [7/104]

DECLARE_UNIQUE_INDEX ( pg_amproc_fam_proc_index  ,
2655  ,
on pg_amproc using   btreeamprocfamily oid_ops, amproclefttype oid_ops, amprocrighttype oid_ops, amprocnum int2_ops 
)

◆ DECLARE_UNIQUE_INDEX() [8/104]

DECLARE_UNIQUE_INDEX ( pg_amproc_oid_index  ,
2757  ,
on pg_amproc using   btreeoid oid_ops 
)

◆ DECLARE_UNIQUE_INDEX() [9/104]

DECLARE_UNIQUE_INDEX ( pg_attrdef_adrelid_adnum_index  ,
2656  ,
on pg_attrdef using   btreeadrelid oid_ops, adnum int2_ops 
)

◆ DECLARE_UNIQUE_INDEX() [10/104]

DECLARE_UNIQUE_INDEX ( pg_attrdef_oid_index  ,
2657  ,
on pg_attrdef using   btreeoid oid_ops 
)

◆ DECLARE_UNIQUE_INDEX() [11/104]

DECLARE_UNIQUE_INDEX ( pg_attribute_relid_attnam_index  ,
2658  ,
on pg_attribute using   btreeattrelid oid_ops, attname name_ops 
)

◆ DECLARE_UNIQUE_INDEX() [12/104]

DECLARE_UNIQUE_INDEX ( pg_attribute_relid_attnum_index  ,
2659  ,
on pg_attribute using   btreeattrelid oid_ops, attnum int2_ops 
)

◆ DECLARE_UNIQUE_INDEX() [13/104]

DECLARE_UNIQUE_INDEX ( pg_authid_rolname_index  ,
2676  ,
on pg_authid using   btreerolname name_ops 
)

◆ DECLARE_UNIQUE_INDEX() [14/104]

DECLARE_UNIQUE_INDEX ( pg_authid_oid_index  ,
2677  ,
on pg_authid using   btreeoid oid_ops 
)

◆ DECLARE_UNIQUE_INDEX() [15/104]

DECLARE_UNIQUE_INDEX ( pg_auth_members_role_member_index  ,
2694  ,
on pg_auth_members using   btreeroleid oid_ops, member oid_ops 
)

◆ DECLARE_UNIQUE_INDEX() [16/104]

DECLARE_UNIQUE_INDEX ( pg_auth_members_member_role_index  ,
2695  ,
on pg_auth_members using   btreemember oid_ops, roleid oid_ops 
)

◆ DECLARE_UNIQUE_INDEX() [17/104]

DECLARE_UNIQUE_INDEX ( pg_cast_oid_index  ,
2660  ,
on pg_cast using   btreeoid oid_ops 
)

◆ DECLARE_UNIQUE_INDEX() [18/104]

DECLARE_UNIQUE_INDEX ( pg_cast_source_target_index  ,
2661  ,
on pg_cast using   btreecastsource oid_ops, casttarget oid_ops 
)

◆ DECLARE_UNIQUE_INDEX() [19/104]

DECLARE_UNIQUE_INDEX ( pg_class_oid_index  ,
2662  ,
on pg_class using   btreeoid oid_ops 
)

◆ DECLARE_UNIQUE_INDEX() [20/104]

DECLARE_UNIQUE_INDEX ( pg_class_relname_nsp_index  ,
2663  ,
on pg_class using   btreerelname name_ops, relnamespace oid_ops 
)

◆ DECLARE_UNIQUE_INDEX() [21/104]

DECLARE_UNIQUE_INDEX ( pg_collation_name_enc_nsp_index  ,
3164  ,
on pg_collation using   btreecollname name_ops, collencoding int4_ops, collnamespace oid_ops 
)

◆ DECLARE_UNIQUE_INDEX() [22/104]

DECLARE_UNIQUE_INDEX ( pg_collation_oid_index  ,
3085  ,
on pg_collation using   btreeoid oid_ops 
)

◆ DECLARE_UNIQUE_INDEX() [23/104]

DECLARE_UNIQUE_INDEX ( pg_constraint_conrelid_contypid_conname_index  ,
2665  ,
on pg_constraint using   btreeconrelid oid_ops, contypid oid_ops, conname name_ops 
)

◆ DECLARE_UNIQUE_INDEX() [24/104]

DECLARE_UNIQUE_INDEX ( pg_constraint_oid_index  ,
2667  ,
on pg_constraint using   btreeoid oid_ops 
)

◆ DECLARE_UNIQUE_INDEX() [25/104]

DECLARE_UNIQUE_INDEX ( pg_conversion_default_index  ,
2668  ,
on pg_conversion using   btreeconnamespace oid_ops, conforencoding int4_ops, contoencoding int4_ops, oid oid_ops 
)

◆ DECLARE_UNIQUE_INDEX() [26/104]

DECLARE_UNIQUE_INDEX ( pg_conversion_name_nsp_index  ,
2669  ,
on pg_conversion using   btreeconname name_ops, connamespace oid_ops 
)

◆ DECLARE_UNIQUE_INDEX() [27/104]

DECLARE_UNIQUE_INDEX ( pg_conversion_oid_index  ,
2670  ,
on pg_conversion using   btreeoid oid_ops 
)

◆ DECLARE_UNIQUE_INDEX() [28/104]

DECLARE_UNIQUE_INDEX ( pg_database_datname_index  ,
2671  ,
on pg_database using   btreedatname name_ops 
)

◆ DECLARE_UNIQUE_INDEX() [29/104]

DECLARE_UNIQUE_INDEX ( pg_database_oid_index  ,
2672  ,
on pg_database using   btreeoid oid_ops 
)

◆ DECLARE_UNIQUE_INDEX() [30/104]

DECLARE_UNIQUE_INDEX ( pg_description_o_c_o_index  ,
2675  ,
on pg_description using   btreeobjoid oid_ops, classoid oid_ops, objsubid int4_ops 
)

◆ DECLARE_UNIQUE_INDEX() [31/104]

DECLARE_UNIQUE_INDEX ( pg_shdescription_o_c_index  ,
2397  ,
on pg_shdescription using   btreeobjoid oid_ops, classoid oid_ops 
)

◆ DECLARE_UNIQUE_INDEX() [32/104]

DECLARE_UNIQUE_INDEX ( pg_enum_oid_index  ,
3502  ,
on pg_enum using   btreeoid oid_ops 
)

◆ DECLARE_UNIQUE_INDEX() [33/104]

DECLARE_UNIQUE_INDEX ( pg_enum_typid_label_index  ,
3503  ,
on pg_enum using   btreeenumtypid oid_ops, enumlabel name_ops 
)

◆ DECLARE_UNIQUE_INDEX() [34/104]

DECLARE_UNIQUE_INDEX ( pg_enum_typid_sortorder_index  ,
3534  ,
on pg_enum using   btreeenumtypid oid_ops, enumsortorder float4_ops 
)

◆ DECLARE_UNIQUE_INDEX() [35/104]

DECLARE_UNIQUE_INDEX ( pg_index_indexrelid_index  ,
2679  ,
on pg_index using   btreeindexrelid oid_ops 
)

◆ DECLARE_UNIQUE_INDEX() [36/104]

DECLARE_UNIQUE_INDEX ( pg_inherits_relid_seqno_index  ,
2680  ,
on pg_inherits using   btreeinhrelid oid_ops, inhseqno int4_ops 
)

◆ DECLARE_UNIQUE_INDEX() [37/104]

DECLARE_UNIQUE_INDEX ( pg_init_privs_o_c_o_index  ,
3395  ,
on pg_init_privs using   btreeobjoid oid_ops, classoid oid_ops, objsubid int4_ops 
)

◆ DECLARE_UNIQUE_INDEX() [38/104]

DECLARE_UNIQUE_INDEX ( pg_language_name_index  ,
2681  ,
on pg_language using   btreelanname name_ops 
)

◆ DECLARE_UNIQUE_INDEX() [39/104]

DECLARE_UNIQUE_INDEX ( pg_language_oid_index  ,
2682  ,
on pg_language using   btreeoid oid_ops 
)

◆ DECLARE_UNIQUE_INDEX() [40/104]

DECLARE_UNIQUE_INDEX ( pg_largeobject_loid_pn_index  ,
2683  ,
on pg_largeobject using   btreeloid oid_ops, pageno int4_ops 
)

◆ DECLARE_UNIQUE_INDEX() [41/104]

DECLARE_UNIQUE_INDEX ( pg_largeobject_metadata_oid_index  ,
2996  ,
on pg_largeobject_metadata using   btreeoid oid_ops 
)

◆ DECLARE_UNIQUE_INDEX() [42/104]

DECLARE_UNIQUE_INDEX ( pg_namespace_nspname_index  ,
2684  ,
on pg_namespace using   btreenspname name_ops 
)

◆ DECLARE_UNIQUE_INDEX() [43/104]

DECLARE_UNIQUE_INDEX ( pg_namespace_oid_index  ,
2685  ,
on pg_namespace using   btreeoid oid_ops 
)

◆ DECLARE_UNIQUE_INDEX() [44/104]

DECLARE_UNIQUE_INDEX ( pg_opclass_am_name_nsp_index  ,
2686  ,
on pg_opclass using   btreeopcmethod oid_ops, opcname name_ops, opcnamespace oid_ops 
)

◆ DECLARE_UNIQUE_INDEX() [45/104]

DECLARE_UNIQUE_INDEX ( pg_opclass_oid_index  ,
2687  ,
on pg_opclass using   btreeoid oid_ops 
)

◆ DECLARE_UNIQUE_INDEX() [46/104]

DECLARE_UNIQUE_INDEX ( pg_operator_oid_index  ,
2688  ,
on pg_operator using   btreeoid oid_ops 
)

◆ DECLARE_UNIQUE_INDEX() [47/104]

DECLARE_UNIQUE_INDEX ( pg_operator_oprname_l_r_n_index  ,
2689  ,
on pg_operator using   btreeoprname name_ops, oprleft oid_ops, oprright oid_ops, oprnamespace oid_ops 
)

◆ DECLARE_UNIQUE_INDEX() [48/104]

DECLARE_UNIQUE_INDEX ( pg_opfamily_am_name_nsp_index  ,
2754  ,
on pg_opfamily using   btreeopfmethod oid_ops, opfname name_ops, opfnamespace oid_ops 
)

◆ DECLARE_UNIQUE_INDEX() [49/104]

DECLARE_UNIQUE_INDEX ( pg_opfamily_oid_index  ,
2755  ,
on pg_opfamily using   btreeoid oid_ops 
)

◆ DECLARE_UNIQUE_INDEX() [50/104]

DECLARE_UNIQUE_INDEX ( pg_proc_oid_index  ,
2690  ,
on pg_proc using   btreeoid oid_ops 
)

◆ DECLARE_UNIQUE_INDEX() [51/104]

DECLARE_UNIQUE_INDEX ( pg_proc_proname_args_nsp_index  ,
2691  ,
on pg_proc using   btreeproname name_ops, proargtypes oidvector_ops, pronamespace oid_ops 
)

◆ DECLARE_UNIQUE_INDEX() [52/104]

DECLARE_UNIQUE_INDEX ( pg_rewrite_oid_index  ,
2692  ,
on pg_rewrite using   btreeoid oid_ops 
)

◆ DECLARE_UNIQUE_INDEX() [53/104]

DECLARE_UNIQUE_INDEX ( pg_rewrite_rel_rulename_index  ,
2693  ,
on pg_rewrite using   btreeev_class oid_ops, rulename name_ops 
)

◆ DECLARE_UNIQUE_INDEX() [54/104]

DECLARE_UNIQUE_INDEX ( pg_sequence_seqrelid_index  ,
5002  ,
on pg_sequence using   btreeseqrelid oid_ops 
)

◆ DECLARE_UNIQUE_INDEX() [55/104]

DECLARE_UNIQUE_INDEX ( pg_statistic_relid_att_inh_index  ,
2696  ,
on pg_statistic using   btreestarelid oid_ops, staattnum int2_ops, stainherit bool_ops 
)

◆ DECLARE_UNIQUE_INDEX() [56/104]

DECLARE_UNIQUE_INDEX ( pg_statistic_ext_oid_index  ,
3380  ,
on pg_statistic_ext using   btreeoid oid_ops 
)

◆ DECLARE_UNIQUE_INDEX() [57/104]

DECLARE_UNIQUE_INDEX ( pg_statistic_ext_name_index  ,
3997  ,
on pg_statistic_ext using   btreestxname name_ops, stxnamespace oid_ops 
)

◆ DECLARE_UNIQUE_INDEX() [58/104]

DECLARE_UNIQUE_INDEX ( pg_statistic_ext_data_stxoid_index  ,
3433  ,
on pg_statistic_ext_data using   btreestxoid oid_ops 
)

◆ DECLARE_UNIQUE_INDEX() [59/104]

DECLARE_UNIQUE_INDEX ( pg_tablespace_oid_index  ,
2697  ,
on pg_tablespace using   btreeoid oid_ops 
)

◆ DECLARE_UNIQUE_INDEX() [60/104]

DECLARE_UNIQUE_INDEX ( pg_tablespace_spcname_index  ,
2698  ,
on pg_tablespace using   btreespcname name_ops 
)

◆ DECLARE_UNIQUE_INDEX() [61/104]

DECLARE_UNIQUE_INDEX ( pg_transform_oid_index  ,
3574  ,
on pg_transform using   btreeoid oid_ops 
)

◆ DECLARE_UNIQUE_INDEX() [62/104]

DECLARE_UNIQUE_INDEX ( pg_transform_type_lang_index  ,
3575  ,
on pg_transform using   btreetrftype oid_ops, trflang oid_ops 
)

◆ DECLARE_UNIQUE_INDEX() [63/104]

DECLARE_UNIQUE_INDEX ( pg_trigger_tgrelid_tgname_index  ,
2701  ,
on pg_trigger using   btreetgrelid oid_ops, tgname name_ops 
)

◆ DECLARE_UNIQUE_INDEX() [64/104]

DECLARE_UNIQUE_INDEX ( pg_trigger_oid_index  ,
2702  ,
on pg_trigger using   btreeoid oid_ops 
)

◆ DECLARE_UNIQUE_INDEX() [65/104]

DECLARE_UNIQUE_INDEX ( pg_event_trigger_evtname_index  ,
3467  ,
on pg_event_trigger using   btreeevtname name_ops 
)

◆ DECLARE_UNIQUE_INDEX() [66/104]

DECLARE_UNIQUE_INDEX ( pg_event_trigger_oid_index  ,
3468  ,
on pg_event_trigger using   btreeoid oid_ops 
)

◆ DECLARE_UNIQUE_INDEX() [67/104]

DECLARE_UNIQUE_INDEX ( pg_ts_config_cfgname_index  ,
3608  ,
on pg_ts_config using   btreecfgname name_ops, cfgnamespace oid_ops 
)

◆ DECLARE_UNIQUE_INDEX() [68/104]

DECLARE_UNIQUE_INDEX ( pg_ts_config_oid_index  ,
3712  ,
on pg_ts_config using   btreeoid oid_ops 
)

◆ DECLARE_UNIQUE_INDEX() [69/104]

DECLARE_UNIQUE_INDEX ( pg_ts_config_map_index  ,
3609  ,
on pg_ts_config_map using   btreemapcfg oid_ops, maptokentype int4_ops, mapseqno int4_ops 
)

◆ DECLARE_UNIQUE_INDEX() [70/104]

DECLARE_UNIQUE_INDEX ( pg_ts_dict_dictname_index  ,
3604  ,
on pg_ts_dict using   btreedictname name_ops, dictnamespace oid_ops 
)

◆ DECLARE_UNIQUE_INDEX() [71/104]

DECLARE_UNIQUE_INDEX ( pg_ts_dict_oid_index  ,
3605  ,
on pg_ts_dict using   btreeoid oid_ops 
)

◆ DECLARE_UNIQUE_INDEX() [72/104]

DECLARE_UNIQUE_INDEX ( pg_ts_parser_prsname_index  ,
3606  ,
on pg_ts_parser using   btreeprsname name_ops, prsnamespace oid_ops 
)

◆ DECLARE_UNIQUE_INDEX() [73/104]

DECLARE_UNIQUE_INDEX ( pg_ts_parser_oid_index  ,
3607  ,
on pg_ts_parser using   btreeoid oid_ops 
)

◆ DECLARE_UNIQUE_INDEX() [74/104]

DECLARE_UNIQUE_INDEX ( pg_ts_template_tmplname_index  ,
3766  ,
on pg_ts_template using   btreetmplname name_ops, tmplnamespace oid_ops 
)

◆ DECLARE_UNIQUE_INDEX() [75/104]

DECLARE_UNIQUE_INDEX ( pg_ts_template_oid_index  ,
3767  ,
on pg_ts_template using   btreeoid oid_ops 
)

◆ DECLARE_UNIQUE_INDEX() [76/104]

DECLARE_UNIQUE_INDEX ( pg_type_oid_index  ,
2703  ,
on pg_type using   btreeoid oid_ops 
)

◆ DECLARE_UNIQUE_INDEX() [77/104]

DECLARE_UNIQUE_INDEX ( pg_type_typname_nsp_index  ,
2704  ,
on pg_type using   btreetypname name_ops, typnamespace oid_ops 
)

◆ DECLARE_UNIQUE_INDEX() [78/104]

DECLARE_UNIQUE_INDEX ( pg_foreign_data_wrapper_oid_index  ,
112  ,
on pg_foreign_data_wrapper using   btreeoid oid_ops 
)

◆ DECLARE_UNIQUE_INDEX() [79/104]

DECLARE_UNIQUE_INDEX ( pg_foreign_data_wrapper_name_index  ,
548  ,
on pg_foreign_data_wrapper using   btreefdwname name_ops 
)

◆ DECLARE_UNIQUE_INDEX() [80/104]

DECLARE_UNIQUE_INDEX ( pg_foreign_server_oid_index  ,
113  ,
on pg_foreign_server using   btreeoid oid_ops 
)

◆ DECLARE_UNIQUE_INDEX() [81/104]

DECLARE_UNIQUE_INDEX ( pg_foreign_server_name_index  ,
549  ,
on pg_foreign_server using   btreesrvname name_ops 
)

◆ DECLARE_UNIQUE_INDEX() [82/104]

DECLARE_UNIQUE_INDEX ( pg_user_mapping_oid_index  ,
174  ,
on pg_user_mapping using   btreeoid oid_ops 
)

◆ DECLARE_UNIQUE_INDEX() [83/104]

DECLARE_UNIQUE_INDEX ( pg_user_mapping_user_server_index  ,
175  ,
on pg_user_mapping using   btreeumuser oid_ops, umserver oid_ops 
)

◆ DECLARE_UNIQUE_INDEX() [84/104]

DECLARE_UNIQUE_INDEX ( pg_foreign_table_relid_index  ,
3119  ,
on pg_foreign_table using   btreeftrelid oid_ops 
)

◆ DECLARE_UNIQUE_INDEX() [85/104]

DECLARE_UNIQUE_INDEX ( pg_default_acl_role_nsp_obj_index  ,
827  ,
on pg_default_acl using   btreedefaclrole oid_ops, defaclnamespace oid_ops, defaclobjtype char_ops 
)

◆ DECLARE_UNIQUE_INDEX() [86/104]

DECLARE_UNIQUE_INDEX ( pg_default_acl_oid_index  ,
828  ,
on pg_default_acl using   btreeoid oid_ops 
)

◆ DECLARE_UNIQUE_INDEX() [87/104]

DECLARE_UNIQUE_INDEX ( pg_db_role_setting_databaseid_rol_index  ,
2965  ,
on pg_db_role_setting using   btreesetdatabase oid_ops, setrole oid_ops 
)

◆ DECLARE_UNIQUE_INDEX() [88/104]

DECLARE_UNIQUE_INDEX ( pg_seclabel_object_index  ,
3597  ,
on pg_seclabel using   btreeobjoid oid_ops, classoid oid_ops, objsubid int4_ops, provider text_ops 
)

◆ DECLARE_UNIQUE_INDEX() [89/104]

DECLARE_UNIQUE_INDEX ( pg_shseclabel_object_index  ,
3593  ,
on pg_shseclabel using   btreeobjoid oid_ops, classoid oid_ops, provider text_ops 
)

◆ DECLARE_UNIQUE_INDEX() [90/104]

DECLARE_UNIQUE_INDEX ( pg_extension_oid_index  ,
3080  ,
on pg_extension using   btreeoid oid_ops 
)

◆ DECLARE_UNIQUE_INDEX() [91/104]

DECLARE_UNIQUE_INDEX ( pg_extension_name_index  ,
3081  ,
on pg_extension using   btreeextname name_ops 
)

◆ DECLARE_UNIQUE_INDEX() [92/104]

DECLARE_UNIQUE_INDEX ( pg_range_rngtypid_index  ,
3542  ,
on pg_range using   btreerngtypid oid_ops 
)

◆ DECLARE_UNIQUE_INDEX() [93/104]

DECLARE_UNIQUE_INDEX ( pg_policy_oid_index  ,
3257  ,
on pg_policy using   btreeoid oid_ops 
)

◆ DECLARE_UNIQUE_INDEX() [94/104]

DECLARE_UNIQUE_INDEX ( pg_policy_polrelid_polname_index  ,
3258  ,
on pg_policy using   btreepolrelid oid_ops, polname name_ops 
)

◆ DECLARE_UNIQUE_INDEX() [95/104]

DECLARE_UNIQUE_INDEX ( pg_replication_origin_roiident_index  ,
6001  ,
on pg_replication_origin using   btreeroident oid_ops 
)

◆ DECLARE_UNIQUE_INDEX() [96/104]

DECLARE_UNIQUE_INDEX ( pg_replication_origin_roname_index  ,
6002  ,
on pg_replication_origin using   btreeroname text_ops 
)

◆ DECLARE_UNIQUE_INDEX() [97/104]

DECLARE_UNIQUE_INDEX ( pg_partitioned_table_partrelid_index  ,
3351  ,
on pg_partitioned_table using   btreepartrelid oid_ops 
)

◆ DECLARE_UNIQUE_INDEX() [98/104]

DECLARE_UNIQUE_INDEX ( pg_publication_oid_index  ,
6110  ,
on pg_publication using   btreeoid oid_ops 
)

◆ DECLARE_UNIQUE_INDEX() [99/104]

DECLARE_UNIQUE_INDEX ( pg_publication_pubname_index  ,
6111  ,
on pg_publication using   btreepubname name_ops 
)

◆ DECLARE_UNIQUE_INDEX() [100/104]

DECLARE_UNIQUE_INDEX ( pg_publication_rel_oid_index  ,
6112  ,
on pg_publication_rel using   btreeoid oid_ops 
)

◆ DECLARE_UNIQUE_INDEX() [101/104]

DECLARE_UNIQUE_INDEX ( pg_publication_rel_prrelid_prpubid_index  ,
6113  ,
on pg_publication_rel using   btreeprrelid oid_ops, prpubid oid_ops 
)

◆ DECLARE_UNIQUE_INDEX() [102/104]

DECLARE_UNIQUE_INDEX ( pg_subscription_oid_index  ,
6114  ,
on pg_subscription using   btreeoid oid_ops 
)

◆ DECLARE_UNIQUE_INDEX() [103/104]

DECLARE_UNIQUE_INDEX ( pg_subscription_subname_index  ,
6115  ,
on pg_subscription using   btreesubdbid oid_ops, subname name_ops 
)

◆ DECLARE_UNIQUE_INDEX() [104/104]

DECLARE_UNIQUE_INDEX ( pg_subscription_rel_srrelid_srsubid_index  ,
6117  ,
on pg_subscription_rel using   btreesrrelid oid_ops, srsubid oid_ops 
)