Ansgar Becker

Results 304 comments of Ansgar Becker

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...

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?

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...

I'm not sure, but you could try to set the "Database" to "postgres" as well, like so: ![grafik](https://user-images.githubusercontent.com/7986591/101236559-970a5180-36d2-11eb-9cf6-b8b2962dbef3.png)

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

The fact that queries are not bound to a session is a feature. A common use case where this is useful is to have development and production servers. Also, you...

What I meant with "_everything else should also be bound to one session then_", was perhaps misleading, now that I overthink that. Probably I had in mind that once you...

No, that "philosophy" has to be done now, at least if you expect a change here. It's the current concept of having multiple sessions in HeidiSQL which is contrary to...

We will leave this issue open a while, to gather feedback from other users.

There are already 3 users voting for it, so my resistance just melts away :) However, I agree the code changes should be easy, but this is not the point...