<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
<head>
<meta content="text/html; charset=UTF-8" http-equiv="Content-Type">
</head>
<body bgcolor="#ffffff" text="#000000">
Sounds like 1.8 and my reading the docs more carefully :) would solve
my problems.<br>
<br>
Thanks for the info Even I really appreciate it!<br>
Even Rouault wrote:
<blockquote cite="mid:201110150950.04729.even.rouault@mines-paris.org"
type="cite">
<meta name="qrichtext" content="1">
<style type="text/css">
p, li { white-space: pre-wrap; }
</style>
<p style="margin: 0px; text-indent: 0px;">Le samedi 15 octobre 2011
00:51:01, David J. Bakeman a écrit :</p>
<p style="margin: 0px; text-indent: 0px;">> Thanks Even and
everyone else who responded! It was the fact that I had</p>
<p style="margin: 0px; text-indent: 0px;">> created the tables
without registering the geometry column. I did that</p>
<p style="margin: 0px; text-indent: 0px;">> and now things appear
good to go! That is ogrinfo is successful and</p>
<p style="margin: 0px; text-indent: 0px;">> lists the three tables
with geometry.</p>
<p style="margin: 0px; text-indent: 0px;">> </p>
<p style="margin: 0px; text-indent: 0px;">> Perhaps the normal
user of ogr is aware that only geometry columns are</p>
<p style="margin: 0px; text-indent: 0px;">> listed</p>
<p style="margin: 0px; text-indent: 0px;">In
<a class="moz-txt-link-freetext" href="http://gdal.org/ogr/drv_pg.html">http://gdal.org/ogr/drv_pg.html</a>,</p>
<p style="margin: 0px; text-indent: 0px;">"""If the <span
style="font-style: italic;">geometry_columns</span> table exists (i.e.
PostGIS is enabled for the accessed database), then all tables and
named views listed in the <span style="font-style: italic;">geometry_columns</span>
table will be treated as OGR layers."""</p>
</blockquote>
I read the first part but not the second and didn't know what it meant
to register my geometry until you mentioned it. I need to read the
postgis docs better too :<;<br>
<blockquote cite="mid:201110150950.04729.even.rouault@mines-paris.org"
type="cite">
<p style="margin: 0px; text-indent: 0px;">> and you get a FAILURE
otherwise but perhaps an empty list would</p>
<p style="margin: 0px; text-indent: 0px;">> be better? So I would
have gotten:</p>
<p style="margin: 0px; text-indent: 0px;">> INFO: Open of
`PG:dbname=mydb'</p>
<p style="margin: 0px; text-indent: 0px;">> using driver
`PostgreSQL' successful.</p>
<p style="margin: 0px; text-indent: 0px;">> </p>
<p style="margin: 0px; text-indent: 0px;">> Instead of the
FAILURE. I know the structure of the software might not</p>
<p style="margin: 0px; text-indent: 0px;">> make this possible so
maybe a Note in the driver page for PostgreSQL?</p>
<p style="margin: 0px; text-indent: 0px;">Actually, the change to
just return an empty list has been introduced in GDAL 1.8.0</p>
<p style="margin: 0px; text-indent: 0px;">From the 1.8.0 NEWS :</p>
<p style="margin: 0px; text-indent: 0px;">"""</p>
<p style="margin: 0px; text-indent: 0px;">PostgreSQL driver:</p>
<p style="margin: 0px; text-indent: 0px;">[...]</p>
<p style="margin: 0px; text-indent: 0px;"> * Don't require to have
found a layer in readonly mode to succeed in opening</p>
<p style="margin: 0px; text-indent: 0px;"> the datasource.</p>
<p style="margin: 0px; text-indent: 0px;">"""</p>
</blockquote>
Perfect.<br>
<br>
</body>
</html>