Package org.postgresql.pljava.example
Class Triggers
java.lang.Object
org.postgresql.pljava.example.Triggers
This class contains some triggers that I found written in C under the
contrib/spi directory of the postgres source distribution. Code to create the
necessary tables, functions, triggers, and some code to actually execute them
can be found in class
org.postgresql.pljava.test.Tester
(no longer
part of the build, see under src/java/test
).- Author:
- Thomas Hallgren
-
Constructor Summary
Constructors -
Method Summary
Modifier and TypeMethodDescriptionstatic void
static void
static void
insert user name in response to a trigger.static void
static void
Update a modification time when the row is updated.
-
Constructor Details
-
Triggers
public Triggers()
-
-
Method Details
-
afterUsernameInsert
- Throws:
SQLException
-
afterUsernameUpdate
- Throws:
SQLException
-
insertUsername
insert user name in response to a trigger.- Throws:
SQLException
-
leakStatements
- Throws:
SQLException
-
moddatetime
Update a modification time when the row is updated.- Throws:
SQLException
-