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 <lionel@mamane.lu> 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).
How can the driver automatically identify the view columns that correspond to the primary key of the underlying table (and more generally the same for keys and indexes)? For "simple" views. Without parsing the SQL that defines the view (unless libpq will serve me a parse tree? Didn't think so.).
For tables, it does that by reading from pg_constraint, but to use that for views, I'd need to parse the SQL, track renamed columns, etc.
Thanks in advance for your precious help, -- Lionel
