Re: UPDATE ... SET = DEFAULT

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: UPDATE ... SET = DEFAULT
Дата
Msg-id 16959.1054845947@sss.pgh.pa.us
обсуждение исходный текст
Ответ на UPDATE ... SET = DEFAULT  (Rod Taylor <rbt@rbt.ca>)
Ответы Re: UPDATE ... SET = DEFAULT  (Rod Taylor <rbt@rbt.ca>)
Список pgsql-hackers
Rod Taylor <rbt@rbt.ca> writes:
> It would seem a new primnode (change InsertDef into SetDefault or
> similar) will be required with some executor logic.

It is not the executor's business to know about defaults.  The rewriter
is the place where defaults get inserted - see rewriteTargetList().

Note that default NULL will have to be treated a little differently from
what we do for INSERT, since the, um, default behavior of UPDATE is to
preserve columns rather than replace 'em with nulls.
        regards, tom lane


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

Предыдущее
От: Alvaro Herrera Munoz
Дата:
Сообщение: Re: default locale considered harmful? (was Re: [GENERAL]
Следующее
От: Josh Berkus
Дата:
Сообщение: Re: Proposal to Re-Order Postgresql.Conf, part II