[prev in list] [next in list] [prev in thread] [next in thread] 

List:       grass-user
Subject:    [GRASS-user] db.tables & v.db.connect -p    mismatch? why?
From:       davideps () umich ! edu (David Epstein)
Date:       2008-01-29 10:12:17
Message-ID: 1201619529.5993.38.camel () davideps-T43
[Download RAW message or body]

Hi everyone,

I overlaid two postGIS polygon layers connected to two different
databases (same postgresql server). Will tables (including postGIS
geometry) for the resulting new layer automatically be generated through
the current <pg> connection? I am getting results that do not match:

ON THE ONE HAND
----------------
GRASS 6.2.2 (Israel-Palestine):~ > v.db.connect -p pg_halkot_valley
Vector map <pg_halkot_valley> is connected by:
layer <1> table <pg_halkot_valley> in database
<host=localhost,dbname=hebrew_spatial> through driver <pg> with key
<cat>

And pgAdmin3 shows that the table is indeed in the hebrew_spatial
database and is filled with rows of data.

ON THE OTHER HAND
-----------------
GRASS 6.2.2 (Israel-Palestine):~ > db.connect -p
driver:pg
database:host=localhost,dbname=hebrew_spatial
schema:(null)
group:(null)

GRASS 6.2.2 (Israel-Palestine):~ > db.tables -p
public.baaltable
public.cities
public.geometry_columns
public.gush1
public.gush19359
public.gushtable
public.spatial_ref_sys
...

where is the pg_halkot_valley generated by the overlay? shouldn't it be
in this list?

-david









[prev in list] [next in list] [prev in thread] [next in thread]