Re: how to find out whether a view is updatable

Поиск
Список
Период
Сортировка
От Dean Rasheed
Тема Re: how to find out whether a view is updatable
Дата
Msg-id CAEZATCX7bpH=G8PRz92CbDOwQgzsXDMTe5JHb-eTB_Y9=zcHjg@mail.gmail.com
обсуждение исходный текст
Ответ на Re: how to find out whether a view is updatable  (Tom Lane <tgl@sss.pgh.pa.us>)
Ответы Re: how to find out whether a view is updatable  (Peter Eisentraut <peter_e@gmx.net>)
Список 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 по дате отправления:

Предыдущее
От: Peter Eisentraut
Дата:
Сообщение: [PATCH] Remove useless USE_PGXS support in contrib
Следующее
От: Dean Rasheed
Дата:
Сообщение: Re: [9.3] Automatically updatable views vs writable foreign tables