[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