Hi Rich, I've also had trouble with using Postgres tables in GRASS and then changing them. If I deleted the tables in the past, it was always very difficult to be able to delete the corresponding vector maps. My only real positive experience in that regard has been to delete the mapset and start anew, but of course that's about as far from elegant as you can get. Sorry that I don't know more about the way GRASS interacts with Postgres and where the connection is stored.
Best, Daniel -- B.Sc. Daniel Lee Geschäftsführung für Forschung und Entwicklung ISIS - International Solar Information Solutions GbR Vertreten durch: Daniel Lee, Nepomuk Reinhard und Nils Räder Deutschhausstr. 10 35037 Marburg Festnetz: +49 6421 379 6256 Mobil: +49 176 6127 7269 E-Mail: l...@isi-solutions.org Web: http://www.isi-solutions.org ISIS wird gefördert durch die Bundesrepublik Deutschland, Zuwendungsgeber: Bundesministerium für Wirtschaft und Technologie aufgrund eines Beschlusses des Deutschen Bundestages, sowie durch die Europäische Union, Zuwendungsgeber: Europäischer Sozialfonds. Zusätzliche Unterstützung erhält ISIS von dem Entrepreneurship Cluster Mittelhessen, der Universität Marburg, dem Laboratory for Climatology and Remote Sensing und dem GIS-Lab Marburg. On Mar 21, 2012 9:41 PM, "Rich Shepard" <rshep...@appl-ecosys.com> wrote: > I changed the database names so they represent the project rather than the > state in which they're located. The postgres ALTER DATABASE command does > the > job quite well. Unfortunately, grass seems to be confused by the name > change > and any attempt to access map attributes or overlay (intersect) the table > causes the wxPython GUI to crash and a message appears on the console that > grass was unable to open the old database name (error #16007.1) and unable > to describe the table _LAB (error #16010.1). > > After changing the postgres database name I ran db.connect to associate > the new name with the location and mapset. It appears that this does not > change where grass has the old name tucked away. The VAR file has the new > database name. > > I want to better understand how grass interacts with postgres and where > it needs to be modified to reflect the new database names. If this is in > one of the db.* modules I missed seeing it. > > TIA, > > Rich > > ______________________________**_________________ > grass-user mailing list > grass-user@lists.osgeo.org > http://lists.osgeo.org/**mailman/listinfo/grass-user<http://lists.osgeo.org/mailman/listinfo/grass-user> >
_______________________________________________ grass-user mailing list grass-user@lists.osgeo.org http://lists.osgeo.org/mailman/listinfo/grass-user