<!-- $PostgreSQL: pgsql/doc/src/sgml/func.sgml,v 1.336 2006/09/10 19:03:57 tgl Exp $ -->

<!-- $PostgreSQL: pgsql/doc/src/sgml/func.sgml,v 1.337 2006/09/14 22:05:05 tgl Exp $ -->

<chapter id="functions">

<title>Functions and Operators</title>

<entry>port of the local connection</entry>

</row>

<row>

<entry><literal><function>pg_my_temp_schema</function>()</literal></entry>

<entry><type>oid</type></entry>

<entry>OID of session's temporary schema, or 0 if none</entry>

</row>

<row>

<entry><literal><function>pg_is_other_temp_schema</function>(<type>oid</type>)</literal></entry>

<entry><type>boolean</type></entry>

<entry>is schema another session's temporary schema?</entry>

</row>

<row>

<entry><literal><function>pg_postmaster_start_time</function>()</literal></entry>

<entry><type>timestamp with time zone</type></entry>

Unix-domain socket.

</para>

<indexterm zone="functions-info">

<primary>pg_my_temp_schema</primary>

</indexterm>

<indexterm zone="functions-info">

<primary>pg_is_other_temp_schema</primary>

</indexterm>

<para>

<function>pg_my_temp_schema</function> returns the OID of the current

session's temporary schema, or 0 if it has none (because it has not

created any temporary tables).

<function>pg_is_other_temp_schema</function> returns true if the

given OID is the OID of any other session's temporary schema.

(This can be useful, for example, to exclude other sessions' temporary

tables from a catalog display.)

</para>

<indexterm zone="functions-info">

<primary>pg_postmaster_start_time</primary>

</indexterm>

WHEREa.attrelid=c.oid

ANDa.atttypid=t.oid

ANDnc.oid=c.relnamespace

AND (nc.nspname NOTLIKE'pg!_temp!_%' ESCAPE'!'ORpg_catalog.pg_table_is_visible(c.oid))

AND (NOT pg_is_other_temp_schema(nc.oid))

ANDa.attnum>0AND NOTa.attisdroppedANDc.relkindin ('r','v')

