[Qgis-user] accessible tables could not be determined

[Noel A Heim]

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).

Thanks for your help.

-Noel