All Classes and Interfaces
Class
Description
Convenience class whose member classes will provide APIs that in some way
adjust aspects of PL/Java's behavior.
Class that collects adjustment APIs for affecting the behavior of
PL/Java's XML support.
Adjusting version of a
DOMSource.Interface with methods to adjust the restrictions on XML parsing
that are commonly considered when XML content might be from untrusted
sources.
Adjusting version of
javax.xml.transform.Result, offering
the adjustment methods of Adjusting.XML.Parsing, chiefly so that
there is a way to apply those adjustments to any implicitly-created
parser used to verify the content that will be written to the
Result.Adjusting version of a
SAXResult.Adjusting version of a
SAXSource.A functional interface fitting various
setFeature or
setProperty methods in Java XML APIs.Adjusting version of
javax.xml.transform.Source, allowing
various parser features to be configured before calling
get() to obtain the usable Source object.Specialized
Result type for setting a new PL/Java
SQLXML instance's content from an arbitrary Source
object of any of the types JDBC requires the SQLXML type
to support.Adjusting version of a
StAXSource.Adjusting version of a
StreamResult.Declares a PostgreSQL aggregate.
Declares the effect of the
finish function in a Plan.Specifies one "plan" for evaluating the aggregate; one must always be
specified (as
plan), and a second may be specified (as
movingPlan).Annotation on a PL/Java class to form a User Defined Type that will
become a new PostgreSQL base type.
The supported alignment constraints for the type's internal
representation.
The type categories that are predefined in PostgreSQL.
Character constants corresponding to the predefined categories,
for use in the
BaseUDT.category() annotation element.The supported TOAST strategies for the type's stored representation.
Declares a PostgreSQL
CAST.When this cast can be applied: only in explicit form, when used in
assignment context, or implicitly whenever needed.
A known conversion path when a dedicated function is not supplied:
BINARY for two types that are known to have the same internal
representation, or INOUT to invoke the first type's text-output
function followed by the second type's text-input function.Annotates a Java method for which an SQL function declaration should be
generated into the deployment descriptor file.
The volatility
category
describing the presence or absence of side-effects constraining what
the optimizer can safely do with the function.
Whether the function is called even for null input,
or known to return null in that case and therefore not called.
Whether the function is unsafe to use in any parallel query plan at all,
or avoids certain operations and can appear in such a plan but must be
executed only in the parallel group leader, or avoids an even larger
set of operations and is safe to execute anywhere in a parallel plan.
Whether the function executes with the same identity and
permissions as the role that has invoked it (the usual case), or
with the rights of the role that defined it (such as to
offer controlled access to data the invoker would otherwise have
no access to).
Whether the function only needs limited capabilities and can
run in the "trusted" language sandbox, or has to be unsandboxed
and run in an "untrusted" language instance.
A few useful SQL lexical definitions supplied as
Pattern objects.Class representing a SQL identifier.
Class representing an Identifier that names a PostgreSQL operator.
Displays/deparses like a
Simple identifier, but no singleton
of this class matches anything but itself, to represent
pseudo-identifiers like PUBLIC as a privilege grantee.Class representing a schema-qualified identifier.
Class representing an unqualified identifier in the form of a name
(whether a case-insensitive "regular identifier" without quotes,
or a delimited form).
Annotation on a PL/Java class that will either map an existing PostgreSQL
type (provided its internal storage form is well understood), or create and
map a new PostgreSQL composite type
(a/k/a "structured type" in the standards).
A pool of objects of a single class.
Declares a PostgreSQL
OPERATOR.Names of several functions predefined in PostgreSQL for estimating the
selectivity of operators in restriction clauses or joins.
Java
Principal representing a PostgreSQL PROCEDURAL LANGUAGE,
which has a name (a simple identifier, not schema-qualified) and is either
Sandboxed (declared with SQL CREATE TRUSTED LANGUAGE or
Unsandboxed.Java
Principal representing a PostgreSQL
PROCEDURAL LANGUAGE that was declared with the TRUSTED
keyword and can be used to declare new functions by any role that has
been granted USAGE permission on it.Java
Principal representing a PostgreSQL
PROCEDURAL LANGUAGE that was declared without the
TRUSTED keyword, and can be used to declare new functions only
by a PostgreSQL superuser.Interface for objects that are pooled and reused.
An implementation of this interface is returned from functions and procedures
that are declared to return
SET OF a complex type in the form
of a ResultSet.An implementation of this interface is returned from functions and procedures
that are declared to return
SET OF a complex type.Version of
ResultSetProvider where the assignRowValues
method accepting a long row count must be implemented, and the
int version defaults to using it.Interface for a listener to be notified of the start and pre-commit, commit,
or abort of savepoints.
A Session brings together some useful methods and data for the current
database session.
The SessionManager makes the current
Session available to the
caller.Annotation that supplies verbatim commands to be copied into the
deployment descriptor.
Container for multiple
SQLAction annotations (in case it is
convenient to hang more than one on a given program element).Optionally annotates a Java method parameter, to supply an explicit
SQL type for use in the SQL function declaration in place of the
automatically mapped type, and/or to supply an SQL default value.
Interface for a listener to be notified of prepare, and commit, abort,
or other phase transitions, of distributed transactions.
Annotation, only used in
@Function(triggers=...),
to specify what trigger(s) the function will be called for.Whether the trigger is invoked before or after the specified event.
Deferrability (only applies to constraint triggers).
Types of event that can occasion a trigger.
Whether the trigger will occur only once for a statement of interest,
or once for each row affected by the statement.
The data passed to an ordinary (insert/update/delete/truncate) trigger
function.
An exception specially suited to be thrown from within a method
designated to be a trigger function.