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

2012-03-03 Thread Claus Stadler
Hi, not sure if this bug is already known, so sorry if it is ;) This is about an issue of the optimizer when having a union of selects that yield columns of constant value. The first minimal example shows a regression, the second one a missed optimization. Cheers, Claus Example 1:

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

2012-03-03 Thread exclusion
The following bug has been logged on the website: Bug reference: 6510 Logged by: Alexander LAW Email address: exclus...@gmail.com PostgreSQL version: 9.1.3 Operating system: Windows Description: I'm using postgresSQL in Windows with Russian locale and get unreadable