Re: BUG #6279: quoting needed for column name with non ascii chars

From: Laurian Vostinar <lvostinar(at)servoy(dot)com>
To: Pavel Golub <pavel(at)gf(dot)microolap(dot)com>
Cc: pgsql-bugs(at)postgresql(dot)org
Subject: Re: BUG #6279: quoting needed for column name with non ascii chars
Date: 2011-11-01 08:26:18
Message-ID: 4EAFAD2A.10504@servoy.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

SQL executor, of course. We actually execute the sql statement from Java
program and behavior is not consistent. Why are quotes needed for
Windows but not on Linux, Mac?

Laurian

On 31.10.2011 19:30, Pavel Golub wrote:
> Hello, Laurian.
>
> You wrote:
>
>
> LV> The following bug has been logged online:
>
> LV> Bug reference: 6279
> LV> Logged by: Laurian Vostinar
> LV> Email address: lvostinar(at)servoy(dot)com
> LV> PostgreSQL version: 9.0
> LV> Operating system: Windows 7
> LV> Description: quoting needed for column name with non ascii chars
> LV> Details:
>
> LV> I run sql from pg-admin:
>
> LV> create table a(straßße int)
>
> LV> On windows this creates a column which has empty name. However, it works
> LV> well on Linux and Mac.
>
>
> AKAIK pgAdmin's editor adds quotes. Did you use table editor or SQL
> executor?
>

In response to

Browse pgsql-bugs by date

  From Date Subject
Next Message Robert Young 2011-11-01 09:14:22 Re: Add statistics_collector_listen_addresses to fix hard-coding of "localhost"
Previous Message John R Pierce 2011-11-01 08:11:02 Re: Add statistics_collector_listen_addresses to fix hard-coding of "localhost"