Re: moveToInsertRow SQL Exception "No Primary Keys"

From: Barry Lind <blind(at)xythos(dot)com>
To: Jim Rosenberg <jr(at)amanue(dot)com>
Cc: Dave Cramer <Dave(at)micro-automation(dot)net>, pgsql-jdbc(at)postgresql(dot)org
Subject: Re: moveToInsertRow SQL Exception "No Primary Keys"
Date: 2003-02-06 16:59:41
Message-ID: 3E42947D.9070504@xythos.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-jdbc

Jim,

As Dave said in his email, he tested against current CVS. And since
there have been some bug fixes in this area recently it could be that
the bug is already fixed and that is why Dave can't reproduce. Have you
tried pulling the current sources from CVS and tried testing with those?

thanks,
--Barry

Jim Rosenberg wrote:
>>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
>
> ---------------------------(end of broadcast)---------------------------
> TIP 3: if posting/reading through Usenet, please send an appropriate
> subscribe-nomail command to majordomo(at)postgresql(dot)org so that your
> message can get through to the mailing list cleanly
>

In response to

Browse pgsql-jdbc by date

  From Date Subject
Next Message Barry Lind 2003-02-06 17:02:24 Re: Timestamp problems
Previous Message Jim Rosenberg 2003-02-06 16:50:16 Re: moveToInsertRow SQL Exception "No Primary Keys"