Re: No Primary Keys (pg7.4.2 on SLES9)

On Mon, 3 Apr 2006, Vidas Makauskas wrote:

> I get error NO PRIMARY KEY from prs.moveToInsertRow();
>
> Postgres 7.4.2 on with /usr/share/pgsql/pg73b1jdbc3.jar
>
>  Statement st = pg.createStatement(ResultSet.TYPE_SCROLL_SENSITIVE,
> ResultSet.CONCUR_UPDATABLE);
>  st.executeUpdate("CREATE TABLE public.testas (loid integer PRIMARY KEY)
> WITHOUT OIDS");
>  ResultSet prs = st.executeQuery("SELECT p.* FROM public.testas p");
> prs.moveToInsertRow();

Older JDBC drivers do not support schema qualified table names for
updatable result sets.  Try a newer version:

http://jdbc.postgresql.org/download.html

Kris Jurka