Re: [BUGS] BUG #5695: select into duplicates oid when using order by int

2010-10-06 Thread Tom Lane
"Andreas Barth" writes: > PostgreSQL version: 8.3.11 > Description:select into duplicates oid when using order by int Hmm, interesting. I doubt we'll try to change this, since the problem doesn't occur in 8.4 or later, and anybody still using 8.3 or before probably values stability over

[BUGS] BUG #5695: select into duplicates oid when using order by int

2010-10-06 Thread Andreas Barth
The following bug has been logged online: Bug reference: 5695 Logged by: Andreas Barth Email address: aba+postgre...@not.so.argh.org PostgreSQL version: 8.3.11 Operating system: Debian Linux (amd64) Description:select into duplicates oid when using order by int Detail

Re: [BUGS] PGDUMP Bug

2010-10-06 Thread Tom Lane
"Kevin Grittner" writes: > "Satheesan K Nair" wrote: >> C:\pgsql\bin>pg_dump.exe -h dbserver -p 5432 -U streamline -F c -v >> -f "C:\backup\wrm_batch.backup" -t wrm_batch -n "Jay Jay Mills >> Lanka (Private) Limited" "16mar10" > I don't know about Windows, but on Linux you would need apostrophe

Re: [BUGS] PGDUMP Bug

2010-10-06 Thread Kevin Grittner
"Satheesan K Nair" wrote: > C:\pgsql\bin>pg_dump.exe -h dbserver -p 5432 -U streamline -F c -v > -f "C:\backup\wrm_batch.backup" -t wrm_batch -n "Jay Jay Mills > Lanka (Private) Limited" "16mar10" I don't know about Windows, but on Linux you would need apostrophe quoting around the double-quot

[BUGS] PGDUMP Bug

2010-10-06 Thread Satheesan K Nair
Dear PGSQL Master, I have a data base in PostgreSql 8.1 version. I have created an Additional Schema named "Jay Jay Mills Lanka (Private) Limited". There is 475 tables in this schema and I want to take table-wise backup. But its giving the error. Please refer below command line. C:\pgsql\bin