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

From: Hartmut Goebel <h(dot)goebel(at)goebel-consult(dot)de>
To: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
Cc: pgsql-bugs(at)postgresql(dot)org
Subject: Re: BUG #5488: pg_dump does not quote column names -> pg_restore may fail when upgrading
Date: 2010-06-04 08:29:23
Message-ID: 4C08B963.4080906@goebel-consult.de
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

Am 03.06.2010 16:15, schrieb Tom Lane:

>> Solution: pg_dump should quote *all* column-names, no matter if they are
>> keywords or not.
>
> That was considered and rejected long ago. Readability of the dump
> script is something that we put a nonzero value on.

Sorry, I do not understand this.

I assume you mean readability for humans?!

So if readability is not important, what speaks against always quoting
the column names?

--
Schönen Gruß - Regards
Hartmut Goebel
Dipl.-Informatiker (univ.), CISSP, CSSLP

Goebel Consult
Spezialist für IT-Sicherheit in komplexen Umgebungen
http://www.goebel-consult.de

Monatliche Kolumne: http://www.cissp-gefluester.de/
Goebel Consult mit Mitglied bei http://www.7-it.de

In response to

Responses

Browse pgsql-bugs by date

  From Date Subject
Next Message Hartmut Goebel 2010-06-04 08:47:08 Re: BUG #5488: pg_dump does not quote column names -> pg_restore may fail when upgrading
Previous Message Robert Haas 2010-06-04 03:03:02 Re: Support on Postgres Database Corruption