[GRASS-user] Issue with atribute column names
Markus Neteler
neteler at osgeo.org
Fri Mar 7 11:22:24 EST 2008
2008/3/7 Jarosław Jasiewicz <jarekj at 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
More information about the grass-user
mailing list