[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