[GRASSLIST:9511] Re: switching to postgres

[Radim Blazek]

> 6. use db.describe to check out the vector in GRASS
>
> GRASS 6.1.cvs (spearfish60):~ > db.describe table=spearfish_soils driver=pg
> database=spearfish_soils
> DBMI-Postgres driver error:
> select * from spearfish_soils where oid < 0
> ERROR:  column "oid" does not exist
>
> What is oid? I can see from the columns that postgres printed out that I
> have only columns cat and label, no oid. Is this something that should have
> copied and did not?

This is bug.  By default postgres is using OID (hidden) column
for each table. But it is possible to configure postgres to create tables
without that column. My fault, it was stupid to use oid.
Fixed in CVS.

Radim