Announcement

Collapse
No announcement yet.

Tables not showing on Postgres 10.3

Collapse
X
  • Filter
  • Time
  • Show
Clear All
new posts

  • Bobbus
    started a topic Tables not showing on Postgres 10.3

    Tables not showing on Postgres 10.3

    Hi,

    I'm connecting to a Heroku Postgres (10.3) database.

    I can connect with no problem but the tables will not display at all.

    Tried it with a number of different databases all with the same result

    As I can connect with the command line, Heroku insist it's a Navicat problem.

    Any ideas?

  • mayho
    replied
    Hi Bobbus,

    We have replied your ticket #26501. Please check your inbox.

    Leave a comment:


  • Bobbus
    replied
    HI mayo,

    The log is not sensitive, so I've posted it here in its entirety:

    [2018-05-09 17:33:53] [007071] [db_name_omitted] [PGSQL]
    SELECT oid, typname FROM pg_type

    [2018-05-09 17:33:53] [007071] [db_name_omitted] [PGSQL]
    SELECT n.nspname, n.oid, pg_get_userbyid(n.nspowner) AS owner, n.nspacl, obj_description(n.oid) AS comment, COALESCE((n.nspname = current_schema()), FALSE) AS default FROM pg_catalog.pg_namespace n LEFT JOIN pg_catalog.pg_user u ON nspowner = usesysid

    Leave a comment:


  • mayho
    replied
    Hi Bobbus,

    Could you please provide us all Query Log messages (choose View > Query Log in the menu bar) after you reproduced the problem (i.e. after tables failed to show)?

    You can send the information to our support center - https://help.navicat.com/hc/en-us/requests/new

    Leave a comment:


  • Bobbus
    replied
    Hi mayo,

    That was one of the first things I tried ... however, I've doe it again but with the same result.

    I see the green database icon to show I'm connected, but nothing else

    Thanks for helping with this :-)

    Leave a comment:


  • mayho
    replied
    Hi Bobbus,

    Please try to enable the Show system items option and restart Navicat to see if can solve the reported problem. To do so, please choose e.g. Navicat Essentials for PostgreSQL -> Preferences from the menu bar, select the General tab.

    Leave a comment:


  • Bobbus
    replied
    Hi mayho, should have though of that

    I'm using "Navicat version 11.2.18 - Essentials" on a Mac

    Leave a comment:


  • mayho
    replied
    Hi Bobbus,

    Would you please provide us your Navicat version? e.g. Navicat for PostgreSQL (Windows) 12.0.26

    Leave a comment:

Working...
X