Hi Users, I often create vector data using 'r.to.vect' which vectorises with no issues but If I then export it to PostGIS using 'v.out.postgis' the first layer will export fully but consecutive layers fail with the following error:-
GRASS_INFO_WARNING(4924,1): Table <grass_gis.nameofmylayer> not found in database <webgis> using driver <pg> GRASS_INFO_END(4924,1) After which the table does not open again in grass. I've checked to ensure both 'sqlite' and 'pg' connections are present. When I get the above error I am connected to 'pg' db.tables -p (shows me i'm connecetd to 'pg') db.connect -p or -g driver: pg database: ###### schema: grass_gis group: postgis_reader (Tue Aug 06 15:56:34 db.connect -g This is probably something obvious i'm missing!! Thanks, Paul Shapley --------------------------------------------------------------------------------------------------- Traceback (most recent call last): File "C:\OSGeo4W\apps\grass\grass76\gui\wxpython\lmgr\frame.py", line 2018, in OnShowAttributeTable selection=selection) File "C:\OSGeo4W\apps\grass\grass76\gui\wxpython\dbmgr\man ager.py", line 74, in __init__ **kwargs) File "C:\OSGeo4W\apps\grass\grass76\gui\wxpython\dbmgr\base.py", line 749, in __init__ self.dbMgrData['mapDBInfo'] = VectorDBInfo(self.dbMgrData['vectName']) File "C:\OSGeo4W\apps\grass\grass76\gui\wxpython\dbmgr\vinfo.py", line 87, in __init__ VectorDBInfoBase.__init__(self, map) File "C:\OSGeo4W\apps\grass\grass76\gui\wxpython\gui_core\ gselect.py", line 803, in __init__ self._DescribeTables() # -> self.tables File "C:\OSGeo4W\apps\grass\grass76\gui\wxpython\gui_core\ gselect.py", line 835, in _DescribeTables database=self.layers[layer]["database"])['cols']: File "C:\OSGeo4W\apps\grass\grass76\etc\python\grass\scrip t\db.py", line 43, in db_describe s = read_command('db.describe', flags='c', table=table, **args) File "C:\OSGeo4W\apps\grass\grass76\etc\python\grass\scrip t\core.py", line 478, in read_command return handle_errors(returncode, stdout, args, kwargs) File "C:\OSGeo4W\apps\grass\grass76\etc\python\grass\scrip t\core.py", line 334, in handle_errors returncode=returncode) grass.exceptions . CalledModuleError : Module run None ['db.describe', '-c', 'table=grass_gis.nameofmylayer', 'driver=pg', 'database=webgis'] ended with error Process ended with non-zero return code 1. See errors in the (error) output.
_______________________________________________ grass-user mailing list grass-user@lists.osgeo.org https://lists.osgeo.org/mailman/listinfo/grass-user