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:[EMAIL PROTECTED] > http://www.agi.so.ch > > -----Ursprüngliche Nachricht----- > Von: Markus Neteler [mailto:[EMAIL PROTECTED] > 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: [EMAIL PROTECTED], 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:[EMAIL PROTECTED] > >> http://www.agi.so.ch > >> > > _______________________________________________ > grass-user mailing list > [email protected] > http://lists.osgeo.org/mailman/listinfo/grass-user > ------------------------------------------------------------------------ > > _______________________________________________ > grass-user mailing list > [email protected] > http://lists.osgeo.org/mailman/listinfo/grass-user > _______________________________________________ grass-user mailing list [email protected] http://lists.osgeo.org/mailman/listinfo/grass-user
