Re: [BUGS] postgresql-9.1.4 macosx-10.6.8 (hostssl) psql -h hostname crashes

2012-07-31 Thread Tom Lane
raf writes: > i've just upgraded to 9.1.4 on macosx-10.6.8 and psql crashes > whenever the -h option is used (either with "localhost" or any > other hostname). i only have hostssl connections. > attached is a macosx crash report in case it helps. [ squint ... ] There's something awfully fishy a

[BUGS] BUG #6788: Can't compile on mingw64-w32

2012-07-31 Thread lr
The following bug has been logged on the website: Bug reference: 6788 Logged by: Regina Obe Email address: l...@pcorp.us PostgreSQL version: 9.1.4 Operating system: Mingw64-w32 chain Description: I can compile 9.2beta and 9.3 snapshot fine with my mingw64-w32 chain (

Re: [BUGS] BUG #6787: Query planner estimates worng costs on nodes

2012-07-31 Thread Tom Lane
gsavi...@gmail.com writes: > It seems the cost assigned to a sequential scan over 120 million records is > too low or, on the other side, the cost assigned to two nested loop over > three indexes is too high. It looks from here like you are measuring a situation where vb_product_readings is fully

[BUGS] BUG #6787: Query planner estimates worng costs on nodes

2012-07-31 Thread gsaviane
The following bug has been logged on the website: Bug reference: 6787 Logged by: Giorgio Saviane Email address: gsavi...@gmail.com PostgreSQL version: 8.4.12 Operating system: Linux Description: Hi, I would submit the explain analayze results of a query with and witho

[BUGS] BUG #6786: postgresql installed with mingw

2012-07-31 Thread manojk . softengineer
The following bug has been logged on the website: Bug reference: 6786 Logged by: manoj Email address: manojk.softengin...@gmail.com PostgreSQL version: 8.3.13 Operating system: windows Description: pg_regress: initdb failed Examine ./log/initdb.log for the reason. Co

Re: [BUGS] BUG #6751: usage flaws in pg_restore

2012-07-31 Thread Marti Raudsepp
On Tue, Jul 24, 2012 at 3:45 PM, wrote: > We've been using PostgreSQL for years now. > It's great. > Only the usage of pg_restore is annoying > (Version 8.3 to 9.1 tested). > Given Answer: > pg_restore: [archiver] input file does not appear to be a valid archive This has already been fixed. Po

Re: [BUGS] Error on pg_settings.bytea_output for pg9.1

2012-07-31 Thread Guillaume Lelarge
On Tue, 2012-07-31 at 14:06 +0800, Craig Ringer wrote: > On 07/31/2012 01:50 PM, Guillaume Lelarge wrote: > >> Check the PgAdmin-III preferences; there may be an option to control its > >> preferred bytea format. > >> > > There's no option to control this. > > > Thanks for confirming that. > > Is