Re: SELECT updatability clause defective.

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: SELECT updatability clause defective.
Дата
Msg-id 4315.989589461@sss.pgh.pa.us
обсуждение исходный текст
Ответ на RE: SELECT updatability clause defective.  ("Jerome O'Neil" <joneil@combimatrix.com>)
Список pgsql-bugs
"Jerome O'Neil" <joneil@combimatrix.com> writes:
> Which makes me wonder:  What is the point, if not to
> restrict updatability?

Postgres' SELECT FOR UPDATE marks rows for update, not columns.
Thus nominating columns in it would make no sense.

It was probably an unfortunate decision to use "FOR UPDATE" as
the syntax for this feature, since the spec uses that phrase
to deal with something completely different.  But we're not gonna
change it now, especially since it's not getting in the way of
adding support for the spec's feature.

            regards, tom lane

В списке pgsql-bugs по дате отправления:

Предыдущее
От: Tom Lane
Дата:
Сообщение: Re: Alter table add column ignores default
Следующее
От: Thomas Lockhart
Дата:
Сообщение: Re: createdb test shown as number in data directory