AND (pg_has_role(c.relowner,'USAGE')

ANDnc.oid=c.connamespace

ANDc.contypeIN ('p','u','f')

ANDr.relkind='r'

AND (nr.nspnameNOTLIKE'pg!_temp!_%' ESCAPE'!'ORpg_catalog.pg_table_is_visible(r.oid))

AND (NOTpg_is_other_temp_schema(nr.oid))

AND (pg_has_role(r.relowner,'USAGE')

OR has_table_privilege(c.oid,'SELECT')

OR has_table_privilege(c.oid,'INSERT')

FROM pg_namespace nc, pg_class c

WHEREc.relnamespace=nc.oid

ANDc.relkind='S'

AND (nc.nspnameNOTLIKE'pg!_temp!_%' ESCAPE'!'ORpg_catalog.pg_table_is_visible(c.oid))

AND (NOTpg_is_other_temp_schema(nc.oid))

AND (pg_has_role(c.relowner,'USAGE')

OR has_table_privilege(c.oid,'SELECT')

OR has_table_privilege(c.oid,'UPDATE') );

WHEREnc.oid=c.connamespaceANDnr.oid=r.relnamespace

ANDc.conrelid=r.oid

ANDr.relkind='r'

AND (nr.nspnameNOTLIKE'pg!_temp!_%' ESCAPE'!'ORpg_catalog.pg_table_is_visible(r.oid))

AND (NOTpg_is_other_temp_schema(nr.oid))

AND (pg_has_role(r.relowner,'USAGE')

OR has_table_privilege(r.oid,'INSERT')

ANDa.attnum>0

AND NOTa.attisdropped

ANDr.relkind='r'

AND (nr.nspnameNOTLIKE'pg!_temp!_%' ESCAPE'!'ORpg_catalog.pg_table_is_visible(r.oid))

AND (NOTpg_is_other_temp_schema(nr.oid))

AND (pg_has_role(r.relowner,'USAGE')

OR has_table_privilege(r.oid,'SELECT')

OR has_table_privilege(r.oid,'INSERT')

CAST(c.relnameAS sql_identifier)AS table_name,

CAST(

CASE WHENnc.nspnameLIKE'pg!_temp!_%' ESCAPE'!' THEN'LOCAL TEMPORARY'

CASE WHENnc.oid= pg_my_temp_schema() THEN'LOCAL TEMPORARY'

WHENc.relkind='r' THEN'BASE TABLE'

WHENc.relkind='v' THEN'VIEW'

ELSEnull END

THEN'YES' ELSE'NO' ENDAS character_data)AS is_insertable_into,

CAST('NO'AS character_data)AS is_typed,

CAST(

CASE WHENnc.nspnameLIKE'pg!_temp!_%' ESCAPE'!'THEN'PRESERVE'

CASE WHENnc.oid= pg_my_temp_schema()THEN'PRESERVE'-- FIXME

ELSEnull END

AS character_data)AS commit_action

FROM pg_namespace nc, pg_class c

WHEREc.relnamespace=nc.oid

ANDc.relkindIN ('r','v')

AND (nc.nspnameNOTLIKE'pg!_temp!_%' ESCAPE'!'ORpg_catalog.pg_table_is_visible(c.oid))

AND (NOTpg_is_other_temp_schema(nc.oid))

AND (pg_has_role(c.relowner,'USAGE')

OR has_table_privilege(c.oid,'SELECT')

OR has_table_privilege(c.oid,'INSERT')

ANDc.oid=t.tgrelid

ANDt.tgtype &em.num<>0

AND NOTt.tgisconstraint

AND (n.nspnameNOTLIKE'pg!_temp!_%' ESCAPE'!'ORpg_catalog.pg_table_is_visible(c.oid))

AND (NOTpg_is_other_temp_schema(n.oid))

AND (pg_has_role(c.relowner,'USAGE')

OR has_table_privilege(c.oid,'INSERT')

WHEREc.relnamespace=nc.oid

ANDc.relkind='v'

AND (nc.nspnameNOTLIKE'pg!_temp!_%' ESCAPE'!'ORpg_catalog.pg_table_is_visible(c.oid))

AND (NOTpg_is_other_temp_schema(nc.oid))

AND (pg_has_role(c.relowner,'USAGE')

OR has_table_privilege(c.oid,'SELECT')

OR has_table_privilege(c.oid,'INSERT')

Datumpg_operator_is_visible(PG_FUNCTION_ARGS);

Datumpg_opclass_is_visible(PG_FUNCTION_ARGS);

Datumpg_conversion_is_visible(PG_FUNCTION_ARGS);

Datumpg_my_temp_schema(PG_FUNCTION_ARGS);

Datumpg_is_other_temp_schema(PG_FUNCTION_ARGS);

PG_RETURN_BOOL(ConversionIsVisible(oid));

}

pg_my_temp_schema(PG_FUNCTION_ARGS)

{

PG_RETURN_OID(myTempNamespace);

}

pg_is_other_temp_schema(PG_FUNCTION_ARGS)

{

Oidoid=PG_GETARG_OID(0);

PG_RETURN_BOOL(isOtherTempNamespace(oid));

}

DESCR("is opclass visible in search path?");

DATA(insertOID=2093 (pg_conversion_is_visiblePGNSPPGUID12fftfs116"26"_null__null__null_pg_conversion_is_visible-_null_ ));

DESCR("is conversion visible in search path?");

DATA(insertOID=2854 (pg_my_temp_schemaPGNSPPGUID12fftfs026""_null__null__null_pg_my_temp_schema-_null_ ));

DESCR("get OID of current session's temp schema, if any");

DATA(insertOID=2855 (pg_is_other_temp_schemaPGNSPPGUID12fftfs116"26"_null__null__null_pg_is_other_temp_schema-_null_ ));

DESCR("is schema another session's temp schema?");

DATA(insertOID=2171 (pg_cancel_backendPGNSPPGUID12fftfv116"23"_null__null__null_pg_cancel_backend-_null_ ));

DESCR("Cancel a server process' current query");