Re: how to find out whether a view is updatable

From: Peter Eisentraut <peter_e(at)gmx(dot)net>
To: Dean Rasheed <dean(dot)a(dot)rasheed(at)gmail(dot)com>
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 17:12:59
Message-ID: 51C1E69B.6010202@gmx.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

On 6/19/13 11:50 AM, Dean Rasheed wrote:
> 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.

I would be satisfied with no, yes, no, no. Although I don't know what
tab completion changes you have in mind.

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Peter Eisentraut 2013-06-19 17:14:11 Re: Bugfix and new feature for PGXS
Previous Message Josh Berkus 2013-06-19 17:12:40 Re: How do we track backpatches?