[GRASSLIST:3628] error cannot create table on v.in.ogr command

hi listers..,

Now I'm work with grass 5.7 and data from
ArcView(shape file).
A few minute ago, I want to import my data (.shp) in
grass with the attribute in database.
I use postgresql for database.But there is error while
I execute v.in.ogr command.

command that I execute and the error:
v.database driver=pg database=testdb schema=postgres
v.in.ogr dsn=/mnt/win/dewa/shp_file/administrasi/
output=administrasi layer=administrasi min_area=0.0001
type=boundary snap=0.001 -c
PROJ_INFO file not found for location latihan
PROJ_UNITS file not found for location latihan
Projection of input dataset and current location
appear to match.
Proceeding with import...
Layer: administrasi
DBMI-Postgres driver error:
Cannot execute:
create table postgres.administrasi (cat integer, ID
integer, KECAMATAN varchar ( 20 ), LUAS_AREA double
precision, BANGKITAN integer, TARIKAN integer)
ERROR: Namespace "postgres" does not exist

ERROR: Cannot create table: create table
postgres.administrasi (cat
       integer, ID integer, KECAMATAN varchar ( 20 ),
LUAS_AREA double precision,
       BANGKITAN integer, TARIKAN integer)

can you help me to solve my problem,please?
thank's for your help before.

regard,

Didit

__________________________________
Do you Yahoo!?
Friends. Fun. Try the all-new Yahoo! Messenger.
http://messenger.yahoo.com/

schema option in v.database means the name of a schema
in Postgres database. Schemas are supported only in latest
versions of Postgres. Most probably you don't want to use
schemas at all, in that case, unset schema:
v.database driver=pg database=testdb schema=

If you realy want to use schemas, the schema 'postgres'
must exist in your database 'testdb'.

Radim

On Tuesday 08 June 2004 20:26, Didit Ahendra wrote:

hi listers..,

Now I'm work with grass 5.7 and data from
ArcView(shape file).
A few minute ago, I want to import my data (.shp) in
grass with the attribute in database.
I use postgresql for database.But there is error while
I execute v.in.ogr command.

command that I execute and the error:
v.database driver=pg database=testdb schema=postgres
v.in.ogr dsn=/mnt/win/dewa/shp_file/administrasi/
output=administrasi layer=administrasi min_area=0.0001
type=boundary snap=0.001 -c
PROJ_INFO file not found for location latihan
PROJ_UNITS file not found for location latihan
Projection of input dataset and current location
appear to match.
Proceeding with import...
Layer: administrasi
DBMI-Postgres driver error:
Cannot execute:
create table postgres.administrasi (cat integer, ID
integer, KECAMATAN varchar ( 20 ), LUAS_AREA double
precision, BANGKITAN integer, TARIKAN integer)
ERROR: Namespace "postgres" does not exist

ERROR: Cannot create table: create table
postgres.administrasi (cat
       integer, ID integer, KECAMATAN varchar ( 20 ),
LUAS_AREA double precision,
       BANGKITAN integer, TARIKAN integer)

can you help me to solve my problem,please?
thank's for your help before.

regard,

Didit

__________________________________
Do you Yahoo!?
Friends. Fun. Try the all-new Yahoo! Messenger.
http://messenger.yahoo.com/