Re: [BUGS] need higher extra_float_digits value (3)

2009-09-11 Thread Tom Lane
Keh-Cheng Chu writes: > I have been running a locally modified postgresql server with > extra_float_digits' upper limit increased by one to 3 and a > modified pg_dump which sets extra_float_digits to 3; I have > verified that the modification does what I need and it does > not seem to have any s

[BUGS] BUG #5049: query crashing backend with TRAP: FailedAssertion

2009-09-11 Thread Thomas
The following bug has been logged online: Bug reference: 5049 Logged by: Thomas Email address: m...@alternize.com PostgreSQL version: 8.4.0 Operating system: Debian lenny Description:query crashing backend with TRAP: FailedAssertion Details: while trying out the que

Re: [BUGS] BUG #5049: query crashing backend with TRAP: FailedAssertion

2009-09-11 Thread Tom Lane
"Thomas" writes: > while trying out the queries from > http://radek.cc/2009/09/05/psqlrc-tricks-indexes/, i found the 2nd one > crashing the database backend: Fixed, thanks. It seems to get the right answers if assertions aren't enabled, so that may be why it hadn't been reported already.

Re: [BUGS] BUG #5038: WAL file is pending deletion in pg_xlog folder, this interferes with WAL archiving.

2009-09-11 Thread Luke Koops
I picked up the patch and verified both fixes on 8.3.7. In one test, Handles to two different WAL files were being held by two different backends. The WAL files were renamed to .deleted after I forced a switch xlog. Eventually the .deleted files disappeared. In one case the backend exited.