[GRASSLIST:5736] Re: Grass 6.0 and PG Database - tables not being deleted when vectors g.removed

[Radim Blazek]

Kirk R. Wythers wrote:
> I was looking at this issue this morning and thought that db.droptable 
> might work. However, db.droptable does not seem to be in my build of 
> grass6 (cvs a few days ago). Was db.droptable dropped?

Yes, it was removed from Makefile because db_drop_table was not 
implemented in drivers.

echo "drop table fmacopy" | db.execute

Radim


> Kirk
> 
> On Feb 11, 2005, at 8:47 AM, Radim Blazek wrote:
> 
>> g.remove (db_table_exists) was using fully qualified names 
>> (table.schema ->public.fmacopy) so it could not find fmacopy.
>> I have fixed that so that if the input table name is fully qualified, 
>> db_table_exists checks full name otherwise only table.
>>
>> I am not sure if it is the best solution, unfortunately we don't have 
>> enough experience with schemas. The table with the same name can be in 
>> other schema.
>>
>> I think that it is better to use db.connect schema=, even if you use 
>> only public.
>>
>> Radim
>>
>> Craig Aumann wrote:
>>
>>> I recently upgraded from an older version of Grass57 to the new Grass
>>> 6.  I can't figure out why the posgressql tables aren't being removed
>>> when I delete a vector.
>>> Here's my setup:
>>> GRASS 6.0.cvs:~/sagdalpac/AREAS/L11SAGD > db.connect -p
>>> driver:pg
>>> database:dbname=L11SAGD,user=caumann
>>> schema:(null)
>>> group:(null)
>>> GRASS 6.0.cvs:~/sagdalpac/AREAS/L11SAGD > v.db.connect -p fma
>>> Vector map <fma> is connected by:
>>> layer <1> table <fma> in database <dbname=L11SAGD,user=caumann> through
>>> driver <pg> with key <cat>
>>> g.copy vect=fma,fmacopy
>>> COPY [fma at caumann] to current mapset as [fmacopy]
>>> WARNING: 'user' in database definition is not supported, use db.login
>>> WARNING: 'user' in database definition is not supported, use db.login
>>> WARNING: 'user' in database definition is not supported, use db.login
>>>
>>>> v.db.connect -p fmacopy
>>>
>>> Vector map <fmacopy> is connected by:
>>> layer <1> table <fmacopy> in database <dbname=L11SAGD,user=caumann>
>>> through driver <pg> with key <cat>
>>>
>>>> GRASS 6.0.cvs:~/sagdalpac/AREAS/L11SAGD > g.remove vect=fmacopy
>>>
>>> REMOVE [fmacopy]
>>> WARNING: 'user' in database definition is not supported, use db.login
>>> WARNING: Table 'fmacopy' linked to vector did not exist.
>>> WHAT??? The table IS in the database.
>>> GRASS 6.0.cvs:~/sagdalpac/AREAS/L11SAGD > db.tables -p
>>> WARNING: 'user' in database definition is not supported, use db.login
>>> public.fma
>>> public.fmacopy
>>> fmacopy is still in the database....  What is going on???
>>> Cheers!
>>> Craig
>>
>>