<html style="direction: ltr;">
<head>
<meta content="text/html; charset=windows-1255"
http-equiv="Content-Type">
<style type="text/css">body p { margin-bottom: 0cm; margin-top: 0pt; } </style>
</head>
<body style="direction: ltr;"
bidimailui-detected-decoding-type="preferred-charset"
bgcolor="#FFFFFF" text="#000000">
On 07/05/2012 08:22 PM, Noel A Heim wrote:
<blockquote
cite="mid:74DD0704-B8B3-403D-8FE2-1F6F5CA50DD9@gmail.com"
type="cite">
<pre wrap="">I am new to QGIS and I'm having trouble getting all of my geometry-bearing tables to load. I have PostgreSQL database that I am connecting to through QGIS. When I connect to the database via the "Add PostGIS Layer" button, I get the following error message:
"Database connection was successful, but the accessible tables could not be determined."
About a third of the schemas that contain geometry fields are loaded. These work fine (i.e., I can create layers), but why are the rest of my schemas not showing up? They do have tables with geometry columns. I can't seem to find any preference settings that relate to schema/table loading.
I searched the archives for this list and found a similar question from 2010 to which Pierre Chevalier answered that all the schema and column names should not have upper case letters. All the schemas and table names in the database only contain lowercase letters, underscores and numbers (but they alway start with a lowercase letter).
</pre>
</blockquote>
<br>
Three thing you might look at:<br>
<ol>
<li>QGIS requires an integer primary key (not bigint)</li>
<li>What's the search_path for the user you are connecting as?</li>
<li>Have a look to be sure that each of the layers in each schema
indeed has a correct entry in the geometry_columns table (with
it's schema entered in the f_table_schema column).</li>
</ol>
Regards,<br>
Micha <br>
<blockquote
cite="mid:74DD0704-B8B3-403D-8FE2-1F6F5CA50DD9@gmail.com"
type="cite">
<pre wrap="">
Thanks for your help.
-Noel
_______________________________________________
Qgis-user mailing list
<a class="moz-txt-link-abbreviated" href="mailto:Qgis-user@lists.osgeo.org">Qgis-user@lists.osgeo.org</a>
<a class="moz-txt-link-freetext" href="http://lists.osgeo.org/mailman/listinfo/qgis-user">http://lists.osgeo.org/mailman/listinfo/qgis-user</a>
This mail was received via Mail-SeCure System.
</pre>
</blockquote>
<br>
<br>
<pre class="moz-signature" cols="72">--
Micha Silver
GIS Consultant, Arava Development Co.
<a class="moz-txt-link-freetext" href="http://www.surfaces.co.il">http://www.surfaces.co.il</a></pre>
</body>
</html>