Re: [BUGS] BUG #5869: postgresql corrupts unquoted non-ascii chars in column aliases

2011-03-03 Thread David Schmitt
On 03.03.2011 16:08, Robert Haas wrote: On Tue, Feb 8, 2011 at 2:19 AM, David Schmittda...@dasz.at wrote: Example query: SELECT column as zurück FROM table; results in corruption of the ü (umlaut u). This causes Npgsql to fail to match up the columns in the result set (see

[BUGS] BUG #5869: postgresql corrupts unquoted non-ascii chars in column aliases

2011-02-08 Thread David Schmitt
The following bug has been logged online: Bug reference: 5869 Logged by: David Schmitt Email address: da...@dasz.at PostgreSQL version: 8.4.5 Operating system: Windows 7 Description:postgresql corrupts unquoted non-ascii chars in column aliases Details: Example

Re: [BUGS] BUG #5673: Optimizer creates strange execution plan leading to wrong results

2010-09-24 Thread David Schmitt
On 9/23/2010 9:53 PM, Tom Lane wrote: David Schmittda...@dasz.at writes: Executing the attached example.sql on a fresh database demonstrates the problem I'm seeing: Found it. If you need a patch right away, it's a one-liner: diff --git a/src/backend/optimizer/path/allpaths.c

[BUGS] BUG #5673: Optimizer creates strange execution plan leading to wrong results

2010-09-23 Thread David Schmitt
The following bug has been logged online: Bug reference: 5673 Logged by: David Schmitt Email address: da...@dasz.at PostgreSQL version: 8.4.4 Operating system: Windows 7 Description:Optimizer creates strange execution plan leading to wrong results Details

Re: [BUGS] BUG #5673: Optimizer creates strange execution plan leading to wrong results

2010-09-23 Thread David Schmitt
On 9/23/2010 5:33 PM, Tom Lane wrote: David Schmittda...@dasz.at writes: Description:Optimizer creates strange execution plan leading to wrong results Please supply a self-contained example demonstrating the incorrect results. The information you've provided is completely inadequate

Re: [BUGS] BUG #5549: Feature: plpgsql should allow DECLARE cursor FOR EXECUTE '...'

2010-07-12 Thread David Schmitt
, David Schmitt [1]http://www.postgresql.org/docs/8.4/interactive/plpgsql-control-structures.html#PLPGSQL-RECORDS-ITERATING [2]http://www.postgresql.org/docs/8.4/interactive/plpgsql-cursors.html#PLPGSQL-CURSOR-FOR-LOOP -- dasz.at OG Tel: +43 (0)664 2602670 Web: http://dasz.at

[BUGS] BUG #5549: Feature: plpgsql should allow DECLARE cursor FOR EXECUTE '...'

2010-07-09 Thread David Schmitt
The following bug has been logged online: Bug reference: 5549 Logged by: David Schmitt Email address: da...@dasz.at PostgreSQL version: 8 and 9 Operating system: n/a Description:Feature: plpgsql should allow DECLARE cursor FOR EXECUTE '...' Details