Re: Update ResultSet - Mailing list pgsql-jdbc

From Andrew Lazarus
Subject Re: Update ResultSet
Date
Msg-id 46688274.20080112204738@attglobal.net
Whole thread Raw
In response to Re: Update ResultSet  (tivvpgsqljdbc@gtech-ua.com)
List pgsql-jdbc
Wednesday, October 10, 2007, 5:39:47 AM, you wrote:

> Hi.

> I'd create an updatable server-side view and issue select against it.
> Not sure if primary key information will be propagated, but you can try.

I've found that a column in a view named "oid" is automatically
assumed to be a primary key. (You can see the special case in the JDBC
code.) So I include such a column in an updatable view.
--
Best regards,
 Andrew                            mailto:drlaz@attglobal.net


pgsql-jdbc by date:

Previous
From: Oliver Jowett
Date:
Subject: Re: Is it safe to use 8.0.14 server and 7.4 driver ?
Next
From: Magne Mæhre
Date:
Subject: Re: Is it safe to use 8.0.14 server and 7.4 driver ?