Unable to open PostgreSQL

[mbnoimi]

Describe the bug
As shown in the screenshot below, HS unable to open PostgreSQL (empty public schema)

Screenshots

Whenever I to manage users I get:

Environment:

• OS: Linux Mint 20 - wine-5.0 (Ubuntu 5.0-3ubuntu1)
• HeidiSQL version 11.1.0.6116
• PostgreSQL 13.1

[ansgarbecker]

The user manager is a MySQL/MariaDB-only feature, and there's issue #80 asking for making it compatible to PG.

But the empty public schema is weird. Did you already try libpq-10.dll in the library drop-down? And how does the public schema look like in other clients?

[mbnoimi]

Did you already try libpq-10.dll in the library drop-down?

I tried it. Same bug.

And how does the public schema look like in other clients?

Works fine with DBeaver and pgAdmin

[ansgarbecker]

Ok, and I suppose such a query returns 0 rows then ?

SELECT *
FROM "information_schema"."tables" AS t
WHERE t."table_schema"='public';

That's the (simplified) query HeidiSQL uses to retrieve table names.

[mbnoimi]

Ok, and I suppose such a query returns 0 rows then ?
I get 0 rows

/* Delimiter changed to ; */
/* Connecting to 127.0.0.1 via PostgreSQL (TCP/IP), username postgres, using password: Yes ... */
SELECT NOW();
SELECT VERSION();
SET statement_timeout TO 30000;
SELECT EXTRACT(EPOCH FROM CURRENT_TIMESTAMP - pg_postmaster_start_time())::INTEGER;
SHOW ssl;
/* Connected. Thread-ID: 80562 */
SELECT "nspname" FROM "pg_catalog"."pg_namespace" ORDER BY "nspname";
SET search_path TO 'public', '$user';
/* Entering session "PG localhost" */
SELECT *, pg_table_size(QUOTE_IDENT(t.TABLE_SCHEMA) || '.' || QUOTE_IDENT(t.TABLE_NAME))::bigint AS data_length, pg_relation_size(QUOTE_IDENT(t.TABLE_SCHEMA) || '.' || 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"='public';
/* 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. */
/* Unknown datatype oid #194 for "relpartbound". Fall back to UNKNOWN. */
SELECT "p"."proname", "p"."proargtypes" FROM "pg_catalog"."pg_namespace" AS "n" JOIN "pg_catalog"."pg_proc" AS "p" ON "p"."pronamespace" = "n"."oid" WHERE "n"."nspname"='public';
SELECT *
FROM "information_schema"."tables" AS t
WHERE t."table_schema"='public';
SELECT 13369::regclass;
/* Affected rows: 0  Found rows: 0  Warnings: 0  Duration for 1 query: 0.001 sec. (+ 0.001 sec. network) */

[ansgarbecker]

Hm, is that normal? What else does IS.tables contain, if not tables from the public schema? Does it contain any tables from other schemas?

[mbnoimi]

is that normal?

This is absolutely not normal it's a crystal clear a bug in HS.

I executed the same query in DB and I got:

[ansgarbecker]

Weird.

And it's not probably due to a different user you are using in Heidi/Dbeaver, having different privileges to the public schema? Did you use the same username in both applications?

[mbnoimi]

And it's not probably due to a different user you are using in Heidi/Dbeaver

I'm using the same user postgres

[ansgarbecker]

I'm not sure, but you could try to set the "Database" to "postgres" as well, like so:

[mbnoimi]

Same result with a new result; I'm able to list databases in connection dialog (see the screencast)

[ansgarbecker]

What does SHOW search_path return, in Dbeaver and in HeidiSQL?

[mbnoimi]

What does SHOW search_path return, in Dbeaver

"$user", public

and in HeidiSQL?

public, "$user"