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

Поиск
Список
Период
Сортировка
От Kevin Grittner
Тема Re: BUG #5488: pg_dump does not quote column names -> pg_restore may fail when upgrading
Дата
Msg-id 4C108A40020000250003210C@gw.wicourts.gov
обсуждение исходный текст
Ответы Re: BUG #5488: pg_dump does not quote column names -> pg_restore may fail when upgrading
Список pgsql-bugs
Hartmut Goebel  wrote:

> re. 1): While this may be true for many applications it is using
> hand-crafted SQL statements, it is plain wrong for all applications
> using some abstraction layer. These layers need to quote column
> names anyway and the application does not need to be changed here
> at all.

I have a feeling that many here don't understand how ubiquitous such
frameworks are.  Our programmers have no way to get a statement to
the database from within the application *without* all identifiers
being quoted.

On the other hand, my conversion software has always been a command
line with pg_dump piped to psql.  (We are making our first test of
Bruce's new techniques this week, though.)

-Kevin

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

Предыдущее
От: Russell Smith
Дата:
Сообщение: Re: pg_restore ignores -C when using a restore list -L
Следующее
От: Hartmut Goebel
Дата:
Сообщение: Re: BUG #5488: pg_dump does not quote column names -> pg_restore may fail when upgrading