BUG #8154: pg_dump throws error beacause of field called "new". - Mailing list pgsql-bugs

From willybas@gmail.com
Subject BUG #8154: pg_dump throws error beacause of field called "new".
Date
Msg-id E1UbtIW-0006k7-Mw@wrigleys.postgresql.org
Whole thread Raw
Responses Re: BUG #8154: pg_dump throws error beacause of field called "new".  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-bugs
The following bug has been logged on the website:

Bug reference:      8154
Logged by:          Willy-Bas Loos
Email address:      willybas@gmail.com
PostgreSQL version: 9.1.9
Operating system:   ubuntu 12.04 server
Description:        =


pg_dump (PostgreSQL) 9.1.9 ends in an error when backing up my db, which
contains a field called "new".

Here's the raised message:
pg_dump: SQL command failed
pg_dump: Error message from server: ERROR:  syntax error at or near "new"
LINE 1: ...ag, beginmaand, einddag, eindmaand, fusieafstand, new, opmer...
                                                             ^
pg_dump: The command was: COPY lsb.zsoorten (id, euringchar, begindag,
beginmaand, einddag, eindmaand, fusieafstand, new, opmerkingen, euring) TO
stdout;

pgsql-bugs by date:

Previous
From: marc@intershop.de
Date:
Subject: BUG #8153: check constraint results in a lot of casts
Next
From: Tom Lane
Date:
Subject: Re: Inconsistency between TO_CHAR() and TO_NUMBER()