Re: Java Triggers

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
>