[GRASS-user] vector layers problem

[wrobell]

hi,

i have a sqlite database, which holds two tables:

- roads_1 (cat, ... some other columns ...)
- roads_2 (cat column only)

first table contains about 32000 rows. second one contains about 1400
rows and was populated from roads_1.cat column using SQL query.

i have `roads` vector map with layers

    $ v.db.connect -p map=roads                                                     
    Vector map <roads> is connected by:
    layer <1> table <roads_1> in database <sqlite.db> through driver <sqlite> with key <cat>
    layer <2> table <roads_2> in database <sqlite.db> through driver <sqlite> with key <cat>

the second layer was created using command

    $  v.db.connect --v -o map=roads database=sqlite.db key=cat layer=2 table=roads_2

displaying first layer, i.e. using command

    $ d.vect map=roads layer=1

but when i want to display second layer, then nothing is displayed.

even more

    $ v.category input=roads layer=1 option=print | wc -l                             
    37275

    $ v.category input=roads layer=2 option=print | wc -l                             
    0

but table `roads_2` contains more than 1400 categories.

looking at v.db.connect it does not seem that i should perform more
operations... but probably i am missing something here.

regards,

    wrobell <wrobell at pld-linux.org>