<html dir="ltr">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1">
<style id="owaParaStyle" type="text/css">P {margin-top:0;margin-bottom:0;}</style>
</head>
<body ocsi="0" fpstyle="1">
<div style="direction: ltr;font-family: Tahoma;color: #000000;font-size: 10pt;">Well, it seems as though you've misunderstood a bit. Your query executed fine, but it was a SELECT query, so all it did was running the ST_Point() function and displaying the result.
Nothing stored in no tables, so i'd be very supried if you found it again somewhere.<br>
<br>
If I rememeber correctly the book covers creating spatial columns, loading and storing data, so I suggest you gather some patience and continue the book :)<br>
<br>
Good luck! <br>
<br>
-atle<br>
<div><br>
<div class="BodyFragment"><font size="2"><span style="font-size:10pt;">
<div class="PlainText">--<br>
Atle Frenvik Sveen / 54°23'55"S 3°24'5"E<br>
Konsulent<br>
Bouvet Norge AS, Kjøpmannsgata 35, NO-7011 Trondheim<br>
Tlf +47 75 53 70 00 Mobil +47 45 27 86 89<br>
http://www.bouvet.no atle.sveen@bouvet.no</div>
</span></font></div>
</div>
<div style="font-family: Times New Roman; color: #000000; font-size: 16px">
<hr tabindex="-1">
<div style="direction: ltr;" id="divRpF410958"><font color="#000000" face="Tahoma" size="2"><b>From:</b> postgis-users-bounces@lists.osgeo.org [postgis-users-bounces@lists.osgeo.org] on behalf of Charles Sprowal [uchihabarles@gmail.com]<br>
<b>Sent:</b> Wednesday, February 13, 2013 7:50 AM<br>
<b>To:</b> postgis-users@lists.osgeo.org<br>
<b>Subject:</b> [postgis-users] Viewing the PostGIS in Action examples in QGIS<br>
</font><br>
</div>
<div></div>
<div>Hello, <br>
<br>
I have just started reading through the book PostGIS In Action in an attempt to learn Postgis, but have encountered a problem right at the start. After creating a spatially enabled database, the text asks me to run the following sql:
<br>
<br>
SELECT ST_Point(1, 2) AS MyFirstPoint;<br>
<br>
The query ran successfully. If I understand correctly, that statement creates a point in the db. After installing QuantumGIS and accessing the database through it, I expected to be able to view the point, but I could not. I had a similar problem with another
query in the same chapter that's supposed to generate a heart-shaped polygon: <br>
<br>
SELECT ST_GeomFromText('LINESTRING(52 218, 139 82, 262 207, 245 261, 207 267, <br>
153 207, 125 235, 90 270, 55 244, 51 219, 52 218)') AS HeartLine;<br>
<br>
When I connect to the database through QGIS, I get the following log message: "Database connection was successful, but the accessible tables could not be determined." The only table that is listed as having geometry (table "raster_columns" under schema "public")
does not seem to contain the point. I cannot even select the table to add a layer from it.<br>
<br>
I've followed the instructions in chapter 12.3 for QGIS use and remain at a loss. Any idea where I'm going wrong?<br>
</div>
</div>
</div>
</body>
</html>