pg_range.h File Reference

#include "catalog/genbki.h"
#include "catalog/pg_range_d.h"

Include dependency graph for pg_range.h:

This graph shows which files directly or indirectly include this file:

Go to the source code of this file.

Typedefs
typedef FormData_pg_range *	Form_pg_range

Functions
	CATALOG (pg_range, 3541, RangeRelationId)
	DECLARE_UNIQUE_INDEX_PKEY (pg_range_rngtypid_index, 3542, RangeTypidIndexId, pg_range, btree(rngtypid oid_ops))
	DECLARE_UNIQUE_INDEX (pg_range_rngmultitypid_index, 2228, RangeMultirangeTypidIndexId, pg_range, btree(rngmultitypid oid_ops))
	MAKE_SYSCACHE (RANGETYPE, pg_range_rngtypid_index, 4)
	MAKE_SYSCACHE (RANGEMULTIRANGE, pg_range_rngmultitypid_index, 4)
void	RangeCreate (Oid rangeTypeOid, Oid rangeSubType, Oid rangeCollation, Oid rangeSubOpclass, RegProcedure rangeCanonical, RegProcedure rangeSubDiff, Oid multirangeTypeOid)
void	RangeDelete (Oid rangeTypeOid)

Variables
	FormData_pg_range

Typedef Documentation

Form_pg_range

typedef FormData_pg_range* Form_pg_range

Definition at line 58 of file pg_range.h.

Function Documentation

CATALOG()

CATALOG	(	pg_range	,
		3541	,
		RangeRelationId
	)

Definition at line 29 of file pg_range.h.

{
    /* OID of owning range type */
    Oid         rngtypid BKI_LOOKUP(pg_type);
 
    /* OID of range's element type (subtype) */
    Oid         rngsubtype BKI_LOOKUP(pg_type);
 
    /* OID of the range's multirange type */
    Oid         rngmultitypid BKI_LOOKUP(pg_type);
 
    /* collation for this range type, or 0 */
    Oid         rngcollation BKI_DEFAULT(0) BKI_LOOKUP_OPT(pg_collation);
 
    /* subtype's btree opclass */
    Oid         rngsubopc BKI_LOOKUP(pg_opclass);
 
    /* canonicalize range, or 0 */
    regproc     rngcanonical BKI_LOOKUP_OPT(pg_proc);
 
    /* subtype difference as a float8, or 0 */
    regproc     rngsubdiff BKI_LOOKUP_OPT(pg_proc);
} FormData_pg_range;

References BKI_DEFAULT, BKI_LOOKUP, and BKI_LOOKUP_OPT.

DECLARE_UNIQUE_INDEX()

DECLARE_UNIQUE_INDEX	(	pg_range_rngmultitypid_index	,
		2228	,
		RangeMultirangeTypidIndexId	,
		pg_range	,
		btree(rngmultitypid oid_ops)
	)

DECLARE_UNIQUE_INDEX_PKEY()

DECLARE_UNIQUE_INDEX_PKEY	(	pg_range_rngtypid_index	,
		3542	,
		RangeTypidIndexId	,
		pg_range	,
		btree(rngtypid oid_ops)
	)

MAKE_SYSCACHE() [1/2]

MAKE_SYSCACHE	(	RANGEMULTIRANGE	,
		pg_range_rngmultitypid_index	,
		4
	)

MAKE_SYSCACHE() [2/2]

MAKE_SYSCACHE	(	RANGETYPE	,
		pg_range_rngtypid_index	,
		4
	)

RangeCreate()

void RangeCreate	(	Oid	rangeTypeOid,
		Oid	rangeSubType,
		Oid	rangeCollation,
		Oid	rangeSubOpclass,
		RegProcedure	rangeCanonical,
		RegProcedure	rangeSubDiff,
		Oid	multirangeTypeOid
	)

Definition at line 36 of file pg_range.c.

