Name
set_qualifier, cli_log_mode, log_text_array, explain_query_sources — session control and query/log administration helpers
Synopsis
integer set_qualifier(
|
in qualifier varchar); |
integer cli_log_mode(
|
); |
log_text_array(
|
in sql_text varchar, |
in params any); |
any explain_query_sources(
|
in sql_text varchar); |
Description
set_qualifier sets the default schema qualifier for
the current session. Subsequent unqualified table and procedure references
resolve against this qualifier. The argument must be a non-empty string;
an SQL error is raised for any other type. Returns an integer status.
cli_log_mode returns the transaction-log mode flags
of the current client connection. The value is a bitmask describing
whether the connection is logging row-level changes, autocommit logging,
replication settings, and similar operational state.
log_text_array appends an entry to the transaction
log consisting of an SQL text and a parameter array. When called with a
single argument the argument must already be the prepared vector of text
followed by parameters; when called with two arguments the text and
parameter vector are combined. This is primarily used by replication and
administrative procedures.
explain_query_sources compiles
sql_text without executing it and returns a vector
describing the tables, indexes and other schema objects referenced by the
resulting execution plan. Use it to discover the physical sources a query
would touch before running it.