Header And Logo

PostgreSQL
| The world's most advanced open source database.

Defines | Typedefs | Functions

indexing.h File Reference

#include "access/htup.h"
#include "utils/relcache.h"
Include dependency graph for indexing.h:

Go to the source code of this file.

Defines

#define DECLARE_INDEX(name, oid, decl)   extern int no_such_variable
#define DECLARE_UNIQUE_INDEX(name, oid, decl)   extern int no_such_variable
#define BUILD_INDICES
#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 CollationNameEncNspIndexId   3164
#define CollationOidIndexId   3085
#define ConstraintNameNspIndexId   2664
#define ConstraintRelidIndexId   2665
#define ConstraintTypidIndexId   2666
#define ConstraintOidIndexId   2667
#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 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 PLTemplateNameIndexId   1137
#define ProcedureOidIndexId   2690
#define ProcedureNameArgsNspIndexId   2691
#define RewriteOidIndexId   2692
#define RewriteRelRulenameIndexId   2693
#define SharedDependDependerIndexId   1232
#define SharedDependReferenceIndexId   1233
#define StatisticRelidAttnumInhIndexId   2696
#define TablespaceOidIndexId   2697
#define TablespaceNameIndexId   2698
#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

Typedefs

typedef struct ResultRelInfoCatalogIndexState

Functions

