Обсуждение: Java Triggers

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

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

John,
Thanks for the referral. The link is a bit outdated since all web content has moved to a
wiki. Please use: http://wiki.tada.se/display/pljava/Home instead.

Kind regards,
Thomas Hallgren

John Sidney-Woollett wrote:
> 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
>
> ---------------------------(end of broadcast)---------------------------
> TIP 5: don't forget to increase your free space map settings
>