JDBC inserts on views using rules

I sent this to the general mailing list, but I thought it might be
appropriate for this forum, since it does relate to the JDBC.

Regards,
Stuart Robinson

---------- Forwarded message ----------
Date: Thu, 8 Nov 2001 23:51:33 -0800 (PST)
From: Stuart Robinson <stuart@zapata.org>
To: pgsql-general@postgresql.org
Subject: [GENERAL] inserts on views using rules

I've got a view that combines a couple of tables. The view is meant to
simplify interactions with a Java application, so that selects, inserts,
and updates can be made on the view as if it were a real table. So, I
figured that rules would be the way to go. For inserts, I wrote a
do-instead rule for the view which in turn calls a function. The function
is meant to take the values from the insert statement and stick them into
the appropriate tables. However, functions appear to always return a value
(except as triggers), which confuses the JDBC. So, when I do an insert on
the view, the function is called and returns a value, causing the
following error:

A result was returned by the statement, when none was expected.
        at org.postgresql.jdbc2.Statement.executeUpdate(Statement.java:80)
        at
org.postgresql.jdbc2.PreparedStatement.executeUpdate(PreparedStatement.java:122)

I take it this is the expected JDBC behavior and not a bug. If so, what
are my options given that functions always return values and triggers
operate before or after inserts, but not instead of them? Is there some
way of calling functions so that they don't return a value? (If this
posting is more appropriate for another mailing list, please let me know.)
Thanks in advance.

-Stuart Robinson


---------------------------(end of broadcast)---------------------------
TIP 3: if posting/reading through Usenet, please send an appropriate
subscribe-nomail command to majordomo@postgresql.org so that your
message can get through to the mailing list cleanly