Re: Database issues when adding GUI

On Mon, 7 Jun 2021, Rob Sargent wrote:

> This looks like a permissions problem, as though you are connecting as a
> role/user without permission to select from the tables.

Rob,

I'm a trusted user for all my databases as I'm the only one using them.

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)

> Are these tables in a schema other than public.

Nope.

> can you show a psql session which accesses these tables, including
> connection string?

Not sure about the 'connection string' part but:
bustrac=# select * from activitytypes;
   act_name 
------------
  Phone
  Email
  Fax
  Meeting
  Conference
  Referral
  Called me
  Other
(8 rows)

Did I answer your questions?

Rich