[Pljava-dev] ResultSet is read-only error for Trigger?

On Wed, 5 Mar 2008, Mike Toler wrote:

> I'm trying to do a very simple trigger before moving onto the complex
> stuff that I need pljava for.
>
> CREATE TRIGGER provisionorder_trigger
> AFTER UPDATE
> ON serviceproviderprovisioned
> FOR EACH ROW
> EXECUTE PROCEDURE provisionorder();
>
> When I update my row, I see the following error:
> ERROR: org.postgresql.pljava.jdbc.UnsupportedFeatureException: Feature
> not supported: ResultSet is read-only
>

I think the problem is that you're using an after trigger instead of a
before trigger. Before the update you can manipulate the values and have
them persisted, but after the update you get the values that did come
through and it's read-only at that point.

Kris Jurka