From: | John Sidney-Woollett <johnsw(at)wardbrook(dot)com> |
---|---|
To: | Jimbo1 <jamestheboarder(at)googlemail(dot)com> |
Cc: | pgsql-general(at)postgresql(dot)org |
Subject: | Re: Java Triggers |
Date: | 2006-06-02 12:06:44 |
Message-ID: | 448029D4.50202@wardbrook.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
I would think the answer is yes.
pljava allows you to create java functions, and triggers invoke functions
eg
CREATE TRIGGER sometrigger
BEFORE UPDATE
ON schema.table
FOR EACH ROW
EXECUTE PROCEDURE yourfunction();
Here's a link for the pljava language.
http://gborg.postgresql.org/project/pljava/genpage.php?userguide
John
Jimbo1 wrote:
> Hi there,
>
> I'm a very competent Oracle developer, but have never used Postgres.
> There's currently a project taking place where I'm working that is
> developing on an Oracle database, but could potentially be migrated to
> an open source database in the future; possibly Postgres.
>
> There are two questions currently being asked about Postgres:
>
> 1. Can it support triggers?
> 2. Can it support Java Triggers (Java in the database trigger body)?
>
> I know the answer to the first question is a definite "Yes". However, I
> don't know the answer to the second.
>
> Please can anybody help?
>
> Thanks in advance.
>
> James
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 4: Have you searched our list archives?
>
> http://archives.postgresql.org
From | Date | Subject | |
---|---|---|---|
Next Message | John Sidney-Woollett | 2006-06-02 12:10:19 | Re: Querying for strings that match after prefix |
Previous Message | Nicholay Ryzhov | 2006-06-02 11:50:47 | Using postgresql as desktop DB |