Re: how to find out whether a view is updatable

From: Michael Paquier <michael(dot)paquier(at)gmail(dot)com>
To: Peter Eisentraut <peter_e(at)gmx(dot)net>
Cc: pgsql-hackers <pgsql-hackers(at)postgresql(dot)org>
Subject: Re: how to find out whether a view is updatable
Date: 2013-06-04 22:35:15
Message-ID: CAB7nPqQnkDxcn5ByjddZ-wKJCdCNDeT8rKP9gK-=nV7LpqYsgg@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

On Wed, Jun 5, 2013 at 12:59 AM, Peter Eisentraut <peter_e(at)gmx(dot)net> wrote:

> I was looking for a way in which the average psql user could learn
> whether a view is updatable. I was expecting something in \d, \d+, \dv,
> \dv+, or a NOTICE from CREATE VIEW. So far, the only way appears to be
> through the information schema or the underlying pg_view_is_updatable
> function. Not even pg_views shows anything. Is this intentional or an
> oversight?
>
Just by recalling the thread, an oversight. Having this information in ¥dv+
would
be indeed a nice addition.
--
Michael

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message amul sul 2013-06-05 00:43:14 Re: create a git symbolic-ref for REL9_3_STABLE
Previous Message Tom Lane 2013-06-04 21:23:36 Re: Improved error message for CREATE EXTENSION patch...