From: | Thomas Hallgren <thomas(at)tada(dot)se> |
---|---|
To: | John Sidney-Woollett <johnsw(at)wardbrook(dot)com> |
Cc: | pgsql-general(at)postgresql(dot)org, Jimbo1 <jamestheboarder(at)googlemail(dot)com> |
Subject: | Re: Java Triggers |
Date: | 2006-06-02 16:16:58 |
Message-ID: | 4480647A.7070502@tada.se |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
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
>
From | Date | Subject | |
---|---|---|---|
Next Message | Dany De Bontridder | 2006-06-02 18:02:45 | Re: Best open source tool for database design / ERDs? |
Previous Message | Steve Crawford | 2006-06-02 16:04:10 | Re: Migrate Postgres 7.2 to Postgres 8.1 |