{
    Relation    pg_range;
    Datum       values[Natts_pg_range];
    bool        nulls[Natts_pg_range];
    HeapTuple   tup;
    ObjectAddress myself;
    ObjectAddress referenced;
    ObjectAddress referencing;
    ObjectAddresses *addrs;
 
    pg_range = table_open(RangeRelationId, RowExclusiveLock);
 
    memset(nulls, 0, sizeof(nulls));
 
    values[Anum_pg_range_rngtypid - 1] = ObjectIdGetDatum(rangeTypeOid);
    values[Anum_pg_range_rngsubtype - 1] = ObjectIdGetDatum(rangeSubType);
    values[Anum_pg_range_rngcollation - 1] = ObjectIdGetDatum(rangeCollation);
    values[Anum_pg_range_rngsubopc - 1] = ObjectIdGetDatum(rangeSubOpclass);
    values[Anum_pg_range_rngcanonical - 1] = ObjectIdGetDatum(rangeCanonical);
    values[Anum_pg_range_rngsubdiff - 1] = ObjectIdGetDatum(rangeSubDiff);
    values[Anum_pg_range_rngmultitypid - 1] = ObjectIdGetDatum(multirangeTypeOid);
 
    tup = heap_form_tuple(RelationGetDescr(pg_range), values, nulls);
 
    CatalogTupleInsert(pg_range, tup);
    heap_freetuple(tup);
 
    /* record type's dependencies on range-related items */
    addrs = new_object_addresses();
 
    ObjectAddressSet(myself, TypeRelationId, rangeTypeOid);
 
    ObjectAddressSet(referenced, TypeRelationId, rangeSubType);
    add_exact_object_address(&referenced, addrs);
 
    ObjectAddressSet(referenced, OperatorClassRelationId, rangeSubOpclass);
    add_exact_object_address(&referenced, addrs);
 
    if (OidIsValid(rangeCollation))
    {
        ObjectAddressSet(referenced, CollationRelationId, rangeCollation);
        add_exact_object_address(&referenced, addrs);
    }
 
    if (OidIsValid(rangeCanonical))
    {
        ObjectAddressSet(referenced, ProcedureRelationId, rangeCanonical);
        add_exact_object_address(&referenced, addrs);
    }
 
    if (OidIsValid(rangeSubDiff))
    {
        ObjectAddressSet(referenced, ProcedureRelationId, rangeSubDiff);
        add_exact_object_address(&referenced, addrs);
    }
 
    record_object_address_dependencies(&myself, addrs, DEPENDENCY_NORMAL);
    free_object_addresses(addrs);
 
    /* record multirange type's dependency on the range type */
    referencing.classId = TypeRelationId;
    referencing.objectId = multirangeTypeOid;
    referencing.objectSubId = 0;
    recordDependencyOn(&referencing, &myself, DEPENDENCY_INTERNAL);
 
    table_close(pg_range, RowExclusiveLock);
}

References add_exact_object_address(), CatalogTupleInsert(), ObjectAddress::classId, DEPENDENCY_INTERNAL, DEPENDENCY_NORMAL, free_object_addresses(), heap_form_tuple(), heap_freetuple(), new_object_addresses(), ObjectAddressSet, ObjectAddress::objectId, ObjectIdGetDatum(), ObjectAddress::objectSubId, OidIsValid, record_object_address_dependencies(), recordDependencyOn(), RelationGetDescr, RowExclusiveLock, table_close(), table_open(), and values.

Referenced by DefineRange().

RangeDelete()

void RangeDelete

(

Oid

rangeTypeOid

)

Definition at line 113 of file pg_range.c.

{
    Relation    pg_range;
    ScanKeyData key[1];
    SysScanDesc scan;
    HeapTuple   tup;
 
    pg_range = table_open(RangeRelationId, RowExclusiveLock);
 
    ScanKeyInit(&key[0],
                Anum_pg_range_rngtypid,
                BTEqualStrategyNumber, F_OIDEQ,
                ObjectIdGetDatum(rangeTypeOid));
 
    scan = systable_beginscan(pg_range, RangeTypidIndexId, true,
                              NULL, 1, key);
 
    while (HeapTupleIsValid(tup = systable_getnext(scan)))
    {
        CatalogTupleDelete(pg_range, &tup->t_self);
    }
 
    systable_endscan(scan);
 
    table_close(pg_range, RowExclusiveLock);
}

References BTEqualStrategyNumber, CatalogTupleDelete(), HeapTupleIsValid, sort-test::key, ObjectIdGetDatum(), RowExclusiveLock, ScanKeyInit(), systable_beginscan(), systable_endscan(), systable_getnext(), HeapTupleData::t_self, table_close(), and table_open().

Referenced by RemoveTypeById().

Variable Documentation

FormData_pg_range

FormData_pg_range

Definition at line 51 of file pg_range.h.