pg_backend_pid() int Process ID of the server process attached to the current session pg_listening_channels() setof text channel names that the session is currently listening on inet_client_addr() inet address time. The command is: SET search_path TO schema [, schema, ...] pg_listening_channels returns a set of names of channels that the current session is listening to. See LISTEN for more information. inet_client_addr if the client applications are iso- lated from each other, but if the clients can communicate via channels outside the database then serious confusion might ensue. To ensure the current validity of a row

pg_is_other_temp_schema(oid) boolean is schema another session’s temporary schema? pg_listening_channels() setof text channel names that the session is currently listening on pg_my_temp_schema() oid OID time. The command is: SET search_path TO schema [, schema, ...] pg_listening_channels returns a set of names of channels that the current session is listening to. See LISTEN for more information. 308 LISTEN or UNLISTEN is executed within a transaction that later rolls back, the set of notification channels being listened to is unchanged. A transaction that has executed LISTEN cannot be prepared for two-phase

pg_backend_pid() int Process ID of the server process attached to the current session pg_listening_channels() setof text channel names that the session is currently listening on inet_client_addr() inet address time. The command is: SET search_path TO schema [, schema, ...] pg_listening_channels returns a set of names of channels that the current session is listening to. See LISTEN for more information. inet_client_addr if the client applications are isolated from each other, but if the clients can communicate via channels outside the database then serious confusion might ensue. To ensure the current validity of a row

pg_is_other_temp_schema(oid)boolean is schema another session’s temporary schema? pg_listening_channels() setof text channel names that the session is currently listening on pg_my_temp_schema() oid OID time. The command is: SET search_path TO schema [, schema, ...] pg_listening_channels returns a set of names of channels that the current session is listening to. See LISTEN for more information. inet_client_addr LISTEN or UNLISTEN is executed within a transaction that later rolls back, the set of notification channels being listened to is unchanged. A transaction that has executed LISTEN cannot be prepared for two-phase

pg_is_other_temp_schema(oid)boolean is schema another session’s temporary schema? pg_listening_channels() setof text channel names that the session is currently listening on pg_my_temp_schema() oid OID schema [, schema, ...] 307 Chapter 9. Functions and Operators pg_listening_channels returns a set of names of channels that the current session is listening to. See LISTEN for more information. inet_client_addr LISTEN or UNLISTEN is executed within a transaction that later rolls back, the set of notification channels being listened to is unchanged. A transaction that has executed LISTEN cannot be prepared for two-phase

pg_is_other_temp_schema(oid) boolean is schema another session’s temporary schema? pg_listening_channels() setof text channel names that the session is currently listening on pg_my_temp_schema() oid OID time. The command is: SET search_path TO schema [, schema, ...] pg_listening_channels returns a set of names of channels that the current session is listening to. See LISTEN for more information. inet_client_addr LISTEN or UNLISTEN is executed within a transaction that later rolls back, the set of notification channels being listened to is unchanged. A transaction that has executed LISTEN cannot be prepared for two-phase

pg_is_other_temp_schema(oid)boolean is schema another session’s temporary schema? pg_listening_channels() setof text channel names that the session is currently listening on pg_my_temp_schema() oid OID time. The command is: SET search_path TO schema [, schema, ...] pg_listening_channels returns a set of names of channels that the current session is listening to. See LISTEN for more information. inet_client_addr LISTEN or UNLISTEN is executed within a transaction that later rolls back, the set of notification channels being listened to is unchanged. A transaction that has executed LISTEN cannot be prepared for two-phase

pg_is_other_temp_schema(oid) boolean is schema another session’s temporary schema? pg_listening_channels() setof text channel names that the session is currently listening on pg_notification_queue_usage()double sessions’ temporary tables from a catalog display.) pg_listening_channels returns a set of names of asynchronous notification channels that the current session is listening to. pg_notification_queue_usage LISTEN or UNLISTEN is executed within a transaction that later rolls back, the set of notification channels being listened to is unchanged. A transaction that has executed LISTEN cannot be prepared for two-phase

pg_is_other_temp_schema(oid)boolean is schema another session’s temporary schema? pg_listening_channels() setof text channel names that the session is currently listening on pg_notification_queue_usage()double sessions’ temporary tables from a catalog display.) pg_listening_channels returns a set of names of asynchronous notification channels that the current session is listening to. pg_notification_queue_usage LISTEN or UNLISTEN is executed within a transaction that later rolls back, the set of notification channels being listened to is unchanged. A transaction that has executed LISTEN cannot be prepared for two-phase

pg_is_other_temp_schema(oid) boolean is schema another session’s temporary schema? pg_listening_channels() setof text channel names that the session is currently listening on pg_my_temp_schema() oid OID time. The command is: SET search_path TO schema [, schema, ...] pg_listening_channels returns a set of names of channels that the current session is listening to. See LISTEN for more information. inet_client_addr LISTEN or UNLISTEN is executed within a transaction that later rolls back, the set of notification channels being listened to is unchanged. A transaction that has executed LISTEN cannot be prepared for two-phase