Re: grouping treated as keyword in function return table

On Tue, 12 Jul 2016, Tom Lane wrote:
> Mike Porter <mike@udel.edu> writes:
>> On Tue, 12 Jul 2016, Tom Lane wrote:
>>> Only since 9.5, because GROUPING wasn't a keyword before that.
>>> Sure you're using 9.5 pg_dump?
>
>> My notes say so.
>> /usr/local/postgresql-9.5.3/bin/pg_dumpall -h a.server -U postgres > 9.5.3.sql
>
> Hm, is the source server 9.5?  I think that the TABLE clause is actually
> generated server-side in this case.

The source server is 9.3.5 (9.3...)

> When you're making a dump you intend to load into a different server
> version, we recommend using --quote-all-identifiers to make sure you're
> not blindsided by identifiers that have become reserved words in the
> newer server version.

Great advice.  Thanks, Mike

>
>             regards, tom lane
>

-
Mike Porter
PGP Fingerprint: F4 AE E1 9F 67 F7 DA EA  2F D2 37 F3 99 ED D1 C2