Re: [GENERAL] Identify primary key in simple/updatable view

2013-08-02 Thread Richard Broersma
MS-Access lets the user specify which column is the Primary Key to avoid this introspection. On Fri, Aug 2, 2013 at 8:18 AM, Lionel Elie Mamane wrote: > Now that PostgreSQL has updatable views, users (of LibreOffice / > native PostgreSQL drivers) want to use them... LibreOffice needs a > primar

Re: [GENERAL] Identify primary key in simple/updatable view

2013-08-02 Thread Andrew Tipton
On Fri, Aug 2, 2013 at 11:18 PM, Lionel Elie Mamane wrote: > Now that PostgreSQL has updatable views, users (of LibreOffice / > native PostgreSQL drivers) want to use them... LibreOffice needs a > primary key to "locate" updates (that is, construct the WHERE clause > of an UPDATE or DELETE). > > [