Ads were blocked by your webbrowser.

This is not a problem, but keep in mind that developing HeidiSQL, user support and hosting takes time and money.

You may want to send a donation instead.

Issue: Postgres objects don't show in tree (v9.4.0.5133)

wouter van nifterick's profile image wouter van nifterick posted 3 years ago in General

I've upgraded from 9.3 to 9.4.0.5133, and after this update I don't see any objects in the db tree on the left.

The schema's are there, and when I configure the tree to group objects by type, i do see the number of items, but I don't see the items themselves.

I've turned debug logging on:

/* Connecting to 127.0.0.1 via PostgreSQL (experimental), username superbmu, using password: Yes ... */
/* Ping server ... */
SELECT VERSION();
/* Result #1 fetched. */
/* Ping server ... */
/* Connected. Thread-ID: 25527 */
/* Ping server ... */
SET statement_timeout TO 0;
/* Ping server ... */
SELECT EXTRACT(EPOCH FROM CURRENT_TIMESTAMP - pg_postmaster_start_time())::INTEGER;
/* Result #1 fetched. */
/* DBtreeFocusChanged without node. */
/* Ping server ... */
SELECT "nspname" FROM "pg_catalog"."pg_namespace" ORDER BY "nspname";
/* Result #1 fetched. */
/* DBtreeFocusChanged, Node level: 0, FTreeRefreshInProgress: 0 */
/* SetDatabase(), FDatabase:  */
/* Entering session "pg Amsterdam" */
/* editDatabaseTableFilterChange */
/* editDatabaseTableFilterChange */
/* editDatabaseTableFilterChange */
/* editDatabaseTableFilterChange */
/* Ping server ... */
SELECT *, pg_table_size(QUOTE_IDENT(t.TABLE_SCHEMA) || E'.' || QUOTE_IDENT(t.TABLE_NAME))::bigint AS data_length, pg_relation_size(QUOTE_IDENT(t.TABLE_SCHEMA) || E'.' || QUOTE_IDENT(t.TABLE_NAME))::bigint AS index_length, c.reltuples, obj_description(c.oid) AS comment FROM "information_schema"."tables" AS t LEFT JOIN "pg_namespace" n ON t.table_schema = n.nspname LEFT JOIN "pg_class" c ON n.oid = c.relnamespace AND c.relname=t.table_name WHERE t."table_schema"=E'public';
/* Result #1 fetched. */
/* Unknown datatype oid #1034 for "nspacl". Fall back to UNKNOWN. */
/* Unknown datatype oid #1034 for "relacl". Fall back to UNKNOWN. */
/* Unknown datatype oid #1009 for "reloptions". Fall back to UNKNOWN. */
/* Ping server ... */
SELECT "p"."proname" FROM "pg_catalog"."pg_namespace" AS "n" JOIN "pg_catalog"."pg_proc" AS "p" ON "p"."pronamespace" = "n"."oid" WHERE "n"."nspname"=E'public';
/* Result #1 fetched. */
/* editDatabaseTableFilterChange */

In the screenshot you see how it looks. The schema's show, but the tables and other menu-items remain empty when you expand them.

Note: this was working fine on this machine until I've upgraded HeidiSQL.

1 attachment(s):
  • HeidiSQL-No-objects
wouter van nifterick's profile image wouter van nifterick posted 3 years ago

Some extra information:

This seems to be some filtering issue somehow. All objects show in the Database tab as they should. They just don't appear in the tree. When I tried to enter a filter I saw items appear, and using filter "*" (without the quotes), does what used to happen when there was no filter at all.

I can work with that, but for other users this might not be obvious. Did the filtering change in the latest version or something?

ansgar's profile image ansgar posted 3 years ago

No. Did you press the "favorites only" button with the yellow star on it? (besides the filter boxes at the top of the tree)

fdv's profile image fdv posted 3 years ago

I also have this with PG. I created a new (empty) db and it doesn't appear in the tree, regardless of what's in the filters. I also recently updated. I didn't try PG before.

Please login to leave a reply, or register at first.