MoveToInsertRow on a table without a primary key - Mailing list pgsql-jdbc

From patrick.balleux@gmail.com
Subject MoveToInsertRow on a table without a primary key
Date
Msg-id 1911821.1566.1331730216537.JavaMail.geo-discussion-forums@pbjv6
Whole thread Raw
Responses Re: MoveToInsertRow on a table without a primary key  (Dave Cramer <pg@fastcrypt.com>)
List pgsql-jdbc
Hello all,

I have a table in a database that does not have a primary key.  In the process of migrating data from Oracle to
Postgres,I am using ResultSets to populate the Postgres tables. 

Basically, all is working well except for tables that do not have a primary key.  When I reach the "movetoinsertrow"
instructionin my code, the jdbc driver raises an exception about the missing primary key. 

The workaround would be to add a temporary primary key to such table, but I want to avoid that.  I did the same test
withHSQLDB and it works.  To me, it seems like a bug. 

I googled around for the solution, but found nothing.

Any tips?

pgsql-jdbc by date:

Previous
From: Kris Jurka
Date:
Subject: Re: oid int issue with CachedRowSet upgrading from JDBC 8.4 to 9.1
Next
From: Dave Cramer
Date:
Subject: Re: MoveToInsertRow on a table without a primary key