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

2012-03-16 Thread Alvaro Herrera
Excerpts from exclusion's message of sáb mar 03 15:44:37 -0300 2012: > I'm using postgresSQL in Windows with Russian locale and get unreadable > messages when the postgres utilities prompting me for input. > Please look at the screenshot: > http://oi44.tinypic.com/aotje8.jpg > (The psql writes th

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

2012-03-16 Thread Tom Lane
a...@arencambre.com writes: > (Note that this issue is described fully at > http://stackoverflow.com/questions/9713537/postgres-left-join-is-creating-new-data. > A few knowledgeable people have weighed in, and there is no solution > identified.) This might be a bug, but you've not provided suffici

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

2012-03-16 Thread Alex Hunsaker
On Thu, Mar 15, 2012 at 16:13, Bruce Momjian wrote: > On Tue, Mar 06, 2012 at 09:08:25PM -0700, Alex Hunsaker wrote: >> [ Calling a plperl trigger function from a plperl function ] >> >> Yeah, there were some optimization done for 9.1 to try and make calls >> a bit faster. The problem is we are fe

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

2012-03-16 Thread Tom Lane
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! regards, tom lane -- Sent via pgsql-bugs mailing list (p

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

2012-03-16 Thread aren
The following bug has been logged on the website: Bug reference: 6535 Logged by: Aren Cambre Email address: a...@arencambre.com PostgreSQL version: 9.1.3 Operating system: Windows 7 x64 Description: (Note that this issue is described fully at http://stackoverflow.com/

Re: [BUGS] Re: [PATCH] Use CC atomic builtins if available [was: Re: TAS patch for building on armel/armhf thumb]

2012-03-16 Thread Heikki Linnakangas
On 06.02.2012 13:24, Heikki Linnakangas wrote: On 03.02.2012 02:48, Bruce Momjian wrote: Sorry for the late reply, but Heikki, can you get this Itanium information into s_lock.h as a comment, particularly the information about the +Ovolatile=__unordered flag? Good idea. I came up with the atta