On Fri, May 20, 2016 at 12:58 PM, <alejandro@cartodb.com> wrote:
> - On that database run: CREATE TABLE test(foo int, "over" test, bar int);.
> Note that "over" is a keyword which apparently went from reserved to
> non-reserved on 9.4 release.
> - Use a 9.5.3 pg_dump to dump the database.
>
> It fails with:
>
> pg_dump: [archiver (db)] query failed: ERROR: syntax error at or near
> "over"
> LINE 1: COPY public.test (foo, over, bar) TO stdout;
> ^
> pg_dump: [archiver (db)] query was: COPY public.test (foo, over, bar) TO
> stdout;
>
> Using a 9.3 pg_dump will quote the "over" column name and properly finish
> the dump.
... or use the --quote-all-identifiers option of 9.5 pg_dump.
http://www.postgresql.org/docs/9.5/static/app-pgdump.html
Not a bug.
--
Kevin Grittner
EDB: http://www.enterprisedb.com
The Enterprise PostgreSQL Company