pgsql: Cause ALTER TABLE to perform ALTER COLUMN DROP DEFAULT operations

Поиск
Список
Период
Сортировка
От tgl@postgresql.org (Tom Lane)
Тема pgsql: Cause ALTER TABLE to perform ALTER COLUMN DROP DEFAULT operations
Дата
Msg-id 20060803205706.DC9C29FB0D1@postgresql.org
обсуждение исходный текст
Список pgsql-committers
Log Message:
-----------
Cause ALTER TABLE to perform ALTER COLUMN DROP DEFAULT operations during
the DROP pass rather than the ADD_CONSTR pass.  On examining the code I
think this was just an oversight rather than intentional, and it seems
to satisfy the principle of least surprise better than the alternative
solution that was discussed.  Add an example to the ref page showing how
to do ALTER TYPE and update the default in one command.  Per gripe from
Markus Bertheau that that wasn't possible.

Modified Files:
--------------
    pgsql/doc/src/sgml/ref:
        alter_table.sgml (r1.87 -> r1.88)
        (http://developer.postgresql.org/cvsweb.cgi/pgsql/doc/src/sgml/ref/alter_table.sgml.diff?r1=1.87&r2=1.88)
    pgsql/src/backend/commands:
        tablecmds.c (r1.198 -> r1.199)
        (http://developer.postgresql.org/cvsweb.cgi/pgsql/src/backend/commands/tablecmds.c.diff?r1=1.198&r2=1.199)

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

Предыдущее
От: tgl@postgresql.org (Tom Lane)
Дата:
Сообщение: pgsql: Remove use of a regex character class in resultmap (for freebsd
Следующее
От: gsmet@pgfoundry.org (User Gsmet)
Дата:
Сообщение: pgfouine - pgfouine: * [vacuum] improved the layout * [vacuum] fixed the