BUG #5488: pg_dump does not quote column names -> pg_restore may fail when upgrading

Поиск
Список
Период
Сортировка
От Hartmut Goebel
Тема BUG #5488: pg_dump does not quote column names -> pg_restore may fail when upgrading
Дата
Msg-id 201006031326.o53DQt56017667@wwwmaster.postgresql.org
обсуждение исходный текст
Ответы Re: BUG #5488: pg_dump does not quote column names -> pg_restore may fail when upgrading
Re: BUG #5488: pg_dump does not quote column names -> pg_restore may fail when upgrading
Список pgsql-bugs
The following bug has been logged online:

Bug reference:      5488
Logged by:          Hartmut Goebel
Email address:      h.goebel@goebel-consult.de
PostgreSQL version: 8.3 / 8.4
Operating system:   all
Description:        pg_dump does not quote column names -> pg_restore may
fail when upgrading
Details:

If a 8.3 table contains a column named "window", the dump can not be
restored into a 8.4 database. Reasons: a) "window" is a new keyword in 8.4
b) pg_dump does not quote column names.

This is a generic problem with pg_dump. Since it does not quote all column
names, pg_restore may fail whenever migrating to a new version.

Solution: pg_dump should quote *all* column-names, no matter if they are
keywords or not.

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

Предыдущее
От: Heikki Linnakangas
Дата:
Сообщение: Re: Server crash while trying to read expression using pg_get_expr()
Следующее
От: "Kevin Grittner"
Дата:
Сообщение: Re: BUG #5488: pg_dump does not quote column names -> pg_restore may fail when upgrading