[GRASSLIST:2427] pg driver and boolean columns (v.in.db, v.out.ogr)

[David Orme]

Hi,

I've just been using v.in.db to register points from a PostgreSQL table 
- it all works nicely except that the pg driver doesn't support 
converting boolean columns in my pg table into the resulting dbf file 
(see below for output of v.in.db). This isn't a huge problem because I 
can just use v.db.connect to connect the vector map back to the 
original pg table, but v.out.ogr also is unable to export these columns 
through the pg driver.

I'm using Grass 5.7 built from the 2004_01_10 weekly snapshot and 
PostgreSQL v. 7.4.1. running under mac OS 10.3.2.

Thanks,
David

> GRASS 5.7.-cvs:~ > v.in.db driver=pg database=adhoc table=behr_grid 
> x=e_centre_behr y=n_centre_behr key=grid_id output=behr_grid
> 54720 points written to vector
> WARNING: pg driver: column 'land', type 0 is not supported
> WARNING: pg driver: column 'threat_hotspot', type 0 is not supported
> WARNING: pg driver: column 'threat_randspot', type 0 is not supported
> WARNING: pg driver: column 'richness_hotspot', type 0 is not supported
> WARNING: pg driver: column 'richness_randspot', type 0 is not supported
> WARNING: pg driver: column 'endemism_hotspot', type 0 is not supported
> WARNING: pg driver: column 'endemism_randspot', type 0 is not supported
>
> 54720 primitives registered
> 0 areas built      8%
> 0 isles built
> Number of nodes     :   54720
> Number of primitives:   54720
> Number of points    :   54720
> Number of lines     :   0
> Number of boundaries:   0
> Number of centroids :   0
> Number of areas     :   0
> Number of isles     :   0
> Vector import complete
> GRASS 5.7.-cvs:~ >