Can view table data (double-click) but can't query the table from console ([42P01] ERROR: relation "" does not exist)

Permanently deleted user

创建于 2018年05月31日 06:34

Hey,

I have connected to my DB via datagrip. The connection has been successfully, and I can also see the tables under my schema (public schema).

When I double click the table, I can see the data (!!!) and filter in the <filter criteria> line.

When I try to query (from tablename/ from public.tablename) I get the error: [42P01] ERROR: relation "tablename" does not exist.

Also I couldn't find my tables when I queried them at information_schema.columns.

I assume this has to do with some DataGrip configuration, but couldn't find anything. Any help?

9 条评论

创建于 2018年06月07日 18:20

@Nitzan Cohen Could you specify database you use and screenshots of you schema chooser and console with error?

Permanently deleted user

创建于 2018年09月07日 07:33

Same problem here. Currently experience it in the PyCharm Pro EAP 2018.3 PostgreSQL database is located on AWS and accessed via SSH tunnel.

If using pgAdmin via the same SSH tunnel, there seems to be no issues.

Not sure what is meant as schema choose, hope below will help

When double click on the products - gives the list of the products as expected

If right click - start console, then :

If I would

SELECT * FROM products

then it would state that relation products does not exist.

The latter method to query is obviously preferred and is working ok in pgAdmin.

Permanently deleted user

创建于 2018年09月07日 07:41

Seems to found some workaround:

selecting single database mode seems to allow me to query the database, but I have more than 1 db on the given server ...

创建于 2018年09月10日 15:29

Do you work behind pgBouncer or similar?

Permanently deleted user

创建于 2018年09月11日 08:28

To the best of my knowledge we do not use the pgBouncer, unless AWS is doing something like this behind the scene.

创建于 2024年03月13日 08:40

i have exact same problem (with current intellij and postgres). any solution here? - the workaround does not work

创建于 2024年03月13日 10:06

Please submit a new report for your problem making sure to provide the following info:

Screenshots of the data source connection settings (General and Options tabs)
Any additional specifics about the connection and your system environment
idea.log file collected after reproducing the issue: Help | Show Log in… We will search for exceptions there.

Log can be uploaded privately to https://uploads.jetbrains.com

创建于 2024年05月10日 18:09

I've been having the same issue since I updated it to `2024.1.2` version

创建于 2024年05月13日 12:54

Hi Aabregu - please refer to this comment for instructions on how to proceed with investigating the problem.

请先登录再写评论。