[GRASS-user] RE: Problem querying layers other than '1' in gi s.m

Moritz Lennert mlennert at club.worldonline.be
Mon Sep 25 11:23:01 EDT 2006

Patton, Eric wrote:
>>> Could the error I'm getting be caused by the length of the new field
>>> names? 
>> I think the problem is rather the period in the name.
>>From the Postgresql documentation:
>> "SQL identifiers and key words must begin with a letter (a-z, but also 
>> letters with diacritical marks and non-Latin letters) or an underscore 
>> (_). Subsequent characters in an identifier or key word can be letters, 
>> underscores, digits (0-9), or dollar signs ($)."
>> Moritz
> Strange then that Sqlite writes these column names itself?! 

No time to check this now, but probably sqlite allows such column names, 
but GRASS tries to enforce SQL standards which probably don't allow them.

> I exported the
> tables as csv, opened it in OOffice, and just renamed the columns. It seems
> to be behaving now.

Couldn't you modify them in sqlite directly ?


More information about the grass-user mailing list