<!--

Documentation of the system catalogs, directed toward PostgreSQL developers

$Header: /cvsroot/pgsql/doc/src/sgml/catalogs.sgml,v 2.66 2003/02/22 00:45:03 tgl Exp $

$Header: /cvsroot/pgsql/doc/src/sgml/catalogs.sgml,v 2.67 2003/03/23 05:14:36 tgl Exp $

-->

<chapter id="catalogs">

<row>

<entry>stavaluesN</entry>

<entry><type>text[]</type></entry>

<entry><type>anyarray</type></entry>

<entry></entry>

<entry>Column data values of the appropriate kind for the Nth

<quote>slot</quote>, or NULL if the slot kind does not store any data values.

For data-type independence, all column data values are converted

to external textual form and stored as TEXT datums.

<quote>slot</quote>, or NULL if the slot kind does not store any data

values.

Each array's element values are actually of the specific column's

datatype, so there is no way to define these columns' type more

specifically than <quote>anyarray</>.

</entry>

</row>

</tbody>

"\n\tProceeding with relation creation anyway",

attname);

elseif (att_typtype=='p')

elog(ERROR,"Attribute \"%s\" has pseudo-type %s",

attname,format_type_be(atttypid));

{

if (atttypid!=ANYARRAYOID||IsUnderPostmaster)

elog(ERROR,"Attribute \"%s\" has pseudo-type %s",

attname,format_type_be(atttypid));

}

elseif (att_typtype=='c')

