Re: moveToInsertRow SQL Exception "No Primary Keys"

> Further more, creating the table exactly as you have it, also works

Oh joy. So, my problem is platform-dependent, it seems.

*SOMETHING* is going wrong on my system with the ability of the JDBC
driver to detect the primary key. Do you have any suggestions for what I
can do to try to trace this problem?

There is an interesting JDBC client called SQuirrel SQL. When I aim
this at the database in question and inspect the table coffees, under
the Primarary Key tab it does show my key as being there. The view
has a column called table_cat, and the value showing there is

<Other>

-- I have no idea if this is normal or not. Under table_schem it
shows public, it shows the right table name and column name, under
key_seq it shows 1, under pk_name it shows pi_coffees.

I sure would like to get this fixed. I really wanna be using
updatable result sets, but at the moment this problem has me stopped
cold. Any suggestions for things I can try to diagnose the problem
would be welcome. I'm using the Mac OS X PostgreSQL distribution from
www.entropy.ch, which is one of the more commonly used OS X packages
I think.

-Thanks, Jim

---
Jim Rosenberg http://www.well.com/user/jer/
WELL: jer
Internet: jr(at)amanue(dot)com