<html>
<head>
<meta content="text/html; charset=ISO-8859-1"
http-equiv="Content-Type">
</head>
<body bgcolor="#FFFFFF" text="#000000">
On 27/11/11 5:30 AM, Daniel Lee wrote:
<blockquote
cite="mid:CAJHDHfqwts9YTWdqadAC-NhUskiHV2K5L54wuFNeeSQtAa2_Gw@mail.gmail.com"
type="cite">Just another thing that's really weird - I ended up
exporting the geometries from GRASS to shapefiles, importing them
to PostGIS with shp2pgsql and viewing them in QGIS from the DB
directly, just to see if that would work. It did, just fine. Then
I tried to view them with the Geoserver again and still nothing.
But now they're definitely in the database. I also tried querying
them to see if I could match them over their primary keys -
<div>
<span class="Apple-style-span" style="font-family: Arial;
font-size: 15px; white-space: pre-wrap; ">SELECT <a
moz-do-not-send="true" href="http://gebaeude.cat">gebaeude.cat</a>
FROM gebaeude, globalstrahlung WHERE <a
moz-do-not-send="true" href="http://gebaeude.cat">gebaeude.cat</a>
= globalstrahlung.alk_id;</span></div>
<div><font class="Apple-style-span" face="Arial"><span
class="Apple-style-span" style="font-size: 15px;
white-space: pre-wrap;"><br>
</span></font></div>
<div><font class="Apple-style-span" face="Arial"><span
class="Apple-style-span" style="font-size: 15px;
white-space: pre-wrap;">and that of course gave me the cats
back in the order they were in globalstrahlung.alk_id. But
it's still not a permanent table join like what I'm trying
to do in GRASS. Very strange. Maybe the solution would be to
use a mapset with SQLite?? Never tried that before. Then I
could export the data from there to a shapefile and import
it into PostGIS, since I can't get GRASS to export directly.
I mean, it's a horrible workaround, but it's the best
solution that comes to mind.<br>
</span></font></div>
</blockquote>
Daniel,<br>
<br>
What do you get if you run db.connect -p in the relevant mapset?<br>
<br>
Richard C<br>
<br>
<br>
</body>
</html>