{

Oidtyprelid=get_typ_typrelid(atttypid);

for (attno=0;attno<natts;attno++)

{

VacAttrStats*stats=vacattrstats[attno];

FmgrInfoout_function;

HeapTuplestup,

oldtup;

inti,

if (!stats->stats_valid)

continue;

fmgr_info(stats->attrtype->typoutput,&out_function);

}

for (k=0;k<STATISTIC_NUM_SLOTS;k++)

{

intntxt=stats->numvalues[k];

if (ntxt>0)

if (stats->numvalues[k]>0)

{

Datum*txtdatums= (Datum*)palloc(ntxt*sizeof(Datum));

ArrayType*arry;

for (n=0;n<ntxt;n++)

{

Datumstringdatum;

FunctionCall3(&out_function,

stats->stavalues[k][n],

ObjectIdGetDatum(stats->attrtype->typelem),

Int32GetDatum(stats->attr->atttypmod));

txtdatums[n]=DirectFunctionCall1(textin,stringdatum);

pfree(DatumGetPointer(stringdatum));

}

arry=construct_array(txtdatums,ntxt,

TEXTOID,

-1, false,'i');

arry=construct_array(stats->stavalues[k],

stats->numvalues[k],

stats->attr->atttypid,

stats->attrtype->typlen,

stats->attrtype->typbyval,

stats->attrtype->typalign);

values[i++]=PointerGetDatum(arry);/* stavaluesN */

}

if (IsA(left,RelabelType))

left= (Var*) ((RelabelType*)left)->arg;

if (IsA(right,RelabelType))

right= (Var*) ((RelabelType*)right)->arg;

if (!IsA(left,Var)||

ArrayType*statarray;

intnarrayelem;

HeapTupletypeTuple;

FmgrInfoinputproc;

Oidtypelem;

Form_pg_typetypeForm;

for (i=0;i<STATISTIC_NUM_SLOTS;i++)

{

elog(ERROR,"get_attstatsslot: stavalues is null");

statarray=DatumGetArrayTypeP(val);

deconstruct_array(statarray,

TEXTOID,-1, false,'i',

values,nvalues);

narrayelem=*nvalues;

typeTuple=SearchSysCache(TYPEOID,

ObjectIdGetDatum(atttype),

0,0,0);

if (!HeapTupleIsValid(typeTuple))

elog(ERROR,"get_attstatsslot: Cache lookup failed for type %u",

atttype);

fmgr_info(((Form_pg_type)GETSTRUCT(typeTuple))->typinput,&inputproc);

typelem= ((Form_pg_type)GETSTRUCT(typeTuple))->typelem;

ReleaseSysCache(typeTuple);

typeForm= (Form_pg_type)GETSTRUCT(typeTuple);

deconstruct_array(statarray,

atttype,

typeForm->typlen,

typeForm->typbyval,

typeForm->typalign,

values,nvalues);

for (j=0;j<narrayelem;j++)

if (!typeForm->typbyval)

{

char*strval;

strval=DatumGetCString(DirectFunctionCall1(textout,

(*values)[j]));

(*values)[j]=FunctionCall3(&inputproc,

CStringGetDatum(strval),

ObjectIdGetDatum(typelem),

Int32GetDatum(atttypmod));

pfree(strval);

for (j=0;j<*nvalues;j++)

{

(*values)[j]=datumCopy((*values)[j],

typeForm->typbyval,

typeForm->typlen);

}

}

ReleaseSysCache(typeTuple);

typedefstructvarlenaanyarray;

float4stanumbers4[1];

textstavalues1[1];

textstavalues2[1];

textstavalues3[1];

textstavalues4[1];

anyarraystavalues1;

anyarraystavalues2;

anyarraystavalues3;

anyarraystavalues4;

}FormData_pg_statistic;

#defineSTATISTIC_NUM_SLOTS 4

-- Check that ruleutils are working

--

SELECT viewname, definition FROM pg_views WHERE schemaname <> 'information_schema' ORDER BY viewname;

viewname | definition

--------------------------+-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------

viewname | definition

--------------------------+---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------

iexit | SELECT ih.name, ih.thepath, interpt_pp(ih.thepath, r.thepath) AS exit FROM ihighway ih, ramp r WHERE (ih.thepath ## r.thepath);

pg_indexes | SELECT n.nspname AS schemaname, c.relname AS tablename, i.relname AS indexname, pg_get_indexdef(i.oid) AS indexdef FROM (((pg_index x JOIN pg_class c ON ((c.oid = x.indrelid))) JOIN pg_class i ON ((i.oid = x.indexrelid))) LEFT JOIN pg_namespace n ON ((n.oid = c.relnamespace))) WHERE ((c.relkind = 'r'::"char") AND (i.relkind = 'i'::"char"));

pg_locks | SELECT l.relation, l."database", l."transaction", l.pid, l."mode", l.granted FROM pg_lock_status() l(relation oid, "database" oid, "transaction" xid, pid integer, "mode" text, granted boolean);

pg_statio_user_indexes | SELECT pg_statio_all_indexes.relid, pg_statio_all_indexes.indexrelid, pg_statio_all_indexes.schemaname, pg_statio_all_indexes.relname, pg_statio_all_indexes.indexrelname, pg_statio_all_indexes.idx_blks_read, pg_statio_all_indexes.idx_blks_hit FROM pg_statio_all_indexes WHERE ((pg_statio_all_indexes.schemaname <> 'pg_catalog'::name) AND (pg_statio_all_indexes.schemaname <> 'pg_toast'::name));

pg_statio_user_sequences | SELECT pg_statio_all_sequences.relid, pg_statio_all_sequences.schemaname, pg_statio_all_sequences.relname, pg_statio_all_sequences.blks_read, pg_statio_all_sequences.blks_hit FROM pg_statio_all_sequences WHERE ((pg_statio_all_sequences.schemaname <> 'pg_catalog'::name) AND (pg_statio_all_sequences.schemaname <> 'pg_toast'::name));

pg_statio_user_tables | SELECT pg_statio_all_tables.relid, pg_statio_all_tables.schemaname, pg_statio_all_tables.relname, pg_statio_all_tables.heap_blks_read, pg_statio_all_tables.heap_blks_hit, pg_statio_all_tables.idx_blks_read, pg_statio_all_tables.idx_blks_hit, pg_statio_all_tables.toast_blks_read, pg_statio_all_tables.toast_blks_hit, pg_statio_all_tables.tidx_blks_read, pg_statio_all_tables.tidx_blks_hit FROM pg_statio_all_tables WHERE ((pg_statio_all_tables.schemaname <> 'pg_catalog'::name) AND (pg_statio_all_tables.schemaname <> 'pg_toast'::name));

pg_stats | SELECT nspname AS schemaname, relname AS tablename, attname, stanullfrac AS null_frac, stawidth AS avg_width, stadistinct AS n_distinct, CASE WHEN (1 = stakind1) THEN stavalues1 WHEN (1 = stakind2) THEN stavalues2 WHEN (1 = stakind3) THEN stavalues3 WHEN (1 = stakind4) THEN stavalues4 ELSE NULL::text[] END AS most_common_vals, CASE WHEN (1 = stakind1) THEN stanumbers1 WHEN (1 = stakind2) THEN stanumbers2 WHEN (1 = stakind3) THEN stanumbers3 WHEN (1 = stakind4) THEN stanumbers4 ELSE NULL::real[] END AS most_common_freqs, CASE WHEN (2 = stakind1) THEN stavalues1 WHEN (2 = stakind2) THEN stavalues2 WHEN (2 = stakind3) THEN stavalues3 WHEN (2 = stakind4) THEN stavalues4 ELSE NULL::text[] END AS histogram_bounds, CASE WHEN (3 = stakind1) THEN stanumbers1[1] WHEN (3 = stakind2) THEN stanumbers2[1] WHEN (3 = stakind3) THEN stanumbers3[1] WHEN (3 = stakind4) THEN stanumbers4[1] ELSE NULL::real END AS correlation FROM (((pg_statistic s JOIN pg_class c ON ((c.oid = s.starelid))) JOIN pg_attribute a ON (((c.oid = a.attrelid) AND (a.attnum = s.staattnum)))) LEFT JOIN pg_namespace n ON ((n.oid = c.relnamespace))) WHERE has_table_privilege(c.oid, 'select'::text);

pg_stats | SELECT nspname AS schemaname, relname AS tablename, attname, stanullfrac AS null_frac, stawidth AS avg_width, stadistinct AS n_distinct, CASE WHEN (1 = stakind1) THEN stavalues1 WHEN (1 = stakind2) THEN stavalues2 WHEN (1 = stakind3) THEN stavalues3 WHEN (1 = stakind4) THEN stavalues4 ELSE NULL::anyarray END AS most_common_vals, CASE WHEN (1 = stakind1) THEN stanumbers1 WHEN (1 = stakind2) THEN stanumbers2 WHEN (1 = stakind3) THEN stanumbers3 WHEN (1 = stakind4) THEN stanumbers4 ELSE NULL::real[] END AS most_common_freqs, CASE WHEN (2 = stakind1) THEN stavalues1 WHEN (2 = stakind2) THEN stavalues2 WHEN (2 = stakind3) THEN stavalues3 WHEN (2 = stakind4) THEN stavalues4 ELSE NULL::anyarray END AS histogram_bounds, CASE WHEN (3 = stakind1) THEN stanumbers1[1] WHEN (3 = stakind2) THEN stanumbers2[1] WHEN (3 = stakind3) THEN stanumbers3[1] WHEN (3 = stakind4) THEN stanumbers4[1] ELSE NULL::real END AS correlation FROM (((pg_statistic s JOIN pg_class c ON ((c.oid = s.starelid))) JOIN pg_attribute a ON (((c.oid = a.attrelid) AND (a.attnum = s.staattnum)))) LEFT JOIN pg_namespace n ON ((n.oid = c.relnamespace))) WHERE has_table_privilege(c.oid, 'select'::text);

pg_tables | SELECT n.nspname AS schemaname, c.relname AS tablename, pg_get_userbyid(c.relowner) AS tableowner, c.relhasindex AS hasindexes, c.relhasrules AS hasrules, (c.reltriggers > 0) AS hastriggers FROM (pg_class c LEFT JOIN pg_namespace n ON ((n.oid = c.relnamespace))) WHERE ((c.relkind = 'r'::"char") OR (c.relkind = 's'::"char"));

pg_user | SELECT pg_shadow.usename, pg_shadow.usesysid, pg_shadow.usecreatedb, pg_shadow.usesuper, pg_shadow.usecatupd, '********'::text AS passwd, pg_shadow.valuntil, pg_shadow.useconfig FROM pg_shadow;

pg_views | SELECT n.nspname AS schemaname, c.relname AS viewname, pg_get_userbyid(c.relowner) AS viewowner, pg_get_viewdef(c.oid) AS definition FROM (pg_class c LEFT JOIN pg_namespace n ON ((n.oid = c.relnamespace))) WHERE (c.relkind = 'v'::"char");