CatalogIndexState CatalogOpenIndexes (Relation heapRel)
void CatalogCloseIndexes (CatalogIndexState indstate)
void CatalogIndexInsert (CatalogIndexState indstate, HeapTuple heapTuple)
void CatalogUpdateIndexes (Relation heapRel, HeapTuple heapTuple)
 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_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_INDEX (pg_constraint_conrelid_index, 2665, on pg_constraint using btree(conrelid oid_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_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_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_pltemplate_name_index, 1137, on pg_pltemplate using btree(tmplname name_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_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_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_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))

Define Documentation

#define AccessMethodOperatorIndexId   2654

Definition at line 71 of file indexing.h.

#define AccessMethodOperatorOidIndexId   2756

Definition at line 73 of file indexing.h.

Referenced by getObjectDescription(), getObjectIdentity(), and RemoveAmOpEntryById().

#define AccessMethodProcedureIndexId   2655

Definition at line 76 of file indexing.h.

Referenced by LookupOpclassInfo(), and RelationCacheInitializePhase3().

#define AccessMethodProcedureOidIndexId   2757

Definition at line 78 of file indexing.h.

Referenced by getObjectDescription(), getObjectIdentity(), and RemoveAmProcEntryById().

#define AccessMethodStrategyIndexId   2653

Definition at line 69 of file indexing.h.

#define AggregateFnoidIndexId   2650

Definition at line 61 of file indexing.h.

#define AmNameIndexId   2651

Definition at line 64 of file indexing.h.

#define AmOidIndexId   2652

Definition at line 66 of file indexing.h.

#define AttrDefaultIndexId   2656

Definition at line 81 of file indexing.h.

Referenced by AttrDefaultFetch(), and RemoveAttrDefault().

#define AttrDefaultOidIndexId   2657

Definition at line 83 of file indexing.h.

Referenced by getObjectDescription(), getObjectIdentity(), and RemoveAttrDefaultById().

#define AttributeRelidNameIndexId   2658

Definition at line 86 of file indexing.h.

#define AttributeRelidNumIndexId   2659
#define AuthIdOidIndexId   2677

Definition at line 93 of file indexing.h.

Referenced by IsSharedRelation(), and RelationCacheInitializePhase3().

#define AuthIdRolnameIndexId   2676

Definition at line 91 of file indexing.h.

Referenced by IsSharedRelation(), and RelationCacheInitializePhase3().

#define AuthMemMemRoleIndexId   2695

Definition at line 98 of file indexing.h.

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

#define AuthMemRoleMemIndexId   2694

Definition at line 96 of file indexing.h.

Referenced by DropRole(), and IsSharedRelation().

#define BUILD_INDICES

Definition at line 44 of file indexing.h.

#define CastOidIndexId   2660

Definition at line 101 of file indexing.h.

Referenced by DropCastById(), and getObjectDescription().

#define CastSourceTargetIndexId   2661

Definition at line 103 of file indexing.h.

#define ClassNameNspIndexId   2663

Definition at line 108 of file indexing.h.

Referenced by regclassin().

#define ClassOidIndexId   2662
#define CollationNameEncNspIndexId   3164

Definition at line 111 of file indexing.h.

#define CollationOidIndexId   3085

Definition at line 113 of file indexing.h.

Referenced by RemoveCollationById().

#define ConstraintNameNspIndexId   2664
#define ConstraintOidIndexId   2667

Definition at line 125 of file indexing.h.

#define ConstraintRelidIndexId   2665
#define ConstraintTypidIndexId   2666
#define ConversionDefaultIndexId   2668

Definition at line 128 of file indexing.h.

#define ConversionNameNspIndexId   2669

Definition at line 130 of file indexing.h.

#define ConversionOidIndexId   2670

Definition at line 132 of file indexing.h.

#define DatabaseNameIndexId   2671
#define DatabaseOidIndexId   2672
#define DbRoleSettingDatidRolidIndexId   2965

Definition at line 297 of file indexing.h.

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

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

Definition at line 42 of file indexing.h.

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

Definition at line 43 of file indexing.h.

#define DefaultAclOidIndexId   828
#define DefaultAclRoleNspObjIndexId   827

Definition at line 292 of file indexing.h.

#define DependDependerIndexId   2673
#define DependReferenceIndexId   2674
#define DescriptionObjIndexId   2675

Definition at line 147 of file indexing.h.

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

#define EnumOidIndexId   3502

Definition at line 152 of file indexing.h.

#define EnumTypIdLabelIndexId   3503

Definition at line 154 of file indexing.h.

Referenced by EnumValuesDelete(), and load_enum_cache_data().

#define EnumTypIdSortOrderIndexId   3534

Definition at line 156 of file indexing.h.

Referenced by enum_endpoint(), and enum_range_internal().

#define EventTriggerNameIndexId   3467

Definition at line 238 of file indexing.h.

Referenced by BuildEventTriggerCache().

#define EventTriggerOidIndexId   3468

Definition at line 240 of file indexing.h.

#define ExtensionNameIndexId   3081

Definition at line 309 of file indexing.h.

Referenced by ExecAlterExtensionStmt(), and get_extension_oid().

#define ExtensionOidIndexId   3080
#define ForeignDataWrapperNameIndexId   548

Definition at line 274 of file indexing.h.

#define ForeignDataWrapperOidIndexId   112

Definition at line 271 of file indexing.h.

#define ForeignServerNameIndexId   549

Definition at line 280 of file indexing.h.

#define ForeignServerOidIndexId   113

Definition at line 277 of file indexing.h.

#define ForeignTableRelidIndexId   3119

Definition at line 289 of file indexing.h.

#define IndexIndrelidIndexId   2678

Definition at line 160 of file indexing.h.

Referenced by get_pkey_attnames(), and RelationGetIndexList().

#define IndexRelidIndexId   2679

Definition at line 162 of file indexing.h.

Referenced by RelationCacheInitializePhase3(), and sepgsql_index_modify().

#define InheritsParentIndexId   2187

Definition at line 168 of file indexing.h.

Referenced by find_inheritance_children().

#define InheritsRelidSeqnoIndexId   2680
#define LanguageNameIndexId   2681

Definition at line 171 of file indexing.h.

#define LanguageOidIndexId   2682

Definition at line 173 of file indexing.h.

#define LargeObjectLOidPNIndexId   2683

Definition at line 176 of file indexing.h.

Referenced by LargeObjectDrop(), and open_lo_relation().

#define LargeObjectMetadataOidIndexId   2996
#define NamespaceNameIndexId   2684

Definition at line 182 of file indexing.h.

#define NamespaceOidIndexId   2685

Definition at line 184 of file indexing.h.

Referenced by sepgsql_schema_post_create().

#define OpclassAmNameNspIndexId   2686

Definition at line 187 of file indexing.h.

Referenced by DefineOpClass(), and GetDefaultOpClass().

#define OpclassOidIndexId   2687

Definition at line 189 of file indexing.h.

Referenced by LookupOpclassInfo(), and RelationCacheInitializePhase3().

#define OperatorNameNspIndexId   2689

Definition at line 194 of file indexing.h.

Referenced by regoperin().

#define OperatorOidIndexId   2688

Definition at line 192 of file indexing.h.

#define OpfamilyAmNameNspIndexId   2754

Definition at line 197 of file indexing.h.

#define OpfamilyOidIndexId   2755

Definition at line 199 of file indexing.h.

#define PLTemplateNameIndexId   1137

Definition at line 202 of file indexing.h.

Referenced by find_language_template(), and IsSharedRelation().

#define ProcedureNameArgsNspIndexId   2691

Definition at line 207 of file indexing.h.

Referenced by regprocin().

#define ProcedureOidIndexId   2690

Definition at line 205 of file indexing.h.

Referenced by sepgsql_proc_post_create(), and sepgsql_proc_setattr().

#define RangeTypidIndexId   3542

Definition at line 312 of file indexing.h.

Referenced by RangeDelete().

#define RewriteOidIndexId   2692

Definition at line 210 of file indexing.h.

Referenced by getObjectDescription(), and RemoveRewriteRuleById().

#define RewriteRelRulenameIndexId   2693

Definition at line 212 of file indexing.h.

Referenced by RelationBuildRuleLock(), and RelationCacheInitializePhase3().

#define SecLabelObjectIndexId   3597

Definition at line 300 of file indexing.h.

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

#define SharedDependDependerIndexId   1232
#define SharedDependReferenceIndexId   1233
#define SharedDescriptionObjIndexId   2397

Definition at line 149 of file indexing.h.

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

#define SharedSecLabelObjectIndexId   3593
#define StatisticRelidAttnumInhIndexId   2696

Definition at line 222 of file indexing.h.

Referenced by RemoveStatistics().

#define TablespaceNameIndexId   2698

Definition at line 227 of file indexing.h.

Referenced by IsSharedRelation().

#define TablespaceOidIndexId   2697

Definition at line 225 of file indexing.h.

Referenced by IsSharedRelation().

#define TriggerConstraintIndexId   2699

Definition at line 231 of file indexing.h.

Referenced by AfterTriggerSetState().

#define TriggerOidIndexId   2702

Definition at line 235 of file indexing.h.

Referenced by getObjectDescription(), pg_get_triggerdef_worker(), and RemoveTriggerById().

#define TriggerRelidNameIndexId   2701
#define TSConfigMapIndexId   3609
#define TSConfigNameNspIndexId   3608

Definition at line 243 of file indexing.h.

#define TSConfigOidIndexId   3712

Definition at line 245 of file indexing.h.

#define TSDictionaryNameNspIndexId   3604

Definition at line 251 of file indexing.h.

#define TSDictionaryOidIndexId   3605

Definition at line 253 of file indexing.h.

#define TSParserNameNspIndexId   3606

Definition at line 256 of file indexing.h.

#define TSParserOidIndexId   3607

Definition at line 258 of file indexing.h.

#define TSTemplateNameNspIndexId   3766

Definition at line 261 of file indexing.h.

#define TSTemplateOidIndexId   3767

Definition at line 263 of file indexing.h.

#define TypeNameNspIndexId   2704

Definition at line 268 of file indexing.h.

Referenced by regtypein().

#define TypeOidIndexId   2703

Definition at line 266 of file indexing.h.

#define UserMappingOidIndexId   174

Definition at line 283 of file indexing.h.

#define UserMappingUserServerIndexId   175

Definition at line 286 of file indexing.h.


Typedef Documentation

Definition at line 26 of file indexing.h.


Function Documentation

void CatalogCloseIndexes ( CatalogIndexState  indstate  ) 
void CatalogIndexInsert ( CatalogIndexState  indstate,
HeapTuple  heapTuple 
)

Definition at line 72 of file indexing.c.

References Assert, ExecDropSingleTupleTableSlot(), ExecStoreTuple(), FormIndexDatum(), HeapTupleIsHeapOnly, i, IndexInfo::ii_ExclusionOps, IndexInfo::ii_Expressions, IndexInfo::ii_Predicate, IndexInfo::ii_ReadyForInserts, index_insert(), InvalidBuffer, MakeSingleTupleTableSlot(), NIL, NULL, RelationData::rd_index, RelationGetDescr, ResultRelInfo::ri_IndexRelationDescs, ResultRelInfo::ri_IndexRelationInfo, ResultRelInfo::ri_NumIndices, ResultRelInfo::ri_RelationDesc, HeapTupleData::t_self, UNIQUE_CHECK_NO, UNIQUE_CHECK_YES, and values.

Referenced by CatalogUpdateIndexes(), copyTemplateDependencies(), InsertPgAttributeTuple(), inv_truncate(), inv_write(), recordMultipleDependencies(), and swap_relation_files().

{
    int         i;
    int         numIndexes;
    RelationPtr relationDescs;
    Relation    heapRelation;
    TupleTableSlot *slot;
    IndexInfo **indexInfoArray;
    Datum       values[INDEX_MAX_KEYS];
    bool        isnull[INDEX_MAX_KEYS];

    /* HOT update does not require index inserts */
    if (HeapTupleIsHeapOnly(heapTuple))
        return;

    /*
     * Get information from the state structure.  Fall out if nothing to do.
     */
    numIndexes = indstate->ri_NumIndices;
    if (numIndexes == 0)
        return;
    relationDescs = indstate->ri_IndexRelationDescs;
    indexInfoArray = indstate->ri_IndexRelationInfo;
    heapRelation = indstate->ri_RelationDesc;

    /* Need a slot to hold the tuple being examined */
    slot = MakeSingleTupleTableSlot(RelationGetDescr(heapRelation));
    ExecStoreTuple(heapTuple, slot, InvalidBuffer, false);

    /*
     * for each index, form and insert the index tuple
     */
    for (i = 0; i < numIndexes; i++)
    {
        IndexInfo  *indexInfo;

        indexInfo = indexInfoArray[i];

        /* If the index is marked as read-only, ignore it */
        if (!indexInfo->ii_ReadyForInserts)
            continue;

        /*
         * Expressional and partial indexes on system catalogs are not
         * supported, nor exclusion constraints, nor deferred uniqueness
         */
        Assert(indexInfo->ii_Expressions == NIL);
        Assert(indexInfo->ii_Predicate == NIL);
        Assert(indexInfo->ii_ExclusionOps == NULL);
        Assert(relationDescs[i]->rd_index->indimmediate);

        /*
         * FormIndexDatum fills in its values and isnull parameters with the
         * appropriate values for the column(s) of the index.
         */
        FormIndexDatum(indexInfo,
                       slot,
                       NULL,    /* no expression eval to do */
                       values,
                       isnull);

        /*
         * The index AM does the rest.
         */
        index_insert(relationDescs[i],  /* index relation */
                     values,    /* array of index Datums */
                     isnull,    /* is-null flags */
                     &(heapTuple->t_self),      /* tid of heap tuple */
                     heapRelation,
                     relationDescs[i]->rd_index->indisunique ?
                     UNIQUE_CHECK_YES : UNIQUE_CHECK_NO);
    }

    ExecDropSingleTupleTableSlot(slot);
}

CatalogIndexState CatalogOpenIndexes ( Relation  heapRel  ) 

Definition at line 40 of file indexing.c.

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

Referenced by AddNewAttributeTuples(), AppendAttributeTuples(), CatalogUpdateIndexes(), copyTemplateDependencies(), inv_truncate(), inv_write(), recordMultipleDependencies(), and swap_relation_files().

{
    ResultRelInfo *resultRelInfo;

    resultRelInfo = makeNode(ResultRelInfo);
    resultRelInfo->ri_RangeTableIndex = 1;      /* dummy */
    resultRelInfo->ri_RelationDesc = heapRel;
    resultRelInfo->ri_TrigDesc = NULL;  /* we don't fire triggers */

    ExecOpenIndices(resultRelInfo);

    return resultRelInfo;
}

void CatalogUpdateIndexes ( Relation  heapRel,
HeapTuple  heapTuple 
)

Definition at line 157 of file indexing.c.

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

Referenced by AddEnumLabel(), AddRoleMems(), AggregateCreate(), AlterConstraintNamespaces(), AlterDatabase(), AlterDatabaseOwner(), AlterDomainDefault(), AlterDomainNotNull(), AlterDomainValidateConstraint(), AlterEventTrigger(), AlterEventTriggerOwner_internal(), AlterExtensionNamespace(), AlterForeignDataWrapper(), AlterForeignDataWrapperOwner_internal(), AlterForeignServer(), AlterForeignServerOwner_internal(), AlterFunction(), AlterObjectNamespace_internal(), AlterObjectOwner_internal(), AlterObjectRename_internal(), AlterRelationNamespaceInternal(), AlterRole(), AlterSchemaOwner_internal(), AlterSetting(), AlterTableSpaceOptions(), AlterTSDictionary(), AlterTypeNamespaceInternal(), AlterTypeOwner(), AlterTypeOwnerInternal(), AlterUserMapping(), ApplyExtensionUpdates(), ATExecAddColumn(), ATExecAddOf(), ATExecAlterColumnGenericOptions(), ATExecAlterColumnType(), ATExecChangeOwner(), ATExecDropColumn(), ATExecDropConstraint(), ATExecDropInherit(), ATExecDropNotNull(), ATExecDropOf(), ATExecGenericOptions(), ATExecSetNotNull(), ATExecSetOptions(), ATExecSetRelOptions(), ATExecSetStatistics(), ATExecSetStorage(), ATExecSetTableSpace(), ATExecValidateConstraint(), change_owner_fix_column_acls(), changeDependencyFor(), CollationCreate(), ConversionCreate(), create_proc_lang(), create_toast_table(), CreateCast(), CreateComments(), CreateConstraintEntry(), createdb(), CreateForeignDataWrapper(), CreateForeignServer(), CreateForeignTable(), CreateOpFamily(), CreateRole(), CreateSharedComments(), CreateTableSpace(), CreateTrigger(), CreateUserMapping(), DefineOpClass(), DefineQueryRewrite(), DefineTSConfiguration(), DefineTSDictionary(), DefineTSParser(), DefineTSTemplate(), DelRoleMems(), EnableDisableRule(), EnableDisableTrigger(), EnumValuesCreate(), 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(), index_build(), index_constraint_create(), insert_event_trigger_tuple(), InsertExtensionTuple(), InsertPgAttributeTuple(), InsertPgClassTuple(), InsertRule(), LargeObjectCreate(), MakeConfigurationMapping(), mark_index_clustered(), MergeAttributesIntoExisting(), MergeConstraintsIntoExisting(), MergeWithExistingConstraint(), movedb(), NamespaceCreate(), OperatorCreate(), OperatorShellMake(), OperatorUpd(), pg_extension_config_dump(), ProcedureCreate(), RangeCreate(), reindex_index(), RelationSetNewRelfilenode(), RemoveAttrDefaultById(), RemoveAttributeById(), RemoveConstraintById(), renameatt_internal(), RenameConstraintById(), RenameDatabase(), RenameRelationInternal(), RenameRewriteRule(), RenameRole(), RenameSchema(), RenameTableSpace(), renametrig(), RenameTypeInternal(), RenumberEnumType(), SetDefaultACL(), SetFunctionArgType(), SetFunctionReturnType(), SetRelationHasSubclass(), SetRelationNumChecks(), SetRelationRuleStatus(), SetSecurityLabel(), SetSharedSecurityLabel(), shdepAddDependency(), shdepChangeDep(), StoreAttrDefault(), StoreCatalogInheritance1(), storeOperators(), storeProcedures(), TypeCreate(), TypeShellMake(), update_attstats(), and UpdateIndexRelation().

{
    CatalogIndexState indstate;

    indstate = CatalogOpenIndexes(heapRel);
    CatalogIndexInsert(indstate, heapTuple);
    CatalogCloseIndexes(indstate);
}

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 ( pg_shdepend_reference_index  ,
1233  ,
on pg_shdepend using   btreerefclassid oid_ops, refobjid oid_ops 
)
DECLARE_INDEX ( pg_trigger_tgconstraint_index  ,
2699  ,
on pg_trigger using   btreetgconstraint oid_ops 
)
DECLARE_INDEX ( pg_depend_depender_index  ,
2673  ,
on pg_depend using   btreeclassid oid_ops, objid oid_ops, objsubid int4_ops 
)
DECLARE_INDEX ( pg_depend_reference_index  ,
2674  ,
on pg_depend using   btreerefclassid oid_ops, refobjid oid_ops, refobjsubid int4_ops 
)
DECLARE_INDEX ( pg_index_indrelid_index  ,
2678  ,
on pg_index using   btreeindrelid oid_ops 
)
DECLARE_INDEX ( pg_inherits_parent_index  ,
2187  ,
on pg_inherits using   btreeinhparent oid_ops 
)
DECLARE_INDEX ( pg_constraint_conname_nsp_index  ,
2664  ,
on pg_constraint using   btreeconname name_ops, connamespace oid_ops 
)
DECLARE_INDEX ( pg_constraint_conrelid_index  ,
2665  ,
on pg_constraint using   btreeconrelid oid_ops 
)
DECLARE_INDEX ( pg_constraint_contypid_index  ,
2666  ,
on pg_constraint using   btreecontypid oid_ops 
)
DECLARE_UNIQUE_INDEX ( pg_foreign_data_wrapper_name_index  ,
548  ,
on pg_foreign_data_wrapper using   btreefdwname name_ops 
)
DECLARE_UNIQUE_INDEX ( pg_foreign_data_wrapper_oid_index  ,
112  ,
on pg_foreign_data_wrapper using   btreeoid oid_ops 
)
DECLARE_UNIQUE_INDEX ( pg_type_typname_nsp_index  ,
2704  ,
on pg_type using   btreetypname name_ops, typnamespace oid_ops 
)
DECLARE_UNIQUE_INDEX ( pg_type_oid_index  ,
2703  ,
on pg_type using   btreeoid oid_ops 
)
DECLARE_UNIQUE_INDEX ( pg_ts_template_oid_index  ,
3767  ,
on pg_ts_template using   btreeoid oid_ops 
)
DECLARE_UNIQUE_INDEX ( pg_ts_template_tmplname_index  ,
3766  ,
on pg_ts_template using   btreetmplname name_ops, tmplnamespace oid_ops 
)
DECLARE_UNIQUE_INDEX ( pg_ts_parser_oid_index  ,
3607  ,
on pg_ts_parser using   btreeoid oid_ops 
)
DECLARE_UNIQUE_INDEX ( pg_ts_parser_prsname_index  ,
3606  ,
on pg_ts_parser using   btreeprsname name_ops, prsnamespace oid_ops 
)
DECLARE_UNIQUE_INDEX ( pg_ts_dict_oid_index  ,
3605  ,
on pg_ts_dict using   btreeoid oid_ops 
)
DECLARE_UNIQUE_INDEX ( pg_ts_dict_dictname_index  ,
3604  ,
on pg_ts_dict using   btreedictname name_ops, dictnamespace oid_ops 
)
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 ( pg_ts_config_oid_index  ,
3712  ,
on pg_ts_config using   btreeoid oid_ops 
)
DECLARE_UNIQUE_INDEX ( pg_ts_config_cfgname_index  ,
3608  ,
on pg_ts_config using   btreecfgname name_ops, cfgnamespace oid_ops 
)
DECLARE_UNIQUE_INDEX ( pg_event_trigger_oid_index  ,
3468  ,
on pg_event_trigger using   btreeoid oid_ops 
)
DECLARE_UNIQUE_INDEX ( pg_event_trigger_evtname_index  ,
3467  ,
on pg_event_trigger using   btreeevtname name_ops 
)
DECLARE_UNIQUE_INDEX ( pg_trigger_oid_index  ,
2702  ,
on pg_trigger using   btreeoid oid_ops 
)
DECLARE_UNIQUE_INDEX ( pg_trigger_tgrelid_tgname_index  ,
2701  ,
on pg_trigger using   btreetgrelid oid_ops, tgname name_ops 
)
DECLARE_UNIQUE_INDEX ( pg_database_datname_index  ,
2671  ,
on pg_database using   btreedatname name_ops 
)
DECLARE_UNIQUE_INDEX ( pg_tablespace_spcname_index  ,
2698  ,
on pg_tablespace using   btreespcname name_ops 
)
DECLARE_UNIQUE_INDEX ( pg_tablespace_oid_index  ,
2697  ,
on pg_tablespace using   btreeoid oid_ops 
)
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 ( pg_attribute_relid_attnum_index  ,
2659  ,
on pg_attribute using   btreeattrelid oid_ops, attnum int2_ops 
)
DECLARE_UNIQUE_INDEX ( pg_conversion_name_nsp_index  ,
2669  ,
on pg_conversion using   btreeconname name_ops, connamespace oid_ops 
)
DECLARE_UNIQUE_INDEX ( pg_rewrite_rel_rulename_index  ,
2693  ,
on pg_rewrite using   btreeev_class oid_ops, rulename name_ops 
)
DECLARE_UNIQUE_INDEX ( pg_rewrite_oid_index  ,
2692  ,
on pg_rewrite using   btreeoid oid_ops 
)
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 ( pg_proc_oid_index  ,
2690  ,
on pg_proc using   btreeoid oid_ops 
)
DECLARE_UNIQUE_INDEX ( pg_pltemplate_name_index  ,
1137  ,
on pg_pltemplate using   btreetmplname name_ops 
)
DECLARE_UNIQUE_INDEX ( pg_opfamily_oid_index  ,
2755  ,
on pg_opfamily using   btreeoid oid_ops 
)
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 ( 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 ( pg_operator_oid_index  ,
2688  ,
on pg_operator using   btreeoid oid_ops 
)
DECLARE_UNIQUE_INDEX ( pg_opclass_oid_index  ,
2687  ,
on pg_opclass using   btreeoid oid_ops 
)
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 ( pg_namespace_oid_index  ,
2685  ,
on pg_namespace using   btreeoid oid_ops 
)
DECLARE_UNIQUE_INDEX ( pg_namespace_nspname_index  ,
2684  ,
on pg_namespace using   btreenspname name_ops 
)
DECLARE_UNIQUE_INDEX ( pg_largeobject_metadata_oid_index  ,
2996  ,
on pg_largeobject_metadata using   btreeoid oid_ops 
)
DECLARE_UNIQUE_INDEX ( pg_largeobject_loid_pn_index  ,
2683  ,
on pg_largeobject using   btreeloid oid_ops, pageno int4_ops 
)
DECLARE_UNIQUE_INDEX ( pg_language_oid_index  ,
2682  ,
on pg_language using   btreeoid oid_ops 
)
DECLARE_UNIQUE_INDEX ( pg_language_name_index  ,
2681  ,
on pg_language using   btreelanname name_ops 
)
DECLARE_UNIQUE_INDEX ( pg_class_oid_index  ,
2662  ,
on pg_class using   btreeoid oid_ops 
)
DECLARE_UNIQUE_INDEX ( pg_inherits_relid_seqno_index  ,
2680  ,
on pg_inherits using   btreeinhrelid oid_ops, inhseqno int4_ops 
)
DECLARE_UNIQUE_INDEX ( pg_index_indexrelid_index  ,
2679  ,
on pg_index using   btreeindexrelid oid_ops 
)
DECLARE_UNIQUE_INDEX ( pg_cast_oid_index  ,
2660  ,
on pg_cast using   btreeoid oid_ops 
)
DECLARE_UNIQUE_INDEX ( pg_enum_typid_sortorder_index  ,
3534  ,
on pg_enum using   btreeenumtypid oid_ops, enumsortorder float4_ops 
)
DECLARE_UNIQUE_INDEX ( pg_enum_typid_label_index  ,
3503  ,
on pg_enum using   btreeenumtypid oid_ops, enumlabel name_ops 
)
DECLARE_UNIQUE_INDEX ( pg_enum_oid_index  ,
3502  ,
on pg_enum using   btreeoid oid_ops 
)
DECLARE_UNIQUE_INDEX ( pg_shdescription_o_c_index  ,
2397  ,
on pg_shdescription using   btreeobjoid oid_ops, classoid oid_ops 
)
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 ( pg_amop_opr_fam_index  ,
2654  ,
on pg_amop using   btreeamopopr oid_ops, amoppurpose char_ops, amopfamily oid_ops 
)
DECLARE_UNIQUE_INDEX ( pg_authid_oid_index  ,
2677  ,
on pg_authid using   btreeoid oid_ops 
)
DECLARE_UNIQUE_INDEX ( pg_database_oid_index  ,
2672  ,
on pg_database using   btreeoid oid_ops 
)
DECLARE_UNIQUE_INDEX ( pg_authid_rolname_index  ,
2676  ,
on pg_authid using   btreerolname name_ops 
)
DECLARE_UNIQUE_INDEX ( pg_conversion_oid_index  ,
2670  ,
on pg_conversion using   btreeoid oid_ops 
)
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 ( pg_conversion_default_index  ,
2668  ,
on pg_conversion using   btreeconnamespace oid_ops, conforencoding int4_ops, contoencoding int4_ops, oid oid_ops 
)
DECLARE_UNIQUE_INDEX ( pg_constraint_oid_index  ,
2667  ,
on pg_constraint using   btreeoid oid_ops 
)
DECLARE_UNIQUE_INDEX ( pg_am_oid_index  ,
2652  ,
on pg_am using   btreeoid oid_ops 
)
DECLARE_UNIQUE_INDEX ( pg_attrdef_oid_index  ,
2657  ,
on pg_attrdef using   btreeoid oid_ops 
)
DECLARE_UNIQUE_INDEX ( pg_attrdef_adrelid_adnum_index  ,
2656  ,
on pg_attrdef using   btreeadrelid oid_ops, adnum int2_ops 
)
DECLARE_UNIQUE_INDEX ( pg_collation_oid_index  ,
3085  ,
on pg_collation using   btreeoid oid_ops 
)
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 ( pg_class_relname_nsp_index  ,
2663  ,
on pg_class using   btreerelname name_ops, relnamespace oid_ops 
)
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 ( pg_cast_source_target_index  ,
2661  ,
on pg_cast using   btreecastsource oid_ops, casttarget oid_ops 
)
DECLARE_UNIQUE_INDEX ( pg_amop_oid_index  ,
2756  ,
on pg_amop using   btreeoid oid_ops 
)
DECLARE_UNIQUE_INDEX ( pg_auth_members_member_role_index  ,
2695  ,
on pg_auth_members using   btreemember oid_ops, roleid oid_ops 
)
DECLARE_UNIQUE_INDEX ( pg_auth_members_role_member_index  ,
2694  ,
on pg_auth_members using   btreeroleid oid_ops, member oid_ops 
)
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 ( pg_extension_oid_index  ,
3080  ,
on pg_extension using   btreeoid oid_ops 
)
DECLARE_UNIQUE_INDEX ( pg_extension_name_index  ,
3081  ,
on pg_extension using   btreeextname name_ops 
)
DECLARE_UNIQUE_INDEX ( pg_attribute_relid_attnam_index  ,
2658  ,
on pg_attribute using   btreeattrelid oid_ops, attname name_ops 
)
DECLARE_UNIQUE_INDEX ( pg_user_mapping_oid_index  ,
174  ,
on pg_user_mapping using   btreeoid oid_ops 
)
DECLARE_UNIQUE_INDEX ( pg_am_name_index  ,
2651  ,
on pg_am using   btreeamname name_ops 
)
DECLARE_UNIQUE_INDEX ( pg_amproc_oid_index  ,
2757  ,
on pg_amproc using   btreeoid oid_ops 
)
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 ( pg_aggregate_fnoid_index  ,
2650  ,
on pg_aggregate using   btreeaggfnoid oid_ops 
)
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 ( pg_shseclabel_object_index  ,
3593  ,
on pg_shseclabel using   btreeobjoid oid_ops, classoid oid_ops, provider text_ops 
)
DECLARE_UNIQUE_INDEX ( pg_foreign_server_name_index  ,
549  ,
on pg_foreign_server using   btreesrvname name_ops 
)
DECLARE_UNIQUE_INDEX ( pg_range_rngtypid_index  ,
3542  ,
on pg_range using   btreerngtypid oid_ops 
)
DECLARE_UNIQUE_INDEX ( pg_foreign_table_relid_index  ,
3119  ,
on pg_foreign_table using   btreeftrelid oid_ops 
)
DECLARE_UNIQUE_INDEX ( pg_default_acl_oid_index  ,
828  ,
on pg_default_acl using   btreeoid oid_ops 
)
DECLARE_UNIQUE_INDEX ( pg_foreign_server_oid_index  ,
113  ,
on pg_foreign_server using   btreeoid oid_ops 
)
DECLARE_UNIQUE_INDEX ( pg_user_mapping_user_server_index  ,
175  ,
on pg_user_mapping using   btreeumuser oid_ops, umserver oid_ops 
)