[GRASS-user] Lost attribute connection - grass 7.6.1

[Paul Shapley]

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.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/grass-user/attachments/20190806/da9ca89b/attachment.html>