Can I make a call to a java class/method from a Trigger in a PostgreSQL (in Heroku)?

Question

I need to make my PostgreSQL database execute a java class called by a trigger.

I read that you can install java on your PostgreSQL db, but to do this I might need superuser privileges, and don't know how to do this since PostgreSQL on Heroku doesn't offer this option.

Is there a way to do this? Or perhaps a work-around?

Khanh Nguyen · Accepted Answer · 2015-04-16 19:04:38Z

1

There's a way to it with Notify in Postgres, but then you will have to poll the database periodically and get the notification.

answered Apr 16, 2015 at 19:04

Khanh Nguyen

916 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Can I make a call to a java class/method from a Trigger in a PostgreSQL (in Heroku)?

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related