M
M
MaxLich2018-10-20 17:32:07
PostgreSQL
MaxLich, 2018-10-20 17:32:07

Why do I get an error when accessing a specific PostgreSQL 11 database from IntelliJ IDEA 2018.1?

Hello. When accessing from IntelliJ IDEA 2018.1 ("Database" tab) to the example database in PosgreSQL 11, I get this

mistake:
5bcb3b1fd4179256671284.png

Error encountered when performing Introspect database postgres schema public (details): ОШИБКА: столбец "proiswindow" не существует
Позиция: 779.
ОШИБКА: столбец "proiswindow" не существует
Позиция: 779
(557 ms)

As a result, this database is not visible from IDEA:
5bcb3bdbd4a60367590328.png
And here is what I have in pgAdmin 4:
5bcb3c430c349353904451.png

Answer the question

In order to leave comments, you need to log in

2 answer(s)
M
Melkij, 2018-10-20
@MaxLich

Your application does not yet support postgresql 11 released on Thursday. Perhaps the update has already been released, I guess version 2018.1 was quite a long time ago.
proisagg and proiswindow were removed from the pg_proc system directory back in March before the feature freeze and these changes were included in postgresql 11.

B
BeatKoder, 2020-10-17
@BeatKoder

5f8a196049002325069304.png
It is necessary to check the box "Introspect using JDBC metadata" in Data sources and Drivers.

Didn't find what you were looking for?

Ask your question

Ask a Question

731 491 924 answers to any question