Re: BUG #14152: pg_dump does not take into account previous versions reserved keywords as column names

From: Michael Paquier <michael(dot)paquier(at)gmail(dot)com>
To: John R Pierce <pierce(at)hogranch(dot)com>
Cc: PostgreSQL mailing lists <pgsql-bugs(at)postgresql(dot)org>
Subject: Re: BUG #14152: pg_dump does not take into account previous versions reserved keywords as column names
Date: 2016-05-20 18:12:33
Message-ID: CAB7nPqQAV8qDpqZsMrOfGdgmSOP88BexZzotGeyerBSFde=6Bw@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

On Fri, May 20, 2016 at 2:02 PM, John R Pierce <pierce(at)hogranch(dot)com> wrote:
> pg_dump and pg_dumpall are supposed to be able to dump all supported prior
> versions, thats the documented procedure for updating... I contend this
> *is* a bug. quote-all-identifiers is a workaround, for sure.

Well, --quote-all-identifiers is here to handle the case of new
keywords introduced. Let's use that and call it a day.
--
Michael

In response to

Browse pgsql-bugs by date

  From Date Subject
Next Message Tom Lane 2016-05-20 18:25:02 Re: BUG #14152: pg_dump does not take into account previous versions reserved keywords as column names
Previous Message David G. Johnston 2016-05-20 18:11:53 Re: BUG #14152: pg_dump does not take into account previous versions reserved keywords as column names