[GRASSLIST:9532] Re: switching to postgres

[Leonardo Lami]

Hi all,
I see the same error in v.in.ascii when db.connect is setted on Postgre.
Is possible to debbug it?

Thanks

Ciao
Leonardo

Alle 18:54, giovedì 15 dicembre 2005, Radim Blazek ha scritto:
> > 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