Re: [JDBC] Update ResultSet

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


---------------------------(end of broadcast)---------------------------
TIP 2: Don't 'kill -9' the postmaster