[PostreSQL] Database and Table lists are not populating (empty)

nrazon's profile image nrazon posted 10 years ago in General Permalink
I am connecting a postgresql server with latest Heidi version.
I can connect and execute queries without any problem.
But On the left side, It doesn't populate trewview style, database names and table list. Any idea?

HeidiSQL Version: 8.3.0.4822 (64 Bit)
PostgreSQL Version: 9.3.4

nrazon's profile image nrazon posted 10 years ago Permalink
With newest heidisql still, It doesn't ş,st database names on treeview :(

HeidiSQL Version: 8.3.0.4833 (64 Bit)
[expired user #8433]'s profile image [expired user #8433] posted 10 years ago Permalink
Did you enter a database in the connection manager or is this field empty?
[expired user #8285]'s profile image [expired user #8285] posted 10 years ago Permalink
Hi,

This is a problem of privileges in PostgreSQL. The treeview is populated by querying the ANSI catalog (information_schema views) and PostgreSQL catalog.
But PostgreSQL only shows schemas from the ANSI catalog (information_schema) that you own, or, more precisely, schemas if you're a member of their's owning roles.

I suggested to populate the treeview by querying only the PostgreSQL catalog (pg_catalog), which does not have this limit, but this has not been done for the moment.
I hope it will be in future versions.

Regards.
[expired user #8285]'s profile image [expired user #8285] posted 10 years ago Permalink
For more details, see the following post: http://www.heidisql.com/forum.php?t=16213#p16213
nrazon's profile image nrazon posted 10 years ago Permalink
cduprez is right problem source is information_schema.schemata seems like empty because of permission problems.

m.lohse: On Connection manager window, database list can populate all database names and I can select my database. So It has access to all database names.
If heidisql can change the code like this database list on treeview, everything will be solved I think.



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