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

"David G. Johnston" <david(dot)g(dot)johnston(at)gmail(dot)com> writes:
> 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.

> 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