table_get_spatial_index()

static Oid table_get_spatial_index ( Oid  tbl_oid, int16  attnum, int *  key_type, int16 *  idx_attnum  )

static

Definition at line 2233 of file gserialized_estimate.c.

{
        Relation table_rel;
        List *index_list;
        ListCell *lc;
 
        /* Lookup our spatial index key types */
        Oid b2d_oid = postgis_oid(BOX2DFOID);
        Oid gdx_oid = postgis_oid(GIDXOID);
 
        if (!(b2d_oid && gdx_oid))
                return InvalidOid;
 
        /* Read a list of all indexes on this table */
        table_rel = RelationIdGetRelation(table_oid);
        index_list = RelationGetIndexList(table_rel);
        RelationClose(table_rel);
 
        /* For each index associated with this table... */
        foreach(lc, index_list)
        {
                Oid index_oid = lfirst_oid(lc);
                Oid atttypid;
 
                /* Is our attribute indexed by this index? */
                *idx_attnum = index_has_attr(index_oid, table_oid, attnum);
 
                /* No, move on */
                if (*idx_attnum == InvalidAttrNumber)
                        continue;
 
                /* We only handle GIST spatial indexes */
                if (index_get_am(index_oid) != GIST_AM_OID)
                        continue;
 
                /* Is the column actually spatial? */
                /* Only if it uses our spatial key types */
                atttypid = index_get_keytype (index_oid, *idx_attnum);
                if (atttypid == b2d_oid || atttypid == gdx_oid)
                {
                        /* Spatial key found in this index! */
                        *key_type = (atttypid == b2d_oid ? STATISTIC_KIND_2D : STATISTIC_KIND_ND);
                        return index_oid;
                }
        }
        return InvalidOid;
}

References index_get_am(), index_get_keytype(), index_has_attr(), STATISTIC_KIND_2D, and STATISTIC_KIND_ND.

Referenced by _postgis_gserialized_index_extent(), and gserialized_estimated_extent().

Here is the call graph for this function:

Here is the caller graph for this function: