Re: [BUGS] Regression from 8.4 to 9.1.2/9.1.3: Optimizing filters on constants in unions

2012-03-19 Thread Claus Stadler
Cool, thank you very much. Cheers, Claus On 03/16/2012 06:17 PM, Tom Lane wrote: Claus Stadler writes: Filtering a Union on constant custom type: ... Expected: Query optimizer should discard the scan as filter cannot be satisfied. I've applied a patch for this. Thanks for the report!

Re: [BUGS] Applicatin crashing with on postgresql 8.1 service restart

2012-03-19 Thread Kevin Grittner
prem tolani wrote: > I running an applicatio in java with postgresql 8.1. > I am using windows 7. Version 8.1 has been unsupported on Windows for four years. That's before Windows 7 even came out, so that combination has *never* been supported. Upgrade to a supported environment and you sh

[BUGS] BUG #6542: installation error

2012-03-19 Thread f . delcroix
The following bug has been logged on the website: Bug reference: 6542 Logged by: DELCROIX Frédéric Email address: f.delcr...@rdvnet.fr PostgreSQL version: 9.0.7 Operating system: windows Xp/vista/seven Description: When I install postgresql, some vbs script returns m

Re: [BUGS] BUG #6510: A simple prompt is displayed using wrong charset

2012-03-19 Thread Alvaro Herrera
Excerpts from Alexander LAW's message of dom mar 18 06:04:51 -0300 2012: > I see two ways to resolve the issue. > First is to use CharToOemBuff when writing a string to the "con" and > OemToCharBuff when reading an input from it. > The other is to always use stderr/stdin for Win32 as it was done

Re: [BUGS] BUG #6511: calling spi_exec_query from non-main package, results in: couldn't fetch $_TD

2012-03-19 Thread Alvaro Herrera
Excerpts from Alex Hunsaker's message of mié mar 07 01:08:25 -0300 2012: > On Sat, Mar 3, 2012 at 12:19, wrote: > Yeah, there were some optimization done for 9.1 to try and make calls > a bit faster. The problem is we are fetching "_TD" not "main::_TD", > which means we try to find and use $_TD

[BUGS] BUG #6543: pgadmin III - Error defining filter.

2012-03-19 Thread kebe . 1969
The following bug has been logged on the website: Bug reference: 6543 Logged by: Cleberson Email address: kebe.1...@gmail.com PostgreSQL version: 9.1.3 Operating system: Windows 7 Description: When you create a column name with uppercase ( idCustomer ) you can´t defin

Re: [BUGS] BUG #6535: LEFT JOIN on large table is altering data

2012-03-19 Thread Alvaro Herrera
Excerpts from Aren Cambre's message of dom mar 18 23:39:16 -0300 2012: > Thanks. I am running this on 1 year old hardware on a wholly-encrypted C > drive, encrypted with TrueCrypt. I suspect that I would have been alerted > already with that or SMART if I had hardware issues? That sounds excessiv

Re: [BUGS] BUG #6543: pgadmin III - Error defining filter.

2012-03-19 Thread Guillaume Lelarge
On Mon, 2012-03-19 at 17:47 +, kebe.1...@gmail.com wrote: > The following bug has been logged on the website: > > Bug reference: 6543 > Logged by: Cleberson > Email address: kebe.1...@gmail.com > PostgreSQL version: 9.1.3 > Operating system: Windows 7 > Description:

Re: [BUGS] BUG #6535: LEFT JOIN on large table is altering data

2012-03-19 Thread Aren Cambre
> > > Thanks. I am running this on 1 year old hardware on a wholly-encrypted C > > drive, encrypted with TrueCrypt. I suspect that I would have been alerted > > already with that or SMART if I had hardware issues? > > That sounds excessively optimistic -- not necessarily a good > characteristic on