[GRASS-user] RE: Problem querying layers other than '1' in gi s.m
    Patton, Eric 
    epatton at nrcan.gc.ca
       
    Mon Sep 25 11:14:35 EDT 2006
    
    
  
>> 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?! I exported the
tables as csv, opened it in OOffice, and just renamed the columns. It seems
to be behaving now.
Thanks,
~ Eric.
    
    
More information about the grass-user
mailing list