[GRASS-user] Strange v.to.points error

GRASS GRASS user
1

Hi!
Soory but I cannot completly understand it:

GRASS 6.3.svn (polska):~ > v.to.points -n input=mrog_vector output=zb_point type=point,line, llayer=1 dmax=100
DBMI-Postgres driver error:
Cannot select:
select * from mrog_5 where 0 = 1
ERROR: relation "mrog_5" does not exist

Warning:Cannot open select cursor: 'select * from mrog_5 where 0 = 1'
ERROR:Cannot copy table

the input is mrog_vector
error concerns completly different table, which realy don't exist
Jarek

2

Hi,

2008/6/12 Jarosław Jasiewicz <jarekj@amu.edu.pl>:

GRASS 6.3.svn (polska):~ > v.to.points -n input=mrog_vector output=zb_point
type=point,line, llayer=1 dmax=100
DBMI-Postgres driver error:
Cannot select:
select * from mrog_5 where 0 = 1
ERROR: relation "mrog_5" does not exist

Warning:Cannot open select cursor: 'select * from mrog_5 where 0 = 1'
ERROR:Cannot copy table

the input is mrog_vector
error concerns completly different table, which realy don't exist

what

v.db.connect mrog_vector -p

says?

Probably you have accidently linked not existing table 'mrog_5' to the
vector map.

Martin
--
Martin Landa <landa.martin gmail.com> * http://gama.fsv.cvut.cz/~landa *

3

Martin Landa pisze:

Hi,

2008/6/12 Jaros³aw Jasiewicz <jarekj@amu.edu.pl>:
  

GRASS 6.3.svn (polska):~ > v.to.points -n input=mrog_vector output=zb_point
type=point,line, llayer=1 dmax=100
DBMI-Postgres driver error:
Cannot select:
select * from mrog_5 where 0 = 1
ERROR: relation "mrog_5" does not exist

Warning:Cannot open select cursor: 'select * from mrog_5 where 0 = 1'
ERROR:Cannot copy table

the input is mrog_vector
error concerns completly different table, which realy don't exist
    
what

v.db.connect mrog_vector -p

says?

Probably you have accidently linked not existing table 'mrog_5' to the
vector map.

Martin
  

v.db.connect -p says that no table is connected, in general I know nothing about mrog_5 I have never create it.
adationally when I tried to add empty table the same message appear
I remove the vector and import it again, I thing it was accident error due to some unknown circumstances, but why v.to.points became crazy?

4

On Thu, 2008-06-12 at 14:07 +0200, Jarosław Jasiewicz wrote:

Martin Landa pisze:
> Hi,
>
> 2008/6/12 Jarosław Jasiewicz <jarekj@amu.edu.pl>:
>
>> GRASS 6.3.svn (polska):~ > v.to.points -n input=mrog_vector output=zb_point
>> type=point,line, llayer=1 dmax=100
>> DBMI-Postgres driver error:
>> Cannot select:
>> select * from mrog_5 where 0 = 1
>> ERROR: relation "mrog_5" does not exist
>>
>>
>> Warning:Cannot open select cursor: 'select * from mrog_5 where 0 = 1'
>> ERROR:Cannot copy table
>>
>> the input is mrog_vector
>> error concerns completly different table, which realy don't exist
>>
>
> what
>
> v.db.connect mrog_vector -p
>
> says?
>
> Probably you have accidently linked not existing table 'mrog_5' to the
> vector map.
>
> Martin
>
v.db.connect -p says that no table is connected, in general I know
nothing about mrog_5 I have never create it.
adationally when I tried to add empty table the same message appear
I remove the vector and import it again, I thing it was accident error
due to some unknown circumstances, but why v.to.points became crazy?

Jarek,

you already where connected (using db.connect) while importing your
vector map in the GRASS' database?

Nikos