Re: [GENERAL] Java Triggers

2006-06-02 Thread Thomas Hallgren
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 functi

Re: [GENERAL] Java Triggers

2006-06-02 Thread John Sidney-Woollett
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/proj

[GENERAL] Java Triggers

2006-06-02 Thread Jimbo1
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 question