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

The following bug has been logged online:

Bug reference:      6279
Logged by:          Laurian Vostinar
Email address:      lvostinar@servoy.com
PostgreSQL version: 9.0
Operating system:   Windows 7
Description:        quoting needed for column name with non ascii chars
Details:

I run sql from pg-admin:

create table a(straßße int)

On windows this creates a column which has empty name. However, it works
well on Linux and Mac.

On Mon, Oct 31, 2011 at 8:38 AM, Laurian Vostinar <lvostinar@servoy.com> wr=
ote:
>
> The following bug has been logged online:
>
> Bug reference: =A0 =A0 =A06279
> Logged by: =A0 =A0 =A0 =A0 =A0Laurian Vostinar
> Email address: =A0 =A0 =A0lvostinar@servoy.com
> PostgreSQL version: 9.0
> Operating system: =A0 Windows 7
> Description: =A0 =A0 =A0 =A0quoting needed for column name with non ascii=
 chars
> Details:
>
> I run sql from pg-admin:
>
> create table a(stra=DF=DFe int)
>
> On windows this creates a column which has empty name. However, it works
> well on Linux and Mac.

What happens if you run the same command from psql?

--=20
Robert Haas
EnterpriseDB: http://www.enterprisedb.com
The Enterprise PostgreSQL Company

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@servoy.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?

--
With best wishes,
 Pavel                          mailto:pavel@gf.microolap.com

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@servoy.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?
>

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@servoy.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?
>