Re: [BUGS] BUG #8154: pg_dump throws error beacause of field called new.

2013-07-29 Thread Jeff Janes 
On Wed, Jul 24, 2013 at 5:18 AM, Willy-Bas Loos willy...@gmail.com wrote:
 Hi,

 The manual says:
 It is recommended that you use the pg_dump and pg_dumpall programs from the
 newer version of PostgreSQL, to take advantage of enhancements that might
 have been made in these programs. Current releases of the dump programs can
 read data from any server version back to 7.0.
 http://www.postgresql.org/docs/9.1/static/upgrading.html

 That means that this actually should work.

It will work if you use the --quote-all-identifiers option.

Cheers,

Jeff


-- 
Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-bugs

Re: [BUGS] BUG #8154: pg_dump throws error beacause of field called new.

2013-07-24 Thread Willy-Bas Loos 
Hi,

The manual says:
It is recommended that you use the pg_dump and pg_dumpall programs from the
newer version of PostgreSQL, to take advantage of enhancements that might
have been made in these programs. Current releases of the dump programs can
read data from any server version back to 7.0.
http://www.postgresql.org/docs/9.1/static/upgrading.html

That means that this actually should work.

Cheers,

WBL



On Mon, May 13, 2013 at 5:43 PM, Willy-Bas Loos willy...@gmail.com wrote:

 oh, silly me.
 I was making a dump of a  PostgreSQL 8.4.17 backend with pg_dump
 (PostgreSQL) 9.1.9


 On Mon, May 13, 2013 at 4:24 PM, Tom Lane t...@sss.pgh.pa.us wrote:

 willy...@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




 --
 Quality comes from focus and clarity of purpose -- Mark Shuttleworth




-- 
Quality comes from focus and clarity of purpose -- Mark Shuttleworth

[BUGS] BUG #8154: pg_dump throws error beacause of field called new.

2013-05-13 Thread willybas 
The following bug has been logged on the website:

Bug reference:  8154
Logged by:  Willy-Bas Loos
Email address:  willy...@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;




-- 
Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-bugs

Re: [BUGS] BUG #8154: pg_dump throws error beacause of field called new.

2013-05-13 Thread Tom Lane 
willy...@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


-- 
Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-bugs

Re: [BUGS] BUG #8154: pg_dump throws error beacause of field called new.

2013-05-13 Thread Willy-Bas Loos 
oh, silly me.
I was making a dump of a  PostgreSQL 8.4.17 backend with pg_dump
(PostgreSQL) 9.1.9


On Mon, May 13, 2013 at 4:24 PM, Tom Lane t...@sss.pgh.pa.us wrote:

 willy...@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




-- 
Quality comes from focus and clarity of purpose -- Mark Shuttleworth