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

[Kris Jurka]

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