Search Postgresql Archives

Re: Database issues when adding GUI

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



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?








[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]

  Powered by Linux