[BUGS] pg_dumpall bug & feature request

2005-11-03 Thread Ivan
Hello, Perhaps you missed my previous message. pg_dumpall has not -f command line option to specify output file - it always send output to standart output. But there is an issue with it in Windows (I described it earlier) - function's line endings are changed from 0D 0A to 0D 0D 0A. Could you ple

Re: [BUGS] pg_dumpall bug & feature request

2005-11-03 Thread Alvaro Herrera
Ivan wrote: Hi, > Perhaps you missed my previous message. > pg_dumpall has not -f command line option > to specify output file - it always send output > to standart output. But there is an issue with > it in Windows (I described it earlier) - function's > line endings are changed from 0D 0A to 0D

[BUGS] BUG #2018: segfaults with some german errormessages

2005-11-03 Thread Bernhard Weisshuhn
The following bug has been logged online: Bug reference: 2018 Logged by: Bernhard Weisshuhn Email address: [EMAIL PROTECTED] PostgreSQL version: 8.1rc1 Operating system: Linux Description:segfaults with some german errormessages Details: Some errormessages from back

[BUGS] BUG #2017: column labels ignored on selects from views

2005-11-03 Thread Jolly Chen
The following bug has been logged online: Bug reference: 2017 Logged by: Jolly Chen Email address: [EMAIL PROTECTED] PostgreSQL version: 8.1RC1 Operating system: Mac OS X 10.4.3 Description:column labels ignored on selects from views Details: Note how the column lab

Re: [BUGS] pg_dumpall bug & feature request

2005-11-03 Thread Ivan
Hello Alvaro, Thursday, November 3, 2005, 3:28:41 PM, you wrote: AH> Ivan wrote: AH> Hi, >> Perhaps you missed my previous message. >> pg_dumpall has not -f command line option >> to specify output file - it always send output >> to standart output. But there is an issue with >> it in Windows (

Re: [BUGS] Failed CLUSTER seems to leave files behind

2005-11-03 Thread Tom Lane
Antti Salmela <[EMAIL PROTECTED]> writes: > Failed CLUSTER due to insufficient disk space seems to leave temporary files > behind at least on 7.4.7. What was the "failure" exactly? If you ran out of disk space for the data files, I'd have expected it to reclaim the temp files. On the other hand,

Re: [BUGS] BUG #2017: column labels ignored on selects from views

2005-11-03 Thread Tom Lane
"Jolly Chen" <[EMAIL PROTECTED]> writes: > testdb=# select sum as s from v1; > sum > - >3 > (1 row) Good catch. 8.0 and earlier get this right, so it's a regression we induced somewhere in 8.1 development ... wonder where? regards, tom lane

Re: [BUGS] pg_dumpall bug & feature request

2005-11-03 Thread Alvaro Herrera
Ivan wrote: Hi, > Thursday, November 3, 2005, 3:28:41 PM, you wrote: > >> Perhaps you missed my previous message. > >> pg_dumpall has not -f command line option > >> to specify output file - it always send output > >> to standart output. But there is an issue with > >> it in Windows (I described

Re: [BUGS] Failed CLUSTER seems to leave files behind

2005-11-03 Thread Antti Salmela
On Thu, Nov 03, 2005 at 10:03:16AM -0500, Tom Lane wrote: > Antti Salmela <[EMAIL PROTECTED]> writes: > > Failed CLUSTER due to insufficient disk space seems to leave temporary files > > behind at least on 7.4.7. > > What was the "failure" exactly? If you ran out of disk space for the > data file

Re: [BUGS] BUG #2017: column labels ignored on selects from views

2005-11-03 Thread Tom Lane
"Jolly Chen" <[EMAIL PROTECTED]> writes: > Description:column labels ignored on selects from views Fixed --- turns out the problem was in some recently-added code to eliminate unnecessary SubqueryScan nodes. The resnames attached to the SubqueryScan targetlist items have to be moved down

[BUGS] attislocal value changed with dump

2005-11-03 Thread elein
The problem is that after a dump and reload of a table hierarchy there are different values in pg_attribute.attislocal. A quick grep shows few references to attislocal. But I cannot say for sure it is unused since it is documented. However, I'm looking at a db diff tool and there it does matter.

Re: [BUGS] attislocal value changed with dump

2005-11-03 Thread Alvaro Herrera
Hi Elein, elein wrote: > The problem is that after a dump and reload of > a table hierarchy there are different values in > pg_attribute.attislocal. > > A quick grep shows few references to attislocal. > But I cannot say for sure it is unused since it is > documented. However, I'm looking at a

[BUGS] is this a bug or do I not understand the query planner?

2005-11-03 Thread Rob Prowel
two almost identical queries: one searches for read in ('N','n') and the other searches for read in ('Y','y'). the (explain) SQL statement says that one uses the index on the (read) field and the other does a sequential table scan. Why!!! I can think of no logical reason for this behav

Re: [BUGS] is this a bug or do I not understand the query planner?

2005-11-03 Thread Qingqing Zhou
"Rob Prowel" <[EMAIL PROTECTED]> wrote > two almost identical queries: one searches for > > read in ('N','n') > > and the other searches for > > read in ('Y','y'). > > the (explain) SQL statement says that one uses the > index on the (read) field and the other does a > sequential table scan. Why!

Re: [BUGS] is this a bug or do I not understand the query planner?

2005-11-03 Thread Peter Eisentraut
Rob Prowel wrote: > two almost identical queries: one searches for > read in ('N','n') > and the other searches for > read in ('Y','y'). > > the (explain) SQL statement says that one uses the > index on the (read) field and the other does a > sequential table scan. Why!!! I can think of no >

[BUGS] BUG #2019: tsearch2-related coredump

2005-11-03 Thread Bernhard Weisshuhn
The following bug has been logged online: Bug reference: 2019 Logged by: Bernhard Weisshuhn Email address: [EMAIL PROTECTED] PostgreSQL version: 8.1rc1 Operating system: Linux Fedora Core 4 x86_64 Description:tsearch2-related coredump Details: We could not yet repro