Updates using ResultSet

Hi list,

I am using PostgreSQL. In the database I have a view with a join over two tables:

CREATE OR REPLACE VIEW test_view AS

SELECT a.pid, b.dia

FROM lab.stammdaten a

JOIN lab.dia b USING (pid)

Now when I want to update (field dia) the resultset obtained from the view, I get the following error message:

java.sql.SQLException: No primary key foundfor table ((lab.stammdaten.

at com.edb.jdbc2.AbstractJdbc2ResultSet.isUpdateable(AbstractJdbc2ResultSet.java:1539)

at com.edb.jdbc2.AbstractJdbc2ResultSet.checkUpdateable(AbstractJdbc2ResultSet.java:2393)

at com.edb.jdbc2.AbstractJdbc2ResultSet.updateValue(AbstractJdbc2ResultSet.java:2643)

at com.edb.jdbc2.AbstractJdbc2ResultSet.updateInt(AbstractJdbc2ResultSet.java:1108)

at de.unir.gui4db.ui.event.DBTableFrameListener.actionPerformed(DBTableFrameListener.java:188)

Of course I have a primary key in both tables...

I'm thankful for any suggestions.

[1030 byte] By [abenstexa] at [2007-11-27 11:02:43]