AW: Re: [GRASS-user] v.in.ogr should support postgis schemas

[Leonardo Lami]

Hi all,
I think the problem is here:

if you look the example in
http://grass.itc.it/grass63/manuals/html63_user/v.in.ogr.html
you can see the example:

v.in.ogr dsn=./ layer=river output=river table user1.river

but if you use v.in.ogr from QGIS we take the name directily from the
layer loaded list where the name of the Postgis layers are without the
name of the schema and so the command line trasmitted to GRASS is:

v.in.ogr dsn=./ layer=river output=river table river

And so it doesn't work....

In the test I made I see also another problem that I never seen with old
GRASS vers working with the same table

DBMI-Postgres driver error:
Cannot execute:
insert into geocarta.fix values ( 4, '', 2005, 'f', 2925, 'f',
'2005-07-15', '2007-05-17', 38, 'pn', 't','f','data da cui non si è più
sentita', 'cf', 'cf', 'f', 'f','b', 1, 't', 'f', 'vv' )
ERROR:  invalid input syntax for type time: "cf"


ERROR: Cannot insert new row: insert into geocarta.fix values ( 4,
'',2005, 'f', 2925, 'f','2005-07-15', '2007-05-17', 38, 'pn', 't','f',
'data da cui non si è più sentita', 'cf', 'cf', 'f', 'f','b', 1, 't',
'f', 'vv' )


Any idea about it?

Regards
leonardo


Düster Horst ha scritto:
> Mmmmm...
>
> Now I'm confused. Yes you are rigth that's exactly what I mean. I
> think I made too much assumptions based on the QGIS v.in.ogr message
> "PostGIS schema are not supported". So I have to look at QGIS to get
> out the reason of this message.
>
> Best regards
> Horst
>
> ------------------------------------------------
>
> Dr. Horst Düster
> GIS-Koordinator, Stv. Amtschef
>
> Kanton Solothurn
> Bau- und Justizdepartement
> Amt für Geoinformation
> SO!GIS Koordination
> Rötistrasse 4
> CH-4501 Solothurn
>
> Telefon ++41(0)32 627 25 32
> Telefax ++41(0)32 627 22 14
>
> mailto:horst.duester at bd.so.ch
> http://www.agi.so.ch
>
> -----Ursprüngliche Nachricht-----
> Von: Markus Neteler [mailto:neteler at fbk.eu]
> Gesendet am: Freitag, 23. November 2007 13:33
> An: Andreas Neumann
> Cc: grass-user
> Betreff: Re: [GRASS-user] v.in.ogr should support postgis schemas
>
> Hi,
>
> I am confused:
> http://grass.itc.it/grass63/manuals/html63_user/v.in.ogr.html
> -> Support of database schema
>
> Is this not what you need?
>
> Markus
>
> Andreas Neumann wrote on 11/23/2007 08:42 AM:
> > I agree that schema support is essential. In Postgis one cannot join
> > tables from different databases, but it works well across schemas. So in
> > practice, all data usually ends up in one big database, but organized in
> > schemas. So yes, please, I also would very much appreciate if v.in.ogr
> > would support schemas.
> >
> > Thank you for considering this improvement.
> >
> > Andreas Neumann
> >
> > Böschacherstrasse 6, CH-8624 Grüt/Gossau, Switzerland
> > Email: a.neumann at carto.net, Web:
> > * http://www.carto.net/ (Carto and SVG resources)
> > * http://www.carto.net/neumann/ (personal page)
> > * http://www.svgopen.org/ (SVG Open Conference)
> > * http://www.geofoto.ch/ (Georeferenced Photos of Switzerland)
> >
> >
> >> Since more than one year the ogr PostGIS driver supports PostGIS
> >> schemas. For good DB-Modelling schemas are very essential. Unfortunately
> >> the v.in.ogr command doesn't support PostGIS schemas till today. How are
> >> the plans to introduce PostGIS schema support for v.in.ogr?
> >>
> >> Best regards
> >>
> >> Dr. Horst Düster
> >> GIS-Koordinator, Stv. Amtschef
> >>
> >> Kanton Solothurn
> >> Bau- und Justizdepartement
> >> Amt für Geoinformation
> >> SO!GIS Koordination
> >> Rötistrasse 4
> >> CH-4501 Solothurn
> >>
> >> Telefon ++41(0)32 627 25 32
> >> Telefax ++41(0)32 627 22 14
> >>
> >> mailto:horst.duester at bd.so.ch
> >> http://www.agi.so.ch
> >>
>
> _______________________________________________
> grass-user mailing list
> grass-user at lists.osgeo.org
> http://lists.osgeo.org/mailman/listinfo/grass-user
> ------------------------------------------------------------------------
>
> _______________________________________________
> grass-user mailing list
> grass-user at lists.osgeo.org
> http://lists.osgeo.org/mailman/listinfo/grass-user
>