[postgis-users] "Field xx renamed to XX_01"

[Stefan Schwarzer]

>> I have from time to time in the server's error_log a couple of lines
>> saying that "Field xx renamed to XX_01"... I couldn't find out why,
> ...
>> The dbf shows the original columns as well as the XX_01 columns....
>>
>> Why is that? I re-index the table, re-gist it etc... but still the  
>> same.
>
> DBF seem to require uppercase fieldnames, or at least this is what
> you usually find inside them so better to conform.
> If I recall correctly you can use the -k switch to attempt using
> whatever case is in the database.

Thanks. Indeed, with -k the column-titles are being kept in small  
letters.

But the problem remains: My dbf file shows, for example, the column  
"id" and another "id_01". So all columns are doubled and an "_01"  
added to the column name...

Stef