A B C D E F G H I J L M N O P Q R S T U V W X
All Classes All Packages
All Classes All Packages
All Classes All Packages
A
- accessExternalDTD(String) - Method in interface org.postgresql.pljava.Adjusting.XML.Parsing
-
Protocol schemes allowed in the URL of an external DTD to be fetched.
- accessExternalSchema(String) - Method in interface org.postgresql.pljava.Adjusting.XML.Parsing
-
Protocol schemes allowed in the URL of an external schema to be fetched.
- accumulate() - Method in annotation type org.postgresql.pljava.annotation.Aggregate.Plan
-
Name of the function that will be called for each row being aggregated.
- activate() - Method in interface org.postgresql.pljava.PooledObject
-
The activate method is called when the instance is activated from its "passive" state.
- activateInstance() - Method in interface org.postgresql.pljava.ObjectPool
-
Obtain a pooled object, calling its
PooledObject.activate()
method. - addSavepointListener(SavepointListener) - Method in interface org.postgresql.pljava.Session
-
Adds the specified
listener
to the list of listeners that will receive savepoint events. - addTransactionListener(TransactionListener) - Method in interface org.postgresql.pljava.Session
-
Adds the specified
listener
to the list of listeners that will receive transaction events. - Adjusting - Class in org.postgresql.pljava
-
Convenience class whose member classes will provide APIs that in some way adjust aspects of PL/Java's behavior.
- Adjusting.XML - Class in org.postgresql.pljava
-
Class that collects adjustment APIs for affecting the behavior of PL/Java's XML support.
- Adjusting.XML.DOMSource - Interface in org.postgresql.pljava
-
Adjusting version of a
DOMSource
. - Adjusting.XML.Parsing<T extends Adjusting.XML.Parsing<T>> - Interface in org.postgresql.pljava
-
Interface with methods to adjust the restrictions on XML parsing that are commonly considered when XML content might be from untrusted sources.
- Adjusting.XML.Result<T extends Result> - Interface in org.postgresql.pljava
-
Adjusting version of
javax.xml.transform.Result
, offering the adjustment methods ofAdjusting.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 theResult
. - Adjusting.XML.SAXResult - Interface in org.postgresql.pljava
-
Adjusting version of a
SAXResult
. - Adjusting.XML.SAXSource - Interface in org.postgresql.pljava
-
Adjusting version of a
SAXSource
. - Adjusting.XML.SetMethod<T> - Interface in org.postgresql.pljava
-
A functional interface fitting various
setFeature
orsetProperty
methods in Java XML APIs. - Adjusting.XML.Source<T extends Source> - Interface in org.postgresql.pljava
-
Adjusting version of
javax.xml.transform.Source
, allowing various parser features to be configured before callingget()
to obtain the usableSource
object. - Adjusting.XML.SourceResult - Interface in org.postgresql.pljava
-
Specialized
Result
type for setting a new PL/JavaSQLXML
instance's content from an arbitrarySource
object of any of the types JDBC requires theSQLXML
type to support. - Adjusting.XML.StAXSource - Interface in org.postgresql.pljava
-
Adjusting version of a
StAXSource
. - Adjusting.XML.StreamResult - Interface in org.postgresql.pljava
-
Adjusting version of a
StreamResult
. - AFTER - org.postgresql.pljava.annotation.Trigger.Called
- Aggregate - Annotation Type in org.postgresql.pljava.annotation
-
Declares a PostgreSQL aggregate.
- Aggregate.FinishEffect - Enum in org.postgresql.pljava.annotation
-
Declares the effect of the
finish
function in aPlan
. - Aggregate.Plan - Annotation Type in org.postgresql.pljava.annotation
-
Specifies one "plan" for evaluating the aggregate; one must always be specified (as
plan
), and a second may be specified (asmovingPlan
). - alignment() - Method in annotation type org.postgresql.pljava.annotation.BaseUDT
-
Alignment constraint for the type in memory.
- allowDTD(boolean) - Method in interface org.postgresql.pljava.Adjusting.XML.Parsing
-
Whether to allow a DTD at all.
- analyze() - Method in annotation type org.postgresql.pljava.annotation.BaseUDT
-
Name, possibly schema-qualified, of a function to gather custom statistics for this type.
- application() - Method in annotation type org.postgresql.pljava.annotation.Cast
-
When this cast can be applied: only in explicit form, when used in assignment context, or implicitly whenever needed.
- AREAJOINSEL - Static variable in interface org.postgresql.pljava.annotation.Operator.SelectivityEstimators
-
A join-selectivity estimator suitable for an operator doing 2-D area-based comparisons.
- arguments() - Method in annotation type org.postgresql.pljava.annotation.Aggregate
-
Names and types of the arguments to be aggregated: the ones passed to the
accumulate
function for each aggregated row. - arguments() - Method in annotation type org.postgresql.pljava.annotation.Trigger
-
Arguments to be passed to the trigger function.
- ARRAY - org.postgresql.pljava.annotation.BaseUDT.PredefinedCategory
- ARRAY - Static variable in interface org.postgresql.pljava.annotation.BaseUDT.PredefinedCategory.Code
- ASSIGNMENT - org.postgresql.pljava.annotation.Cast.Application
- assignRowValues(ResultSet, int) - Method in interface org.postgresql.pljava.ResultSetProvider
-
Older version where currentRow is limited to the range of
int
. - assignRowValues(ResultSet, int) - Method in interface org.postgresql.pljava.ResultSetProvider.Large
- assignRowValues(ResultSet, long) - Method in interface org.postgresql.pljava.ResultSetProvider
-
This method is called once for each row that should be returned from a procedure that returns a set of rows.
- assignRowValues(ResultSet, long) - Method in interface org.postgresql.pljava.ResultSetProvider.Large
-
This method is called once for each row that should be returned from a procedure that returns a set of rows.
B
- BaseUDT - Annotation Type in org.postgresql.pljava.annotation
-
Annotation on a PL/Java class to form a User Defined Type that will become a new PostgreSQL base type.
- BaseUDT.Alignment - Enum in org.postgresql.pljava.annotation
-
The supported alignment constraints for the type's internal representation.
- BaseUDT.PredefinedCategory - Enum in org.postgresql.pljava.annotation
-
The type categories that are predefined in PostgreSQL.
- BaseUDT.PredefinedCategory.Code - Interface in org.postgresql.pljava.annotation
-
Character constants corresponding to the predefined categories, for use in the
BaseUDT.category()
annotation element. - BaseUDT.Storage - Enum in org.postgresql.pljava.annotation
-
The supported TOAST strategies for the type's stored representation.
- BEFORE - org.postgresql.pljava.annotation.Trigger.Called
- BINARY - org.postgresql.pljava.annotation.Cast.Path
- BITSTRING - org.postgresql.pljava.annotation.BaseUDT.PredefinedCategory
- BITSTRING - Static variable in interface org.postgresql.pljava.annotation.BaseUDT.PredefinedCategory.Code
- BOOLEAN - org.postgresql.pljava.annotation.BaseUDT.PredefinedCategory
- BOOLEAN - Static variable in interface org.postgresql.pljava.annotation.BaseUDT.PredefinedCategory.Code
- BRACKETED_COMMENT_INSIDE - Static variable in class org.postgresql.pljava.sqlgen.Lexicals
-
Most of the inside of a bracketed comment, defined in an odd way.
C
- called() - Method in annotation type org.postgresql.pljava.annotation.Trigger
-
Denotes if the trigger is fired before, after, or instead of its scope (row or statement)
- CALLED - org.postgresql.pljava.annotation.Function.OnNullInput
- Cast - Annotation Type in org.postgresql.pljava.annotation
-
Declares a PostgreSQL
CAST
. - Cast.Application - Enum in org.postgresql.pljava.annotation
-
When this cast can be applied: only in explicit form, when used in assignment context, or implicitly whenever needed.
- Cast.Path - Enum in org.postgresql.pljava.annotation
-
A known conversion path when a dedicated function is not supplied:
BINARY
for two types that are known to have the same internal representation, orINOUT
to invoke the first type's text-output function followed by the second type's text-input function. - category() - Method in annotation type org.postgresql.pljava.annotation.BaseUDT
-
A category for this type, influencing PostgreSQL's choices for implicit type conversion.
- CHAR - org.postgresql.pljava.annotation.BaseUDT.Alignment
- close() - Method in interface org.postgresql.pljava.ResultSetHandle
-
Called after the last row has returned or when the query evaluator decides that it does not need any more rows.
- close() - Method in interface org.postgresql.pljava.ResultSetProvider
-
Called after the last row has returned or when the query evaluator decides that it does not need any more rows.
- code() - Method in enum org.postgresql.pljava.annotation.BaseUDT.PredefinedCategory
-
Return this category's single-character code.
- collatable() - Method in annotation type org.postgresql.pljava.annotation.BaseUDT
-
If true, indicates that column definitions or expressions of this type may carry a
COLLATE
clause. - columns() - Method in annotation type org.postgresql.pljava.annotation.Trigger
-
A list of columns (only meaningful for an UPDATE trigger).
- combine() - Method in annotation type org.postgresql.pljava.annotation.Aggregate.Plan
-
Name of an optional function to combine two instances of the state type.
- comment() - Method in annotation type org.postgresql.pljava.annotation.Aggregate
-
A comment to be associated with the aggregate.
- comment() - Method in annotation type org.postgresql.pljava.annotation.BaseUDT
-
A comment to be associated with the type.
- comment() - Method in annotation type org.postgresql.pljava.annotation.Cast
-
A comment to be associated with the cast.
- comment() - Method in annotation type org.postgresql.pljava.annotation.Function
-
A comment to be associated with the SQL function.
- comment() - Method in annotation type org.postgresql.pljava.annotation.MappedUDT
-
A comment to be associated with the type.
- comment() - Method in annotation type org.postgresql.pljava.annotation.Operator
-
A comment to be associated with the operator.
- comment() - Method in annotation type org.postgresql.pljava.annotation.Trigger
-
A comment to be associated with the trigger.
- commutator() - Method in annotation type org.postgresql.pljava.annotation.Operator
-
Name of an operator that is the commutator of this one.
- COMPOSITE - org.postgresql.pljava.annotation.BaseUDT.PredefinedCategory
- COMPOSITE - Static variable in interface org.postgresql.pljava.annotation.BaseUDT.PredefinedCategory.Code
- concat(Object...) - Method in class org.postgresql.pljava.sqlgen.Lexicals.Identifier.Simple
-
Concatenates one or more strings or identifiers to the end of this identifier.
- constraint() - Method in annotation type org.postgresql.pljava.annotation.Trigger
-
Only for a constraint trigger, whether it is deferrable and, if so, initially immediate or deferred.
- CONTJOINSEL - Static variable in interface org.postgresql.pljava.annotation.Operator.SelectivityEstimators
-
A join-selectivity estimator suitable for an operator doing 2-D containment-based comparisons.
- cost() - Method in annotation type org.postgresql.pljava.annotation.Function
-
Estimated cost in units of cpu_operator_cost.
- current() - Static method in class org.postgresql.pljava.SessionManager
-
Returns the current session.
D
- DATETIME - org.postgresql.pljava.annotation.BaseUDT.PredefinedCategory
- DATETIME - Static variable in interface org.postgresql.pljava.annotation.BaseUDT.PredefinedCategory.Code
- defaults() - Method in interface org.postgresql.pljava.Adjusting.XML.Parsing
-
Makes a best effort to apply the recommended, restrictive defaults from the OWASP cheat sheet, to the extent they are supported by the underlying parser, runtime, and version.
- defaultValue() - Method in annotation type org.postgresql.pljava.annotation.BaseUDT
-
A default value for attributes declared to be of this type.
- defaultValue() - Method in annotation type org.postgresql.pljava.annotation.SQLType
-
Default value for the parameter.
- DEFINER - org.postgresql.pljava.annotation.Function.Security
- DELETE - org.postgresql.pljava.annotation.Trigger.Event
- delimiter() - Method in annotation type org.postgresql.pljava.annotation.BaseUDT
-
Delimiter character to be used between elements when the generic array routines output an array with this new type as its element type.
- deparse(Charset) - Method in class org.postgresql.pljava.sqlgen.Lexicals.Identifier
-
This Identifier represented as it would be in SQL source.
- deparse(Charset) - Method in class org.postgresql.pljava.sqlgen.Lexicals.Identifier.Operator
- deparse(Charset) - Method in class org.postgresql.pljava.sqlgen.Lexicals.Identifier.Qualified
- deparse(Charset) - Method in class org.postgresql.pljava.sqlgen.Lexicals.Identifier.Simple
- deparse(Lexicals.Identifier.Simple, Charset) - Method in class org.postgresql.pljava.sqlgen.Lexicals.Identifier.Operator
- deparse(Lexicals.Identifier.Simple, Charset) - Method in class org.postgresql.pljava.sqlgen.Lexicals.Identifier.Simple
- deparse(Lexicals.Identifier.Simple, Charset) - Method in class org.postgresql.pljava.sqlgen.Lexicals.Identifier.Unqualified
-
Produce the deparsed form of a qualified identifier with the given qualifier and this as the local part.
- deserialize() - Method in annotation type org.postgresql.pljava.annotation.Aggregate.Plan
-
Name of a deserializing function ((
bytea
,internal
) tointernal
), usable only if aserialize
function is also specified. - directArguments() - Method in annotation type org.postgresql.pljava.annotation.Aggregate
-
Names and types of the "direct arguments" to an ordered-set or hypothetical-set aggregate (specifying this element is what makes an ordered-set aggregate, which will be a hypothetical-set aggregate if
hypothetical=true
is also supplied). - DOUBLE - org.postgresql.pljava.annotation.BaseUDT.Alignment
E
- effects() - Method in annotation type org.postgresql.pljava.annotation.Function
-
What the query optimizer is allowed to assume about this function.
- element() - Method in annotation type org.postgresql.pljava.annotation.BaseUDT
-
Name, possibly schema-qualified, of an existing type to be accessible by subscripting this new type as if it were an array (only with zero-based indexing instead of one-based).
- elementAttributeLimit(int) - Method in interface org.postgresql.pljava.Adjusting.XML.Parsing
-
Maximum number of attributes on an element, with a negative or zero value indicating no limit.
- entityExpansionLimit(int) - Method in interface org.postgresql.pljava.Adjusting.XML.Parsing
-
Maximum number of entity expansions, with a negative or zero value indicating no limit.
- entityReplacementLimit(int) - Method in interface org.postgresql.pljava.Adjusting.XML.Parsing
-
Limit on total number of nodes in all entity referenced, with a negative or zero value indicating no limit.
- entityResolver(EntityResolver) - Method in interface org.postgresql.pljava.Adjusting.XML.Parsing
-
Sets an
EntityResolver
of the type used by SAX and DOM (optional operation). - ENUM - org.postgresql.pljava.annotation.BaseUDT.PredefinedCategory
- ENUM - Static variable in interface org.postgresql.pljava.annotation.BaseUDT.PredefinedCategory.Code
- EQJOINSEL - Static variable in interface org.postgresql.pljava.annotation.Operator.SelectivityEstimators
-
A join-selectivity estimator suitable for an operator with rather high selectivity typical of an operator like
=
. - EQSEL - Static variable in interface org.postgresql.pljava.annotation.Operator.SelectivityEstimators
-
A restriction-selectivity estimator suitable for an operator with rather high selectivity typical of an operator like
=
. - equals(Object) - Method in class org.postgresql.pljava.sqlgen.Lexicals.Identifier
-
Equality test with the case-sensitivity rules of SQL.
- equals(Object) - Method in class org.postgresql.pljava.sqlgen.Lexicals.Identifier.Pseudo
-
A
Pseudo
identifier instance is only equal to itself. - equals(Object, Messager) - Method in class org.postgresql.pljava.sqlgen.Lexicals.Identifier
-
For use in an annotation processor, a version of
equals
that can take aMessager
and use it to emit warnings. - equals(Object, Messager) - Method in class org.postgresql.pljava.sqlgen.Lexicals.Identifier.Operator
- equals(Object, Messager) - Method in class org.postgresql.pljava.sqlgen.Lexicals.Identifier.Qualified
- equals(Object, Messager) - Method in class org.postgresql.pljava.sqlgen.Lexicals.Identifier.Simple
- events() - Method in annotation type org.postgresql.pljava.annotation.Trigger
-
The event(s) that will trigger the call.
- executeAsOuterUser(Connection, String) - Method in interface org.postgresql.pljava.Session
-
Execute a statement as the outer user rather than the effective user.
- executeAsSessionUser(Connection, String) - Method in interface org.postgresql.pljava.Session
-
Deprecated, for removal: This API element is subject to removal in a future version.As of 1.5.0, this method is retained only for compatibility with old code, and has the same effect as
executeAsOuterUser
, which should be used instead. Previously, it used the session ID unconditionally, which is incorrect for any PostgreSQL version newer than 8.0, because it was unaware ofSET ROLE
introduced in 8.1. Any actual use case for a method that ignores roles and uses only the session ID should be reported as an issue. - expandEntityReferences(boolean) - Method in interface org.postgresql.pljava.Adjusting.XML.Parsing
-
Whether to expand entity references in the document to their declared replacement content.
- EXPLICIT - org.postgresql.pljava.annotation.Cast.Application
- EXTENDED - org.postgresql.pljava.annotation.BaseUDT.Storage
-
Can be compressed, and moved out-of-line if still too big.
- EXTERNAL - org.postgresql.pljava.annotation.BaseUDT.Storage
-
Can be moved out-of-line but not compressed.
- externalGeneralEntities(boolean) - Method in interface org.postgresql.pljava.Adjusting.XML.Parsing
-
Whether to retrieve external "general" entities (those that can be used in the document body) declared in the DTD.
- externalParameterEntities(boolean) - Method in interface org.postgresql.pljava.Adjusting.XML.Parsing
-
Whether to retrieve external "parameter" entities (those declared with a
%
and usable only within the DTD) declared in the DTD.
F
- finish() - Method in annotation type org.postgresql.pljava.annotation.Aggregate.Plan
-
Name of an optional function to produce the aggregate's result from the final value of the state; without this function, the aggregate's result type is the state type, and the result is simply the final value of the state.
- finishEffect() - Method in annotation type org.postgresql.pljava.annotation.Aggregate.Plan
-
The effect of the
finish
function in thisPlan
. - folds() - Method in class org.postgresql.pljava.sqlgen.Lexicals.Identifier.Simple
-
Whether this Identifier case-folds.
- from() - Method in annotation type org.postgresql.pljava.annotation.Cast
-
The source type to be cast.
- from() - Method in annotation type org.postgresql.pljava.annotation.Trigger
-
The name of another table referenced by the constraint.
- from(String) - Static method in class org.postgresql.pljava.sqlgen.Lexicals.Identifier.Operator
-
Create an
Identifier.Operator
from a name string. - from(String, boolean) - Static method in class org.postgresql.pljava.sqlgen.Lexicals.Identifier.Simple
-
Create an
Identifier.Simple
given its original, non-folded spelling, and whether it represents a quoted identifier. - from(String, Messager) - Static method in class org.postgresql.pljava.sqlgen.Lexicals.Identifier.Operator
-
Create an
Identifier.Operator
from a name string. - fromCatalog(String) - Static method in class org.postgresql.pljava.sqlgen.Lexicals.Identifier.Simple
-
Create an
Identifier.Simple
from a name string found in a PostgreSQL system catalog. - fromJava(String) - Static method in class org.postgresql.pljava.sqlgen.Lexicals.Identifier.Simple
-
Create an
Identifier.Simple
from a name string supplied in Java source, such as an annotation value. - fromJava(String, Messager) - Static method in class org.postgresql.pljava.sqlgen.Lexicals.Identifier.Simple
-
Create an
Identifier.Simple
from a name string supplied in Java source, such as an annotation value. - fromSchema() - Method in annotation type org.postgresql.pljava.annotation.Trigger
-
The schema containing another table referenced by the constraint.
- function() - Method in annotation type org.postgresql.pljava.annotation.Operator
-
Name of the function backing the operator; may be omitted if this annotation appears on a method.
- Function - Annotation Type in org.postgresql.pljava.annotation
-
Annotates a Java method for which an SQL function declaration should be generated into the deployment descriptor file.
- Function.Effects - Enum in org.postgresql.pljava.annotation
-
The volatility category describing the presence or absence of side-effects constraining what the optimizer can safely do with the function.
- Function.OnNullInput - Enum in org.postgresql.pljava.annotation
-
Whether the function is called even for null input, or known to return null in that case and therefore not called.
- Function.Parallel - Enum in org.postgresql.pljava.annotation
-
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.
- Function.Security - Enum in org.postgresql.pljava.annotation
-
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).
- Function.Trust - Enum in org.postgresql.pljava.annotation
-
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.
G
- GEOMETRIC - org.postgresql.pljava.annotation.BaseUDT.PredefinedCategory
- GEOMETRIC - Static variable in interface org.postgresql.pljava.annotation.BaseUDT.PredefinedCategory.Code
- get() - Method in interface org.postgresql.pljava.Adjusting.XML.Result
-
Returns an object of the expected
Result
subtype reflecting any adjustments made with the other methods. - get() - Method in interface org.postgresql.pljava.Adjusting.XML.Source
-
Returns an object of the expected
Source
subtype reflecting any adjustments made with the other methods. - getArguments() - Method in interface org.postgresql.pljava.TriggerData
-
Returns the arguments for this trigger (as declared in the
CREATE TRIGGER
statement. - getAttribute(String) - Method in interface org.postgresql.pljava.Session
-
Deprecated, for removal: This API element is subject to removal in a future version.
Session
's attribute store once had a special, and possibly useful, transactional behavior, but since PL/Java 1.2.0 it has lacked that, and offers nothing you don't get with an ordinaryMap
(that forbids nulls). If some kind of store with transactional behavior is needed, it should be implemented in straight Java and kept in sync by using aTransactionListener
. - getName() - Method in interface org.postgresql.pljava.TriggerData
-
Returns the name of the trigger (as declared in the
CREATE TRIGGER
statement). - getNew() - Method in interface org.postgresql.pljava.TriggerData
-
Returns the ResultSet that represents the new row.
- getObjectPool(Class<T>) - Method in interface org.postgresql.pljava.Session
-
Return an object pool for the given class.
- getOld() - Method in interface org.postgresql.pljava.TriggerData
-
Returns the ResultSet that represents the old row.
- getOuterUserName() - Method in interface org.postgresql.pljava.Session
-
Return the outer database user name.
- getResultSet() - Method in interface org.postgresql.pljava.ResultSetHandle
-
An implementation of this method will probably execute a query and return the result of that query.
- getSchemaName() - Method in interface org.postgresql.pljava.TriggerData
-
Returns the name of the schema of the table for which this trigger was created (as declared in the
CREATE TRIGGER
statement). - getSessionUserName() - Method in interface org.postgresql.pljava.Session
-
Deprecated, for removal: This API element is subject to removal in a future version.As of 1.5.0, this method is retained only for compatibility with old code, and returns the same value as
getOuterUserName
, which should be used instead. Previously, it returned the session ID unconditionally, which is incorrect for any PostgreSQL version newer than 8.0, because it was unaware ofSET ROLE
introduced in 8.1. Any actual use case for a method that ignores roles and reports only the session ID should be reported as an issue. - getSQLXML() - Method in interface org.postgresql.pljava.Adjusting.XML.SourceResult
-
Returns the result
SQLXML
instance ready for handing off to PostgreSQL. - getTableName() - Method in interface org.postgresql.pljava.TriggerData
-
Returns the name of the table for which this trigger was created (as declared in the
CREATE TRIGGER
statement). - getUserName() - Method in interface org.postgresql.pljava.Session
-
Return the current effective database user name.
H
- hashCode() - Method in class org.postgresql.pljava.sqlgen.Lexicals.Identifier.Operator
-
Returns a hash code value for the object.
- hashCode() - Method in class org.postgresql.pljava.sqlgen.Lexicals.Identifier.Qualified
-
Combines the hash codes of the qualifier and local part.
- hashCode() - Method in class org.postgresql.pljava.sqlgen.Lexicals.Identifier.Simple
-
For a quoted identifier that could not match any non-quoted one, the hash code of its non-folded spelling is good enough.
- hashes() - Method in annotation type org.postgresql.pljava.annotation.Operator
-
Whether this operator can be used in computing a hash join.
- hypothetical() - Method in annotation type org.postgresql.pljava.annotation.Aggregate
-
Specify
true
in an ordered-set aggregate (one withdirectArguments
specified) to make it a hypothetical-set aggregate.
I
- identifierFrom(Matcher) - Static method in class org.postgresql.pljava.sqlgen.Lexicals
-
Return an Identifier.Simple, given a
Matcher
that has matched an ISO_AND_PG_IDENTIFIER_CAPTURING. - ignoreDTD() - Method in interface org.postgresql.pljava.Adjusting.XML.Parsing
-
Specifies that any DTD should be ignored (neither processed nor rejected as an error).
- IMMUTABLE - org.postgresql.pljava.annotation.Function.Effects
- implementor() - Method in annotation type org.postgresql.pljava.annotation.Aggregate
-
The
<implementor name>
to be used around SQL code generated for this aggregate. - implementor() - Method in annotation type org.postgresql.pljava.annotation.BaseUDT
-
The
<implementor name>
to be used around SQL code generated for this type (and for its in/out/recv/send functions, if not overridden for them). - implementor() - Method in annotation type org.postgresql.pljava.annotation.Cast
-
The
<implementor name>
to be used around SQL code generated for this cast. - implementor() - Method in annotation type org.postgresql.pljava.annotation.Function
-
The
<implementor name>
to be used around SQL code generated for this function (and for its triggers, if any, and not overridden for them). - implementor() - Method in annotation type org.postgresql.pljava.annotation.MappedUDT
-
The
<implementor name>
to be used around SQL code generated for this type. - implementor() - Method in annotation type org.postgresql.pljava.annotation.Operator
-
The
<implementor name>
to be used around SQL code generated for this operator. - implementor() - Method in annotation type org.postgresql.pljava.annotation.SQLAction
-
The
<implementor name>
to be used around SQL code generated here. - IMPLICIT - org.postgresql.pljava.annotation.Cast.Application
- INITIALLY_DEFERRED - org.postgresql.pljava.annotation.Trigger.Constraint
- INITIALLY_IMMEDIATE - org.postgresql.pljava.annotation.Trigger.Constraint
- initialState() - Method in annotation type org.postgresql.pljava.annotation.Aggregate.Plan
-
An optional initial value for the state (which will otherwise be initially null).
- INOUT - org.postgresql.pljava.annotation.Cast.Path
- INSERT - org.postgresql.pljava.annotation.Trigger.Event
- install() - Method in annotation type org.postgresql.pljava.annotation.SQLAction
-
SQL commands to be included in a BEGIN INSTALL group (each string considered a separate command to which a semicolon will be added).
- INSTEAD_OF - org.postgresql.pljava.annotation.Trigger.Called
- INT2 - org.postgresql.pljava.annotation.BaseUDT.Alignment
- INT4 - org.postgresql.pljava.annotation.BaseUDT.Alignment
- INTERNAL - org.postgresql.pljava.annotation.BaseUDT.PredefinedCategory
- INTERNAL - Static variable in interface org.postgresql.pljava.annotation.BaseUDT.PredefinedCategory.Code
- internalLength() - Method in annotation type org.postgresql.pljava.annotation.BaseUDT
-
Length of the type's internal representation, positive for a fixed length.
- INVOKER - org.postgresql.pljava.annotation.Function.Security
- isFiredAfter() - Method in interface org.postgresql.pljava.TriggerData
-
Returns
true
if the trigger was fired after the statement or row action that it is associated with. - isFiredBefore() - Method in interface org.postgresql.pljava.TriggerData
-
Returns
true
if the trigger was fired before the statement or row action that it is associated with. - isFiredByDelete() - Method in interface org.postgresql.pljava.TriggerData
-
Returns
true
if this trigger was fired by aDELETE
. - isFiredByInsert() - Method in interface org.postgresql.pljava.TriggerData
-
Returns
true
if this trigger was fired by anINSERT
. - isFiredByUpdate() - Method in interface org.postgresql.pljava.TriggerData
-
Returns
true
if this trigger was fired by anUPDATE
. - isFiredForEachRow() - Method in interface org.postgresql.pljava.TriggerData
-
Returns
true
if this trigger is fired once for each row (as opposed to once for the entire statement). - isFiredForStatement() - Method in interface org.postgresql.pljava.TriggerData
-
Returns
true
if this trigger is fired once for the entire statement (as opposed to once for each row). - ISO_AND_PG_IDENTIFIER_CAPTURING - Static variable in class org.postgresql.pljava.sqlgen.Lexicals
-
Pattern that matches any identifier valid by both ISO and PG rules, with the presence of named capturing groups indicating which kind it is:
i
for a regular identifier,xd
for a delimited identifier (still needing "" replaced with "), orxui
(with or without an explicituec
for a Unicode identifier (still needing "" to " and decoding ofUnicode escape value
s). - ISO_AND_PG_REGULAR_IDENTIFIER - Static variable in class org.postgresql.pljava.sqlgen.Lexicals
-
A regular identifier that satisfies both ISO and PostgreSQL rules.
- ISO_AND_PG_REGULAR_IDENTIFIER_CAPTURING - Static variable in class org.postgresql.pljava.sqlgen.Lexicals
-
A regular identifier that satisfies both ISO and PostgreSQL rules, in a single capturing group named
i
. - ISO_DELIMITED_IDENTIFIER - Static variable in class org.postgresql.pljava.sqlgen.Lexicals
-
A complete delimited identifier as allowed by ISO.
- ISO_DELIMITED_IDENTIFIER_CAPTURING - Static variable in class org.postgresql.pljava.sqlgen.Lexicals
-
An ISO delimited identifier with a single capturing group that captures the content (which still needs to have "" replaced with " throughout).
- ISO_PG_JAVA_IDENTIFIER - Static variable in class org.postgresql.pljava.sqlgen.Lexicals
-
An identifier by ISO SQL, PostgreSQL, and Java (not SQL at all) rules.
- ISO_REGULAR_IDENTIFIER - Static variable in class org.postgresql.pljava.sqlgen.Lexicals
-
A complete regular identifier as allowed by ISO.
- ISO_REGULAR_IDENTIFIER_CAPTURING - Static variable in class org.postgresql.pljava.sqlgen.Lexicals
-
A complete ISO regular identifier in a single capturing group.
- ISO_REGULAR_IDENTIFIER_PART - Static variable in class org.postgresql.pljava.sqlgen.Lexicals
-
Allowed as any non-first character of a regular identifier by ISO.
- ISO_REGULAR_IDENTIFIER_START - Static variable in class org.postgresql.pljava.sqlgen.Lexicals
-
Allowed as the first character of a regular identifier by ISO.
- ISO_UNICODE_ESCAPE_SPECIFIER - Static variable in class org.postgresql.pljava.sqlgen.Lexicals
-
The escape-specifier part of a Unicode delimited identifier or string.
- ISO_UNICODE_IDENTIFIER - Static variable in class org.postgresql.pljava.sqlgen.Lexicals
-
A Unicode delimited identifier.
- ISO_UNICODE_REPLACER - Static variable in class org.postgresql.pljava.sqlgen.Lexicals
-
A compilable pattern to match a
Unicode escape value
. - isoFolded() - Method in class org.postgresql.pljava.sqlgen.Lexicals.Identifier.Simple
-
This Identifier as ISO SQL would case-fold it (or the same as nonFolded if this was quoted and does not fold).
J
- join() - Method in annotation type org.postgresql.pljava.annotation.Operator
-
Name of a function that can estimate the selectivity of this operator when used in a join.
L
- language() - Method in annotation type org.postgresql.pljava.annotation.Function
-
The name of the PostgreSQL procedural language to which this function should be declared, as an alternative to specifying
trust
. - lax(boolean) - Method in interface org.postgresql.pljava.Adjusting.XML.Parsing
-
Tailors the treatment of 'quiet' exceptions during a chain of best-effort adjustments.
- leakproof() - Method in annotation type org.postgresql.pljava.annotation.Function
-
Whether the function can be safely pushed inside the evaluation of views created with the security_barrier option. This should only be set true on a function known not to leak data under any circumstances (even, for example, throwing errors for certain parameter values and not others).
- left() - Method in annotation type org.postgresql.pljava.annotation.Operator
-
The type of the operator's left operand, if any.
- Lexicals - Class in org.postgresql.pljava.sqlgen
-
A few useful SQL lexical definitions supplied as
Pattern
objects. - Lexicals.Identifier - Class in org.postgresql.pljava.sqlgen
-
Class representing a SQL identifier.
- Lexicals.Identifier.Operator - Class in org.postgresql.pljava.sqlgen
-
Class representing an Identifier that names a PostgreSQL operator.
- Lexicals.Identifier.Pseudo - Class in org.postgresql.pljava.sqlgen
-
Displays/deparses like a
Simple
identifier, but no singleton of this class matches anything but itself, to represent pseudo-identifiers likePUBLIC
as a privilege grantee. - Lexicals.Identifier.Qualified<T extends Lexicals.Identifier.Unqualified<T>> - Class in org.postgresql.pljava.sqlgen
-
Class representing a schema-qualified identifier.
- Lexicals.Identifier.Simple - Class in org.postgresql.pljava.sqlgen
-
Class representing an unqualified identifier in the form of a name (whether a case-insensitive "regular identifier" without quotes, or a delimited form).
- Lexicals.Identifier.Unqualified<T extends Lexicals.Identifier.Unqualified<T>> - Class in org.postgresql.pljava.sqlgen
- like() - Method in annotation type org.postgresql.pljava.annotation.BaseUDT
-
Name, possibly schema-qualified, of another SQL type whose
internalLength
,passedByValue
,alignment
, andstorage
properties are used for this type, as a shorthand alternative to spelling them all out. - loadExternalDTD(boolean) - Method in interface org.postgresql.pljava.Adjusting.XML.Parsing
-
Whether to retrieve any external DTD subset declared in the DTD.
- local() - Method in class org.postgresql.pljava.sqlgen.Lexicals.Identifier.Qualified
-
Returns the local part, a
Simple
or anOperator
, as the case may be.
M
- m_nonFolded - Variable in class org.postgresql.pljava.sqlgen.Lexicals.Identifier.Simple
- MAIN - org.postgresql.pljava.annotation.BaseUDT.Storage
-
Can be compressed, but moved out-of-line only if there is no other way to make the containing tuple fit a page.
- MappedUDT - Annotation Type in org.postgresql.pljava.annotation
-
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).
- MATCHINGJOINSEL - Static variable in interface org.postgresql.pljava.annotation.Operator.SelectivityEstimators
-
A join-selectivity estimator suitable for an operator somewhat less strict than a typical
=
operator. - MATCHINGSEL - Static variable in interface org.postgresql.pljava.annotation.Operator.SelectivityEstimators
-
A restriction-selectivity estimator suitable for an operator somewhat less strict than a typical
=
operator. - maxElementDepth(int) - Method in interface org.postgresql.pljava.Adjusting.XML.Parsing
-
Maximum element depth, with a negative or zero value indicating no limit.
- maxGeneralEntitySizeLimit(int) - Method in interface org.postgresql.pljava.Adjusting.XML.Parsing
-
Maximum size of any general entities, with a negative or zero value indicating no limit.
- maxParameterEntitySizeLimit(int) - Method in interface org.postgresql.pljava.Adjusting.XML.Parsing
-
Maximum size of any parameter entities (including the result of nesting parameter entities), with a negative or zero value indicating no limit.
- maxXMLNameLimit(int) - Method in interface org.postgresql.pljava.Adjusting.XML.Parsing
-
Maximum size of XML names (including element and attribute names, namespace prefix, and namespace URI even though that isn't an XML name), with a negative or zero value indicating no limit.
- merges() - Method in annotation type org.postgresql.pljava.annotation.Operator
-
Whether this operator can be used in computing a merge join.
- movingPlan() - Method in annotation type org.postgresql.pljava.annotation.Aggregate
-
An optional
Plan
that may be more efficient for evaluating this aggregate in a moving-window context.
N
- name() - Method in annotation type org.postgresql.pljava.annotation.Aggregate
-
Name for this aggregate.
- name() - Method in annotation type org.postgresql.pljava.annotation.BaseUDT
-
Name of the new type in SQL, if it is not to be the simple name of the class.
- name() - Method in annotation type org.postgresql.pljava.annotation.Function
-
The name of the function.
- name() - Method in annotation type org.postgresql.pljava.annotation.MappedUDT
-
Name of the type in SQL, if it is not to be the simple name of the class.
- name() - Method in annotation type org.postgresql.pljava.annotation.Operator
-
Name for this operator.
- name() - Method in annotation type org.postgresql.pljava.annotation.SQLType
-
SQL name for the parameter, to allow calling the function using named parameter notation, in preference to the parameter's Java name.
- name() - Method in annotation type org.postgresql.pljava.annotation.Trigger
-
Name of the trigger.
- nameFromCatalog(String, String) - Static method in class org.postgresql.pljava.sqlgen.Lexicals.Identifier.Qualified
-
Create an
Identifier.Qualified
from name strings found in PostgreSQL system catalogs. - nameFromJava(String) - Static method in class org.postgresql.pljava.sqlgen.Lexicals.Identifier.Qualified
-
Create an
Identifier.Qualified<Simple>
from a name string supplied in Java source, such as an annotation value. - nameFromJava(String, Messager) - Static method in class org.postgresql.pljava.sqlgen.Lexicals.Identifier.Qualified
-
Create an
Identifier.Qualified<Simple>
from a name string supplied in Java source, such as an annotation value. - negator() - Method in annotation type org.postgresql.pljava.annotation.Operator
-
Name of an operator that is the negator of this one.
- NEQJOINSEL - Static variable in interface org.postgresql.pljava.annotation.Operator.SelectivityEstimators
-
A join-selectivity estimator suitable for an operator with rather low selectivity typical of an operator like
<>
. - NEQSEL - Static variable in interface org.postgresql.pljava.annotation.Operator.SelectivityEstimators
-
A restriction-selectivity estimator suitable for an operator with rather low selectivity typical of an operator like
<>
. - NETWORK - org.postgresql.pljava.annotation.BaseUDT.PredefinedCategory
- NETWORK - Static variable in interface org.postgresql.pljava.annotation.BaseUDT.PredefinedCategory.Code
- NEWLINE - Static variable in class org.postgresql.pljava.sqlgen.Lexicals
-
A newline, in any of the various forms recognized by the Java regex engine, letting it handle the details.
- nonFolded() - Method in class org.postgresql.pljava.sqlgen.Lexicals.Identifier.Simple
-
This Identifier's original spelling.
- NOT_DEFERRABLE - org.postgresql.pljava.annotation.Trigger.Constraint
- NUMERIC - org.postgresql.pljava.annotation.BaseUDT.PredefinedCategory
- NUMERIC - Static variable in interface org.postgresql.pljava.annotation.BaseUDT.PredefinedCategory.Code
O
- ObjectPool<T extends PooledObject> - Interface in org.postgresql.pljava
-
A pool of objects of a single class.
- onAbort(Session) - Method in interface org.postgresql.pljava.TransactionListener
- onAbort(Session, Savepoint, Savepoint) - Method in interface org.postgresql.pljava.SavepointListener
- onCommit(Session) - Method in interface org.postgresql.pljava.TransactionListener
- onCommit(Session, Savepoint, Savepoint) - Method in interface org.postgresql.pljava.SavepointListener
- onNullInput() - Method in annotation type org.postgresql.pljava.annotation.Function
-
Defines what should happen when input to the function is null.
- onParallelAbort(Session) - Method in interface org.postgresql.pljava.TransactionListener
- onParallelCommit(Session) - Method in interface org.postgresql.pljava.TransactionListener
- onParallelPreCommit(Session) - Method in interface org.postgresql.pljava.TransactionListener
- onPreCommit(Session) - Method in interface org.postgresql.pljava.TransactionListener
- onPreCommit(Session, Savepoint, Savepoint) - Method in interface org.postgresql.pljava.SavepointListener
- onPrepare(Session) - Method in interface org.postgresql.pljava.TransactionListener
- onPrePrepare(Session) - Method in interface org.postgresql.pljava.TransactionListener
- onStart(Session, Savepoint, Savepoint) - Method in interface org.postgresql.pljava.SavepointListener
- Operator - Annotation Type in org.postgresql.pljava.annotation
-
Declares a PostgreSQL
OPERATOR
. - Operator.SelectivityEstimators - Interface in org.postgresql.pljava.annotation
-
Names of several functions predefined in PostgreSQL for estimating the selectivity of operators in restriction clauses or joins.
- operatorFromCatalog(String, String) - Static method in class org.postgresql.pljava.sqlgen.Lexicals.Identifier.Qualified
-
Create an
Identifier.Qualified
representing an operator from name strings found in PostgreSQL system catalogs. - operatorFromJava(String) - Static method in class org.postgresql.pljava.sqlgen.Lexicals.Identifier.Qualified
-
Create an
Identifier.Qualified<Operator>
from a name string supplied in Java source, such as an annotation value. - operatorFromJava(String, Messager) - Static method in class org.postgresql.pljava.sqlgen.Lexicals.Identifier.Qualified
-
Create an
Identifier.Qualified<Operator>
from a name string supplied in Java source, such as an annotation value. - optional() - Method in annotation type org.postgresql.pljava.annotation.SQLType
-
What
optional=true
means is just whatdefaultValue=null
would mean, if Java permitted null values in annotations. - org.postgresql.pljava - module org.postgresql.pljava
-
Defines the API for PL/Java.
- org.postgresql.pljava - package org.postgresql.pljava
-
The PL/Java API for use in writing database procedures, functions, and types using PL/Java.
- org.postgresql.pljava.annotation - package org.postgresql.pljava.annotation
-
Annotations for use in Java code to generate the SQLJ Deployment Descriptor automatically.
- org.postgresql.pljava.sqlgen - package org.postgresql.pljava.sqlgen
-
API for manipulating common lexical elements of SQL such as identifiers, mostly for use by PL/Java's SQL deployment-descriptor-generating code, but exported here for other possible uses.
- out() - Method in annotation type org.postgresql.pljava.annotation.Function
-
The result column names and types of a composite-returning function.
P
- parallel() - Method in annotation type org.postgresql.pljava.annotation.Aggregate
-
Parallel-safety declaration for this aggregate; PostgreSQL's planner will consult this only, not the declarations on the individual supporting functions.
- parallel() - Method in annotation type org.postgresql.pljava.annotation.Function
-
Whether the function is UNSAFE to use in any parallel query plan at all (the default), or avoids all disqualifying operations and so is SAFE to execute anywhere in a parallel plan, or, by avoiding some such operations, may appear in parallel plans but RESTRICTED to execute only on the parallel group leader.
- passedByValue() - Method in annotation type org.postgresql.pljava.annotation.BaseUDT
-
If true, indicates that the contents are passed by value rather than by reference, only possible for fixed-length types no wider than the PostgreSQL
Datum
. - passivate() - Method in interface org.postgresql.pljava.PooledObject
-
The passivate method is called before the instance enters the "passive" state.
- passivateInstance(T) - Method in interface org.postgresql.pljava.ObjectPool
-
Call the
PooledObject.passivate()
method and return the object to the pool. - path() - Method in annotation type org.postgresql.pljava.annotation.Cast
-
A stock conversion path when a dedicated function is not supplied:
BINARY
for two types that are known to have the same internal representation, orINOUT
to invoke the first type's text-output function followed by the second type's text-input function. - PG_OPERATOR - Static variable in class org.postgresql.pljava.sqlgen.Lexicals
-
An operator by PostgreSQL rules.
- PG_REGULAR_IDENTIFIER - Static variable in class org.postgresql.pljava.sqlgen.Lexicals
-
A complete regular identifier as allowed by PostgreSQL (PG 7.4 -).
- PG_REGULAR_IDENTIFIER_CAPTURING - Static variable in class org.postgresql.pljava.sqlgen.Lexicals
-
A complete PostgreSQL regular identifier in a single capturing group.
- PG_REGULAR_IDENTIFIER_PART - Static variable in class org.postgresql.pljava.sqlgen.Lexicals
-
Allowed as any non-first character of a regular identifier by PostgreSQL (PG 7.4 -).
- PG_REGULAR_IDENTIFIER_START - Static variable in class org.postgresql.pljava.sqlgen.Lexicals
-
Allowed as the first character of a regular identifier by PostgreSQL (PG 7.4 -).
- pgFold(String) - Static method in class org.postgresql.pljava.sqlgen.Lexicals.Identifier.Simple
-
Case-fold a string by the PostgreSQL rules (assuming a multibyte server encoding, where only the 26 uppercase ASCII letters fold to lowercase).
- pgFolded() - Method in class org.postgresql.pljava.sqlgen.Lexicals.Identifier.Simple
-
This Identifier as PostgreSQL would case-fold it (or the same as nonFolded if this was quoted and does not fold).
- PLAIN - org.postgresql.pljava.annotation.BaseUDT.Storage
-
Never compressed or stored out-of-line.
- plan() - Method in annotation type org.postgresql.pljava.annotation.Aggregate
-
The
Plan
normally to be used for evaluating this aggregate, except possibly in a moving-window context ifmovingPlan
is also supplied. - PLPrincipal - Class in org.postgresql.pljava
-
Java
Principal
representing a PostgreSQLPROCEDURAL LANGUAGE
, which has a name (a simple identifier, not schema-qualified) and is eitherSandboxed
(declared with SQLCREATE TRUSTED LANGUAGE
orUnsandboxed
. - PLPrincipal.Sandboxed - Class in org.postgresql.pljava
-
Java
Principal
representing a PostgreSQLPROCEDURAL LANGUAGE
that was declared with theTRUSTED
keyword and can be used to declare new functions by any role that has been grantedUSAGE
permission on it. - PLPrincipal.Unsandboxed - Class in org.postgresql.pljava
-
Java
Principal
representing a PostgreSQLPROCEDURAL LANGUAGE
that was declared without theTRUSTED
keyword, and can be used to declare new functions only by a PostgreSQL superuser. - polymorphic() - Method in annotation type org.postgresql.pljava.annotation.Aggregate.Plan
-
Whether the argument list for
finish
should be extended with slots corresponding to the aggregatedarguments
, all nulls at runtime but with their resolved runtime types. - PooledObject - Interface in org.postgresql.pljava
-
Interface for objects that are pooled and reused.
- POSITIONJOINSEL - Static variable in interface org.postgresql.pljava.annotation.Operator.SelectivityEstimators
-
A join-selectivity estimator suitable for an operator doing 2-D position-based comparisons.
- preferBinaryStream() - Method in interface org.postgresql.pljava.Adjusting.XML.StreamResult
- preferCharacterStream() - Method in interface org.postgresql.pljava.Adjusting.XML.StreamResult
- preferred() - Method in annotation type org.postgresql.pljava.annotation.BaseUDT
-
Whether this type is to be "preferred" in its
BaseUDT.category()
, for implicit type conversion purposes. - provides() - Method in annotation type org.postgresql.pljava.annotation.Aggregate
-
One or more arbitrary labels that will be considered 'provided' by the object carrying this annotation.
- provides() - Method in annotation type org.postgresql.pljava.annotation.BaseUDT
-
One or more arbitrary labels that will be considered 'provided' by the object carrying this annotation.
- provides() - Method in annotation type org.postgresql.pljava.annotation.Cast
-
One or more arbitrary labels that will be considered 'provided' by the object carrying this annotation.
- provides() - Method in annotation type org.postgresql.pljava.annotation.Function
-
One or more arbitrary labels that will be considered 'provided' by the object carrying this annotation.
- provides() - Method in annotation type org.postgresql.pljava.annotation.MappedUDT
-
One or more arbitrary labels that will be considered 'provided' by the object carrying this annotation.
- provides() - Method in annotation type org.postgresql.pljava.annotation.Operator
-
One or more arbitrary labels that will be considered 'provided' by the object carrying this annotation.
- provides() - Method in annotation type org.postgresql.pljava.annotation.SQLAction
-
One or more arbitrary labels that will be considered 'provided' by the object carrying this annotation.
- PSEUDOTYPE - org.postgresql.pljava.annotation.BaseUDT.PredefinedCategory
- PSEUDOTYPE - Static variable in interface org.postgresql.pljava.annotation.BaseUDT.PredefinedCategory.Code
- PUBLIC - Static variable in class org.postgresql.pljava.sqlgen.Lexicals.Identifier.Pseudo
-
Instance intended to represent
PUBLIC
when used as a privilege grantee.
Q
- qualifier() - Method in class org.postgresql.pljava.sqlgen.Lexicals.Identifier.Qualified
-
Returns the qualifier, possibly null, as a
Simple
.
R
- RANGE - org.postgresql.pljava.annotation.BaseUDT.PredefinedCategory
- RANGE - Static variable in interface org.postgresql.pljava.annotation.BaseUDT.PredefinedCategory.Code
- READ_ONLY - org.postgresql.pljava.annotation.Aggregate.FinishEffect
- READ_WRITE - org.postgresql.pljava.annotation.Aggregate.FinishEffect
- remove() - Method in annotation type org.postgresql.pljava.annotation.Aggregate.Plan
-
Name of an optional function that can reverse the effect on the state of a row previously passed to
accumulate
. - remove() - Method in annotation type org.postgresql.pljava.annotation.SQLAction
-
SQL commands to be included in a BEGIN REMOVE group (each string considered a separate command to which a semicolon will be added).
- remove() - Method in interface org.postgresql.pljava.PooledObject
-
PLJava invokes this method before it ends the life of the pooled object.
- removeAttribute(String) - Method in interface org.postgresql.pljava.Session
-
Deprecated, for removal: This API element is subject to removal in a future version.
Session
's attribute store once had a special, and possibly useful, transactional behavior, but since PL/Java 1.2.0 it has lacked that, and offers nothing you don't get with an ordinaryMap
(that forbids nulls). If some kind of store with transactional behavior is needed, it should be implemented in straight Java and kept in sync by using aTransactionListener
. - removeInstance(T) - Method in interface org.postgresql.pljava.ObjectPool
-
Call the
PooledObject.remove()
method and evict the object from the pool. - removeSavepointListener(SavepointListener) - Method in interface org.postgresql.pljava.Session
-
Removes the specified
listener
from the list of listeners that will receive savepoint events. - removeTransactionListener(TransactionListener) - Method in interface org.postgresql.pljava.Session
-
Removes the specified
listener
from the list of listeners that will receive transaction events. - requires() - Method in annotation type org.postgresql.pljava.annotation.Aggregate
-
One or more arbitrary labels that will be considered 'required' by the object carrying this annotation.
- requires() - Method in annotation type org.postgresql.pljava.annotation.BaseUDT
-
One or more arbitrary labels that will be considered 'required' by the object carrying this annotation.
- requires() - Method in annotation type org.postgresql.pljava.annotation.Cast
-
One or more arbitrary labels that will be considered 'required' by the object carrying this annotation.
- requires() - Method in annotation type org.postgresql.pljava.annotation.Function
-
One or more arbitrary labels that will be considered 'required' by the object carrying this annotation.
- requires() - Method in annotation type org.postgresql.pljava.annotation.MappedUDT
-
One or more arbitrary labels that will be considered 'required' by the object carrying this annotation.
- requires() - Method in annotation type org.postgresql.pljava.annotation.Operator
-
One or more arbitrary labels that will be considered 'required' by the object carrying this annotation.
- requires() - Method in annotation type org.postgresql.pljava.annotation.SQLAction
-
One or more arbitrary labels that will be considered 'required' by the object carrying this annotation.
- restrict() - Method in annotation type org.postgresql.pljava.annotation.Operator
-
Name of a function that can estimate the selectivity of this operator when used in a
WHERE
clause. - RESTRICTED - org.postgresql.pljava.annotation.Function.Parallel
- ResultSetHandle - Interface in org.postgresql.pljava
-
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 aResultSet
. - ResultSetProvider - Interface in org.postgresql.pljava
-
An implementation of this interface is returned from functions and procedures that are declared to return
SET OF
a complex type. - ResultSetProvider.Large - Interface in org.postgresql.pljava
-
Version of
ResultSetProvider
where theassignRowValues
method accepting along
row count must be implemented, and theint
version defaults to using it. - RETURNS_NULL - org.postgresql.pljava.annotation.Function.OnNullInput
- right() - Method in annotation type org.postgresql.pljava.annotation.Operator
-
The type of the operator's right operand, if any.
- ROW - org.postgresql.pljava.annotation.Trigger.Scope
- rows() - Method in annotation type org.postgresql.pljava.annotation.Function
-
Estimated number of rows returned (only for functions returning set).
S
- SAFE - org.postgresql.pljava.annotation.Function.Parallel
- Sandboxed(String) - Constructor for class org.postgresql.pljava.PLPrincipal.Sandboxed
-
Construct an instance given its name in
String
form. - Sandboxed(Lexicals.Identifier.Simple) - Constructor for class org.postgresql.pljava.PLPrincipal.Sandboxed
-
Construct an instance given its name already as an
Identifier.Simple
. - SANDBOXED - org.postgresql.pljava.annotation.Function.Trust
- SavepointListener - Interface in org.postgresql.pljava
-
Interface for a listener to be notified of the start and pre-commit, commit, or abort of savepoints.
- SCALARGEJOINSEL - Static variable in interface org.postgresql.pljava.annotation.Operator.SelectivityEstimators
-
A join-selectivity estimator suitable for an operator with selectivity typical of an operator like
>=
. - SCALARGESEL - Static variable in interface org.postgresql.pljava.annotation.Operator.SelectivityEstimators
-
A restriction-selectivity estimator suitable for an operator with selectivity typical of an operator like
>=
. - SCALARGTJOINSEL - Static variable in interface org.postgresql.pljava.annotation.Operator.SelectivityEstimators
-
A join-selectivity estimator suitable for an operator with selectivity typical of an operator like
>
. - SCALARGTSEL - Static variable in interface org.postgresql.pljava.annotation.Operator.SelectivityEstimators
-
A restriction-selectivity estimator suitable for an operator with selectivity typical of an operator like
>
. - SCALARLEJOINSEL - Static variable in interface org.postgresql.pljava.annotation.Operator.SelectivityEstimators
-
A join-selectivity estimator suitable for an operator with selectivity typical of an operator like
<=
. - SCALARLESEL - Static variable in interface org.postgresql.pljava.annotation.Operator.SelectivityEstimators
-
A restriction-selectivity estimator suitable for an operator with selectivity typical of an operator like
<=
. - SCALARLTJOINSEL - Static variable in interface org.postgresql.pljava.annotation.Operator.SelectivityEstimators
-
A join-selectivity estimator suitable for an operator with selectivity typical of an operator like
<
. - SCALARLTSEL - Static variable in interface org.postgresql.pljava.annotation.Operator.SelectivityEstimators
-
A restriction-selectivity estimator suitable for an operator with selectivity typical of an operator like
<
. - schema() - Method in annotation type org.postgresql.pljava.annotation.BaseUDT
-
Schema in which the new type (and, by default, its input/output/send/receive functions) should be declared.
- schema() - Method in annotation type org.postgresql.pljava.annotation.Function
-
The name of the schema if any.
- schema() - Method in annotation type org.postgresql.pljava.annotation.MappedUDT
-
Schema in which the type is declared.
- schema() - Method in annotation type org.postgresql.pljava.annotation.Trigger
-
The name of the schema containing the table for this trigger.
- schema(Schema) - Method in interface org.postgresql.pljava.Adjusting.XML.Parsing
-
Sets a
Schema
to be applied during SAX or DOM parsing (optional operation). - scope() - Method in annotation type org.postgresql.pljava.annotation.Trigger
-
Scope: statement or row.
- security() - Method in annotation type org.postgresql.pljava.annotation.Function
-
Whether the function will run with the security credentials of the invoker (the usual case) or with those of its definer (the special case for a function that needs to access objects with the authority of the user who declared it).
- SELF - Static variable in annotation type org.postgresql.pljava.annotation.Operator
-
Distinguished value usable for
commutator=
to indicate that an operator is its own commutator without having to repeat its schema and name. - separator(Matcher, boolean) - Static method in class org.postgresql.pljava.sqlgen.Lexicals
-
Consume any SQL SEPARATOR at the beginning of
Matcher
m's current region. - SEPARATOR - Static variable in class org.postgresql.pljava.sqlgen.Lexicals
-
SQL's SEPARATOR, which can include any amount of whitespace, simple comments, or bracketed comments.
- serialize() - Method in annotation type org.postgresql.pljava.annotation.Aggregate.Plan
-
Name of a serializing function (
internal
tobytea
), usable only if acombine
function is specified and the aggregate's state type isinternal
. - Session - Interface in org.postgresql.pljava
-
A Session brings together some useful methods and data for the current database session.
- SessionManager - Class in org.postgresql.pljava
-
The SessionManager makes the current
Session
available to the caller. - SessionManager() - Constructor for class org.postgresql.pljava.SessionManager
- set(String) - Method in interface org.postgresql.pljava.Adjusting.XML.SourceResult
-
Provides the content to be copied in the form of a
String
. - set(String, T) - Method in interface org.postgresql.pljava.Adjusting.XML.SetMethod
- set(DOMSource) - Method in interface org.postgresql.pljava.Adjusting.XML.SourceResult
-
Specialization of
set
for an argument of typeDOMSource
. - set(SAXSource) - Method in interface org.postgresql.pljava.Adjusting.XML.SourceResult
-
Specialization of
set
for an argument of typeSAXSource
. - set(Source) - Method in interface org.postgresql.pljava.Adjusting.XML.SourceResult
-
Supplies the
Source
instance that is the source of the content. - set(StAXSource) - Method in interface org.postgresql.pljava.Adjusting.XML.SourceResult
-
Specialization of
set
for an argument of typeStAXSource
. - set(StreamSource) - Method in interface org.postgresql.pljava.Adjusting.XML.SourceResult
-
Specialization of
set
for an argument of typeStreamSource
. - setAttribute(String, Object) - Method in interface org.postgresql.pljava.Session
-
Deprecated, for removal: This API element is subject to removal in a future version.
Session
's attribute store once had a special, and possibly useful, transactional behavior, but since PL/Java 1.2.0 it has lacked that, and offers nothing you don't get with an ordinaryMap
(that forbids nulls). If some kind of store with transactional behavior is needed, it should be implemented in straight Java and kept in sync by using aTransactionListener
. - setFirstSupported(Adjusting.XML.SetMethod<? super T>, V, List<Class<? extends Exception>>, Exception, Consumer<? super Exception>, String...) - Static method in class org.postgresql.pljava.Adjusting.XML
-
Attempts a given action (typically to set something) using a given value, trying one or more supplied keys in order until the action succeeds with no exception.
- setFirstSupported(Adjusting.XML.SetMethod<? super T>, V, List<Class<? extends Exception>>, Consumer<? super Exception>, String...) - Static method in class org.postgresql.pljava.Adjusting.XML
-
Calls the six-argument overload passing null for caught.
- setFirstSupportedFeature(boolean, String...) - Method in interface org.postgresql.pljava.Adjusting.XML.Parsing
-
For a feature that may have been identified by more than one URI in different parsers or versions, tries passing the supplied value with each URI from names in order until one is not rejected by the underlying parser.
- setFirstSupportedProperty(Object, String...) - Method in interface org.postgresql.pljava.Adjusting.XML.Parsing
-
For a parser property (in DOM parlance, attribute) that may have been identified by more than one URI in different parsers or versions, tries passing the supplied value with each URI from names in order until one is not rejected by the underlying parser.
- settings() - Method in annotation type org.postgresql.pljava.annotation.Function
-
Configuration parameter overrides to apply during execution of the function, reverting afterward to the former setting.
- SHAREABLE - org.postgresql.pljava.annotation.Aggregate.FinishEffect
- SIMPLE_COMMENT - Static variable in class org.postgresql.pljava.sqlgen.Lexicals
-
The kind of comment that extends from -- to the end of the line.
- sortOperator() - Method in annotation type org.postgresql.pljava.annotation.Aggregate
-
Name of an operator (declared as either the less-than or greater-than strategy member of a
btree
operator class) such that the result of this aggregate is the same as the first result fromORDER BY
over the aggregated values, using this operator. - SQLAction - Annotation Type in org.postgresql.pljava.annotation
-
Annotation that supplies verbatim commands to be copied into the deployment descriptor.
- SQLActions - Annotation Type in org.postgresql.pljava.annotation
-
Container for multiple
SQLAction
annotations (in case it is convenient to hang more than one on a given program element). - SQLType - Annotation Type in org.postgresql.pljava.annotation
-
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.
- STABLE - org.postgresql.pljava.annotation.Function.Effects
- STATEMENT - org.postgresql.pljava.annotation.Trigger.Scope
- stateSize() - Method in annotation type org.postgresql.pljava.annotation.Aggregate.Plan
-
An optional estimate of the size in bytes that the state may grow to occupy.
- stateType() - Method in annotation type org.postgresql.pljava.annotation.Aggregate.Plan
-
The data type to be used to hold the accumulating state.
- storage() - Method in annotation type org.postgresql.pljava.annotation.BaseUDT
-
The TOAST strategy for the type's stored representation.
- STRING - org.postgresql.pljava.annotation.BaseUDT.PredefinedCategory
- STRING - Static variable in interface org.postgresql.pljava.annotation.BaseUDT.PredefinedCategory.Code
- structure() - Method in annotation type org.postgresql.pljava.annotation.MappedUDT
-
Structure of the new composite ("structured") type to create, as strings, one per attribute, for example
{"x float8", "y float8"}
. - suppress() - Method in interface org.postgresql.pljava.TriggerData
-
Advise PostgreSQL to silently suppress the operation on this row.
- synthetic() - Method in annotation type org.postgresql.pljava.annotation.Operator
-
Name of a function to be synthesized by PL/Java based on the method this annotation appears on and this operator's
commutator
ornegator
relationship to another operator declared on the same method.
T
- table() - Method in annotation type org.postgresql.pljava.annotation.Trigger
-
The table that this trigger is tied to.
- tableNew() - Method in annotation type org.postgresql.pljava.annotation.Trigger
-
Name to refer to "after" table of affected rows.
- tableOld() - Method in annotation type org.postgresql.pljava.annotation.Trigger
-
Name to refer to "before" table of affected rows.
- TIMESPAN - org.postgresql.pljava.annotation.BaseUDT.PredefinedCategory
- TIMESPAN - Static variable in interface org.postgresql.pljava.annotation.BaseUDT.PredefinedCategory.Code
- to() - Method in annotation type org.postgresql.pljava.annotation.Cast
-
The target type to cast to.
- toString() - Method in class org.postgresql.pljava.sqlgen.Lexicals.Identifier
-
Convert to
String
as bydeparse
passing a character set ofUTF_8
. - totalEntitySizeLimit(int) - Method in interface org.postgresql.pljava.Adjusting.XML.Parsing
-
Limit on total size of all entities, general or parameter, with a negative or zero value indicating no limit.
- TransactionListener - Interface in org.postgresql.pljava
-
Interface for a listener to be notified of prepare, and commit, abort, or other phase transitions, of distributed transactions.
- Trigger - Annotation Type in org.postgresql.pljava.annotation
-
Annotation, only used in
@Function(triggers=...)
, to specify what trigger(s) the function will be called for. - TRIGGER_ACTION_EXCEPTION - Static variable in exception org.postgresql.pljava.TriggerException
- Trigger.Called - Enum in org.postgresql.pljava.annotation
-
Whether the trigger is invoked before or after the specified event.
- Trigger.Constraint - Enum in org.postgresql.pljava.annotation
-
Deferrability (only applies to constraint triggers).
- Trigger.Event - Enum in org.postgresql.pljava.annotation
-
Types of event that can occasion a trigger.
- Trigger.Scope - Enum in org.postgresql.pljava.annotation
-
Whether the trigger will occur only once for a statement of interest, or once for each row affected by the statement.
- TriggerData - Interface in org.postgresql.pljava
-
The data passed to an ordinary (insert/update/delete/truncate) trigger function.
- TriggerException - Exception in org.postgresql.pljava
-
An exception specially suited to be thrown from within a method designated to be a trigger function.
- TriggerException(TriggerData) - Constructor for exception org.postgresql.pljava.TriggerException
-
Create an exception based on the
TriggerData
that was passed to the trigger method. - TriggerException(TriggerData, String) - Constructor for exception org.postgresql.pljava.TriggerException
-
Create an exception based on the
TriggerData
that was passed to the trigger method and an additional message. - triggers() - Method in annotation type org.postgresql.pljava.annotation.Function
-
The Triggers that will call this function (if any).
- TRUNCATE - org.postgresql.pljava.annotation.Trigger.Event
- trust() - Method in annotation type org.postgresql.pljava.annotation.Function
-
Whether the function will run in the SANDBOXED ("trusted") version of the language, or requires UNSANDBOXED access and must be defined in the "untrusted" language instance.
- trust() - Method in class org.postgresql.pljava.PLPrincipal.Sandboxed
-
Returns
SANDBOXED
. - trust() - Method in class org.postgresql.pljava.PLPrincipal
-
Returns either
SANDBOXED
orUNSANDBOXED
according to PostgreSQL's catalog entry for the language. - trust() - Method in class org.postgresql.pljava.PLPrincipal.Unsandboxed
-
Returns
UNSANDBOXED
. - TWIN - Static variable in annotation type org.postgresql.pljava.annotation.Operator
-
Distinguished value usable for
commutator=
to indicate that an operator's commutator is another operator with the same schema and name, without having to repeat them. - type() - Method in annotation type org.postgresql.pljava.annotation.Function
-
The element type in case the annotated function returns a
ResultSetProvider
, or can be used to specify the return type of any function if the compiler hasn't inferred it correctly. - typeModifierInput() - Method in annotation type org.postgresql.pljava.annotation.BaseUDT
-
Name, possibly schema-qualified, of a function to parse type-modifier strings for this type.
- typeModifierOutput() - Method in annotation type org.postgresql.pljava.annotation.BaseUDT
-
Name, possibly schema-qualified, of a function to format internal type-modifier codes for display.
U
- UNKNOWN - org.postgresql.pljava.annotation.BaseUDT.PredefinedCategory
- UNKNOWN - Static variable in interface org.postgresql.pljava.annotation.BaseUDT.PredefinedCategory.Code
- UNSAFE - org.postgresql.pljava.annotation.Function.Parallel
- Unsandboxed(String) - Constructor for class org.postgresql.pljava.PLPrincipal.Unsandboxed
-
Construct an instance given its name in
String
form. - Unsandboxed(Lexicals.Identifier.Simple) - Constructor for class org.postgresql.pljava.PLPrincipal.Unsandboxed
-
Construct an instance given its name already as an
Identifier.Simple
. - UNSANDBOXED - org.postgresql.pljava.annotation.Function.Trust
- UPDATE - org.postgresql.pljava.annotation.Trigger.Event
- USER - org.postgresql.pljava.annotation.BaseUDT.PredefinedCategory
- USER - Static variable in interface org.postgresql.pljava.annotation.BaseUDT.PredefinedCategory.Code
V
- value() - Method in annotation type org.postgresql.pljava.annotation.SQLActions
-
The group of SQLAction annotations.
- value() - Method in annotation type org.postgresql.pljava.annotation.SQLType
-
The SQL type name to use for the annotated parameter in preference to any found in the default mappings.
- valueOf(char) - Static method in enum org.postgresql.pljava.annotation.BaseUDT.PredefinedCategory
-
Return the
PredefinedCategory
corresponding to a single-character code as found in the system catalogs, or null if the character represents a custom category (or a predefined one in a PostgreSQL version newer than this class). - valueOf(String) - Static method in enum org.postgresql.pljava.annotation.Aggregate.FinishEffect
-
Returns the enum constant of this type with the specified name.
- valueOf(String) - Static method in enum org.postgresql.pljava.annotation.BaseUDT.Alignment
-
Returns the enum constant of this type with the specified name.
- valueOf(String) - Static method in enum org.postgresql.pljava.annotation.BaseUDT.PredefinedCategory
-
Returns the enum constant of this type with the specified name.
- valueOf(String) - Static method in enum org.postgresql.pljava.annotation.BaseUDT.Storage
-
Returns the enum constant of this type with the specified name.
- valueOf(String) - Static method in enum org.postgresql.pljava.annotation.Cast.Application
-
Returns the enum constant of this type with the specified name.
- valueOf(String) - Static method in enum org.postgresql.pljava.annotation.Cast.Path
-
Returns the enum constant of this type with the specified name.
- valueOf(String) - Static method in enum org.postgresql.pljava.annotation.Function.Effects
-
Returns the enum constant of this type with the specified name.
- valueOf(String) - Static method in enum org.postgresql.pljava.annotation.Function.OnNullInput
-
Returns the enum constant of this type with the specified name.
- valueOf(String) - Static method in enum org.postgresql.pljava.annotation.Function.Parallel
-
Returns the enum constant of this type with the specified name.
- valueOf(String) - Static method in enum org.postgresql.pljava.annotation.Function.Security
-
Returns the enum constant of this type with the specified name.
- valueOf(String) - Static method in enum org.postgresql.pljava.annotation.Function.Trust
-
Returns the enum constant of this type with the specified name.
- valueOf(String) - Static method in enum org.postgresql.pljava.annotation.Trigger.Called
-
Returns the enum constant of this type with the specified name.
- valueOf(String) - Static method in enum org.postgresql.pljava.annotation.Trigger.Constraint
-
Returns the enum constant of this type with the specified name.
- valueOf(String) - Static method in enum org.postgresql.pljava.annotation.Trigger.Event
-
Returns the enum constant of this type with the specified name.
- valueOf(String) - Static method in enum org.postgresql.pljava.annotation.Trigger.Scope
-
Returns the enum constant of this type with the specified name.
- values() - Static method in enum org.postgresql.pljava.annotation.Aggregate.FinishEffect
-
Returns an array containing the constants of this enum type, in the order they are declared.
- values() - Static method in enum org.postgresql.pljava.annotation.BaseUDT.Alignment
-
Returns an array containing the constants of this enum type, in the order they are declared.
- values() - Static method in enum org.postgresql.pljava.annotation.BaseUDT.PredefinedCategory
-
Returns an array containing the constants of this enum type, in the order they are declared.
- values() - Static method in enum org.postgresql.pljava.annotation.BaseUDT.Storage
-
Returns an array containing the constants of this enum type, in the order they are declared.
- values() - Static method in enum org.postgresql.pljava.annotation.Cast.Application
-
Returns an array containing the constants of this enum type, in the order they are declared.
- values() - Static method in enum org.postgresql.pljava.annotation.Cast.Path
-
Returns an array containing the constants of this enum type, in the order they are declared.
- values() - Static method in enum org.postgresql.pljava.annotation.Function.Effects
-
Returns an array containing the constants of this enum type, in the order they are declared.
- values() - Static method in enum org.postgresql.pljava.annotation.Function.OnNullInput
-
Returns an array containing the constants of this enum type, in the order they are declared.
- values() - Static method in enum org.postgresql.pljava.annotation.Function.Parallel
-
Returns an array containing the constants of this enum type, in the order they are declared.
- values() - Static method in enum org.postgresql.pljava.annotation.Function.Security
-
Returns an array containing the constants of this enum type, in the order they are declared.
- values() - Static method in enum org.postgresql.pljava.annotation.Function.Trust
-
Returns an array containing the constants of this enum type, in the order they are declared.
- values() - Static method in enum org.postgresql.pljava.annotation.Trigger.Called
-
Returns an array containing the constants of this enum type, in the order they are declared.
- values() - Static method in enum org.postgresql.pljava.annotation.Trigger.Constraint
-
Returns an array containing the constants of this enum type, in the order they are declared.
- values() - Static method in enum org.postgresql.pljava.annotation.Trigger.Event
-
Returns an array containing the constants of this enum type, in the order they are declared.
- values() - Static method in enum org.postgresql.pljava.annotation.Trigger.Scope
-
Returns an array containing the constants of this enum type, in the order they are declared.
- variadic() - Method in annotation type org.postgresql.pljava.annotation.Aggregate
-
Whether the aggregate has a variadic last argument.
- variadic() - Method in annotation type org.postgresql.pljava.annotation.Function
-
Whether PostgreSQL should gather trailing arguments into an array that will be bound to the last (non-output) Java parameter (which must have an array type).
- VOLATILE - org.postgresql.pljava.annotation.Function.Effects
W
- when() - Method in annotation type org.postgresql.pljava.annotation.Trigger
-
A boolean condition limiting when the trigger can be fired.
- WHITESPACE_NO_NEWLINE - Static variable in class org.postgresql.pljava.sqlgen.Lexicals
-
White space except newline, for any Java-recognized newline.
- withQualifier(Lexicals.Identifier.Simple) - Method in class org.postgresql.pljava.sqlgen.Lexicals.Identifier.Operator
- withQualifier(Lexicals.Identifier.Simple) - Method in class org.postgresql.pljava.sqlgen.Lexicals.Identifier.Simple
- withQualifier(Lexicals.Identifier.Simple) - Method in class org.postgresql.pljava.sqlgen.Lexicals.Identifier.Unqualified
-
Form an
Identifier.Qualified
with this as the local part.
X
- xIncludeAware(boolean) - Method in interface org.postgresql.pljava.Adjusting.XML.Parsing
-
Whether to honor XInclude syntax in the document.
All Classes All Packages