Re: BUG #14152: pg_dump does not take into account previous versions reserved keywords as column names - Mailing list pgsql-bugs

From Tom Lane
Subject Re: BUG #14152: pg_dump does not take into account previous versions reserved keywords as column names
Date
Msg-id 54607.1463768702@sss.pgh.pa.us
Whole thread Raw
In response to Re: BUG #14152: pg_dump does not take into account previous versions reserved keywords as column names  ("David G. Johnston" <david.g.johnston@gmail.com>)
Responses Re: BUG #14152: pg_dump does not take into account previous versions reserved keywords as column names
List pgsql-bugs
"David G. Johnston" <david.g.johnston@gmail.com> writes:
> On Fri, May 20, 2016 at 2:02 PM, John R Pierce <pierce@hogranch.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.

> If indeed the prescribed procedure is quote-all-identifiers I'd say we
> should at least update the docs.

Yeah, agreed.  I'll put something in.

Alternatively, we could automatically turn on quote-all-identifiers when
dumping from a server of a different major version; but I imagine we'd
get complaints about that, too, since it's so seldom an issue.

            regards, tom lane

pgsql-bugs by date:

Previous
From: Michael Paquier
Date:
Subject: Re: BUG #14152: pg_dump does not take into account previous versions reserved keywords as column names
Next
From: "David G. Johnston"
Date:
Subject: Re: BUG #14152: pg_dump does not take into account previous versions reserved keywords as column names