[GRASS-user] sql and postgis

[Markus Neteler]

Gustavo Martínez wrote:
> 
> ...
> I've tried the following command:
> 
> v.db.connect -o map=monitoreo driver=pg database=pesca-new table=monitoreo 
> key=idmonitoreo layer=1
> 
>  and it gave me the following:
> 
> pg driver: column 'fecha', type 1184  is not supported
> pg driver: column 'fch_local', type 1184  is not supported
> pg driver: PostGIS column 'geom', type 'geometry'  will not be converted
> pg driver: column 'fecha', type 1184  is not supported
> pg driver: column 'fch_local', type 1184  is not supported
> pg driver: PostGIS column 'geom', type 'geometry'  will not be converted
> 

I have checked the PG type:

grep 1184 /usr/include/pgsql/server/catalog/pg_type.h
DATA(insert OID = 1184 ( timestamptz PGNSP PGUID        8 f b t \054 0  0
timestamptz_in timestamptz_out timestamptz_recv timestamptz_send - d p f 0
-1 0 _null_ _null_ ));
#define TIMESTAMPTZOID  1184

cd db/drivers/postgres/
grep TIMESTAMP *
create_table.c:            case DB_SQL_TYPE_TIMESTAMP:
db.c:       type = PG_TYPE_TIMESTAMP;
describe.c:     case PG_TYPE_TIMESTAMP:
describe.c:         *sqltype = DB_SQL_TYPE_TIMESTAMP;
fetch.c:            case PG_TYPE_TIMESTAMP:
globals.h:  PG_TYPE_TIMESTAMP, /* timestamp */

AFAIK the TIMESTAMPTZ type is yet undefined (with timezone).
The question is if DB_SQL_TYPE_TIMESTAMP is compliant to it
so that TIMESTAMPTZ can be mapped in globals.h
?

Markus
-- 
View this message in context: http://www.nabble.com/sql-and-postgis-tf4691735.html#a13495693
Sent from the Grass - Users mailing list archive at Nabble.com.