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
[PostreSQL] Database and Table lists are not populating (empty)
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.
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.
For more details, see the following post: http://www.heidisql.com/forum.php?t=16213#p16213
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.
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.