Re: how to find out whether a view is updatable

From: Dean Rasheed <dean(dot)a(dot)rasheed(at)gmail(dot)com>
To: Peter Eisentraut <peter_e(at)gmx(dot)net>
Cc: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>, Michael Paquier <michael(dot)paquier(at)gmail(dot)com>, pgsql-hackers <pgsql-hackers(at)postgresql(dot)org>
Subject: Re: how to find out whether a view is updatable
Date: 2013-06-19 15:50:51
Message-ID: CAEZATCVsCf7k-BkUtkFYJCbCkG_0v1YRvAV5EySfcXMw4HYbiA@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

On 19 June 2013 15:22, Peter Eisentraut <peter_e(at)gmx(dot)net> wrote:
> We still don't have any support for this in psql, do we?
>

No, but at least we now have an API that psql can use.

There are still a number of questions about the best way to display it in psql.
Should it be another column in \d+'s list of relations?
Should it appear in \d+ for a single relation?
Should it distinguish updatable from insertable and deletable?
Should tab-completion also be modified?

Currently I'm thinking yes, yes, no, yes.

Regards,
Dean

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Claudio Freire 2013-06-19 16:02:31 Re: Implementing incremental backup
Previous Message Kevin Grittner 2013-06-19 15:41:23 Re: Git-master regression failure