[GENERAL] Identify primary key in simple/updatable view

2013-08-02 Thread Lionel Elie Mamane
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). How can the driver automatically identify the view columns that

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 lio...@mamane.luwrote: 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

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 lio...@mamane.lu wrote: Now that PostgreSQL has updatable views, users (of LibreOffice / native PostgreSQL drivers) want to use them... LibreOffice