Import from CVSHEADmaster

1 files changed, 12 insertions, 0 deletions

diff --git a/pgsql_mib_pieces/pg_index.tbldef b/pgsql_mib_pieces/pg_index.tbldef
new file mode 100644
index 0000000..afda4a5
--- /dev/null
+++ b/pgsql_mib_pieces/pg_index.tbldef
@@ -0,0 +1,12 @@
+pg_index	"The catalog pg_index contains part of the information about indexes. The rest is mostly in pg_class."	"Represents a single index"	pgsqlCatalogTables	17	"pgsnmpdConnID, rdbmsDbIndex, pgsqlPgIndexIndexrelid"
+indexrelid	INTEGER	"The OID of the pg_class entry for this index"
+indrelid	INTEGER	"The OID of the pg_class entry for the table this index is for"
+indnatts	INTEGER	"The number of columns in the index (duplicates pg_class.relnatts )"
+indisunique	TruthValue	"If true, this is a unique index"
+indisprimary	TruthValue	"If true, this index represents the primary key of the table. ( indisunique should always be true when this is true.)"
+indisclustered	TruthValue	"If true, the table was last clustered on this index"
+indisvalid	TruthValue	"If true, the index is currently valid for queries. False means the index is possibly incomplete: it must still be modified by INSERT / UPDATE operations, but it cannot safely be used for queries. If it is unique, the uniqueness property is not true either"
+indkey	DisplayString	"This is an array of indnatts values that indicate which table columns this index indexes. For example a value of 1 3 would mean that the first and the third table columns make up the index key. A zero in this array indicates that the corresponding index attribute is an expression over the table columns, rather than a simple column reference."
+indclass	DisplayString	"For each column in the index key this contains the OID of the operator class to use. See pg_opclass for details"
+indexprs	DisplayString	"Expression trees (in nodeToString() representation) for index attributes that are not simple column references. This is a list with one element for each zero entry in indkey . NULL if all index attributes are simple references"
+indpred	DisplayString	"Expression tree (in nodeToString() representation) for partial index predicate. NULL if not a partial index"