[winGRASS] v.db.addcol

[Moritz Lennert]

On 07/11/07 11:00, Moritz Lennert wrote:
> Nicola,
> 
> On 06/11/07 19:47, Nicola Zoppetti wrote:
>>
>> In the folder
>> $GISDBASE/$LOCATION_NAME/$MAPSET/.tmp/
>> three temporary dbf files are created,
>> one with the 'a' column added, one with the 'b' column added and the last
>> one with the 'c' column added.
>>
>> It happens exactly the same if I directly use the db.execute command:
>> echo "ALTER TABLE ed7m3uT ADD COLUMN a double" | db.execute
>> echo "ALTER TABLE ed7m3uT ADD COLUMN b double" | db.execute
>> echo "ALTER TABLE ed7m3uT ADD COLUMN c double" | db.execute
>>
>> If I manually add the three columns to the dbf table and I try to fill 
>> the
>> empty fields with the v.to.db command, once again a temporary table in 
>> the
>> .tmp folder is correctly created and filled but the table linked to the
>> features, in the folder 'dbf' of the mapset, remains unchanged.
>>
>> Is there something that doesn't work as it should or I'm doing something
>> wrong??
> 
> No, I can confirm that problem. You apparently discovered a 
> window-related bug in db.execute.  I'll look into it.
> 
> Thank you very much for reporting.

Just to keep you posted:

I have narrowed down the issue a bit: the problem only occurs with the 
dbf driver, not with postgresql or sqlite. Up to now I have seen that 
inserts and updates do not work.

Will look further.

Moritz