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 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 > > > -- > Sent via pgsql-general mailing list (pgsql-general@postgresql.org) > To make changes to your subscription: > http://www.postgresql.org/mailpref/pgsql-general > -- Regards, Richard Broersma Jr.