On 6/7/21 9:02 AM, Rich Shepard wrote:
This is an unusual message and I hope someone(s) here can offer insights
into the cause of the problem I've been wrestling with for the past
couple
of weeks.
Context: For the past decade I've run my business tracking database
from the
psql shell (currently with postgresql-12.2) and decided it's time to
add a
frontend so it's a stand-alone desktop application. I'm learning to use
PyQt5 as the widget set and application framework.
The database contains three lookup tables: activitytypes,
industrytypes, and
statustypes, all have a single column and few rows. So I've started with
these to get python3 and PyQt5-5.13.2 to run the SELECT query and display
the results in a QTableView.
The problem with all three is that my code produces an empty window and
hangs. There's no python error displayed and the application reports
finding
the database but not the tables. For example, the activitytypes debugging
log contains:
INFO:root:found database
DEBUG:root:Defining model/view
DEBUG:root:model error: Unable to find table activitytypes
DEBUG:root:about to execute select query
DEBUG:root:End of Program
I, and others on the python and pyqt mail lists and stackoverflow, can
find
nothing wrong with the python code. This suggests it's something with the
database itself. But I have no idea where to look. The database structure
is:
bustrac=# \d
List of relations
Schema | Name | Type | Owner
--------+---------------------------+----------+----------
public | activities | table | rshepard
public | activitytypes | table | rshepard
public | industrytypes | table | rshepard
public | locations | table | rshepard
public | organizations | table | rshepard
public | organizations_org_nbr_seq | sequence | rshepard
public | people | table | rshepard
public | people_person_nbr_seq | sequence | rshepard
public | projects | table | rshepard
public | statustypes | table | rshepard
(10 rows)
What might stop a front-end application from finding a table that has
been
readily accessed from the psql shell?
All suggestions and recommendations are needed.
TIA,
Rich
\
This looks like a permissions problem, as though you are connecting as a
role/user without permission to select from the tables.
Are these tables in a schema other than public.
can you show a psql session which accesses these tables, including
connection string?
