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

[Stefan Schwarzer]

Hi there,

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,  
but it didn't bother me too much.

Now, while re-organizing my database, I do an pgsql2shp from my old  
database, and I get it again:

	pgsql2shp -f glaciers databaseXX glaciers
	Initializing... Warning, field id renamed to ID_01
	Warning, field name renamed to NAME_01
	Warning, field country_id renamed to COUNTRY_01
	Warning, field lat renamed to LAT_01
	Warning, field long renamed to LONG_01
	Done (postgis major version: 1).
	Output shape: Point
	Dumping: XX [30 rows].

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.

Thanks for any advice!

Stef