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

[Moritz Lennert]

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 ?

Moritz