[GRASS-user] Issue with atribute column names

GRASS GRASS user
1

Hi

In PG sql table I have columns etykietaPL, etykietaEN while I try to update atribute in v.digit module I recive error:

DBMI-Postgres driver error:
Cannot execute:
update przekroje set etykieta = 'Dolina Nysy - Wa³ Brody Drewitz - Dolina Lubszy', symbol = 'D', etykietaEN = null, kat = null where cat = 5
ERROR: column "etykietaen" of relation "przekroje" does not exist
LINE 1: ...Wa³ Brody Drewitz - Dolina Lubszy', symbol = 'D', etykieta_E

It is simple: Capial leters in columns name are not allowed, but why?

Jarek

2

2008/3/7 Jarosław Jasiewicz <jarekj@amu.edu.pl>:

Hi

In PG sql table I have columns etykietaPL, etykietaEN while I try to
update atribute in v.digit module I recive error:

DBMI-Postgres driver error:
Cannot execute:
update przekroje set etykieta = 'Dolina Nysy - Wał Brody Drewitz -
Dolina Lubszy', symbol = 'D', etykietaEN = null, kat = null where cat = 5
ERROR: column "etykietaen" of relation "przekroje" does not exist
LINE 1: ...Wał Brody Drewitz - Dolina Lubszy', symbol = 'D', etykieta_E

It is simple: Capial leters in columns name are not allowed, but why?

They are generally allowed, but you have to quote them. I don't know
if column name quoting is completely propagated through GRASS' source
code.

I always found it easier avoid capial letters.

Markus