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

From Tom Lane
Subject Re: BUG #8154: pg_dump throws error beacause of field called "new".
Date
Msg-id 3145.1368455095@sss.pgh.pa.us
Whole thread Raw
In response to BUG #8154: pg_dump throws error beacause of field called "new".  (willybas@gmail.com)
Responses Re: BUG #8154: pg_dump throws error beacause of field called "new".  (Willy-Bas Loos <willybas@gmail.com>)
List pgsql-bugs
willybas@gmail.com writes:
> pg_dump (PostgreSQL) 9.1.9 ends in an error when backing up my db, which
> contains a field called "new".

Works for me:

regression=# create table new (f1 text, new text);
CREATE TABLE
regression=# insert into new (f1, new) values ('1','2');
INSERT 0 1
regression=# copy new(f1,new) to stdout;
1       2

You sure the server is 9.1?

            regards, tom lane

pgsql-bugs by date:

Previous
From: Tom Lane
Date:
Subject: Re: Inconsistency between TO_CHAR() and TO_NUMBER()
Next
From: Heikki Linnakangas
Date:
Subject: Re: Inconsistency between TO_CHAR() and TO_NUMBER()