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. _______________________________________________ grassuser mailing list grassuser@grass.itc.it http://grass.itc.it/mailman/listinfo/grassuser