Identify primary key in simple/updatable view
| От | Lionel Elie Mamane |
|---|---|
| Тема | Identify primary key in simple/updatable view |
| Дата | |
| Msg-id | 20130802151811.GD6816@capsaicin.mamane.lu обсуждение |
| Ответы |
Re: Identify primary key in simple/updatable view
Re: Identify primary key in simple/updatable view |
| Список | pgsql-general |
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
В списке pgsql-general по дате отправления: