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

From Kevin Grittner
Subject Re: BUG #5488: pg_dump does not quote column names -> pg_restore may fail when upgrading
Date
Msg-id 4C108A40020000250003210C@gw.wicourts.gov
Whole thread Raw
Responses Re: BUG #5488: pg_dump does not quote column names -> pg_restore may fail when upgrading  (Hartmut Goebel <h.goebel@goebel-consult.de>)
List 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 by date:

Previous
From: Russell Smith
Date:
Subject: Re: pg_restore ignores -C when using a restore list -L
Next
From: Hartmut Goebel
Date:
Subject: Re: BUG #5488: pg_dump does not quote column names -> pg_restore may fail when upgrading