Re: how to find out whether a view is updatable - Mailing list pgsql-hackers

From Dean Rasheed
Subject Re: how to find out whether a view is updatable
Date
Msg-id CAEZATCX7bpH=G8PRz92CbDOwQgzsXDMTe5JHb-eTB_Y9=zcHjg@mail.gmail.com
Whole thread Raw
In response to Re: how to find out whether a view is updatable  (Tom Lane <tgl@sss.pgh.pa.us>)
Responses Re: how to find out whether a view is updatable
List pgsql-hackers
On 12 June 2013 23:01, Tom Lane <tgl@sss.pgh.pa.us> wrote:
> Dean Rasheed <dean.a.rasheed@gmail.com> writes:
>> [ pg_relation_is_updatable.patch ]
>
> I've committed this with some modifications as mentioned.  There is
> still room to debate exactly what
> information_schema.columns.is_updatable means --- we can now change that
> without an initdb.
>

Thanks. Those modifications all look pretty neat.

I'm inclined to stick with the current definition of what updatable
means in the information schema. I'm not entirely convinced that other
possible interpretations of the spec are any more valid, and it
certainly doesn't seem worth another initdb or a break with backwards
compatibility by changing it. At least we now have functions that can
give a more intuitive result for updatability.

Regards,
Dean



pgsql-hackers by date:

Previous
From: Peter Eisentraut
Date:
Subject: [PATCH] Remove useless USE_PGXS support in contrib
Next
From: Dean Rasheed
Date:
Subject: Re: [9.3] Automatically updatable views vs writable foreign tables