View Single Post

   
  #8 (permalink)  
Old 04-16-2008, 01:59 AM
Andrew Lazarus
 
Posts: n/a
Default Re: 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

Reply With Quote