dbeaver / dbeaver/dbeaver

Geometry datatype converted to varchar when applying filter to schemas disaplayed in connection tree

Open
#41,641 7 comments 0 reactions 0 assignees View on GitHub
x:postgresql xf:metadata
Dominant language
Java
Stars
51.8k
Forks
4.4k
Avg merge
3d 8h
Merged PRs (30d)
188

Description

### Description

Hi,

I've a PostgreSQL connection in which I want to filter to keep a schema for a specific project.
In this schema, I've tables that contain spatial columns, as this example:

Image

On the other hand, I want to apply a filter on my schemas as following:

Image

If I apply this filter, the format of my spatial column is converted as a column with the varchar datatype, and my table is no longer considered as a spatial layer in DBeaver (i.e. no spatial tool in the data tab)

Image

It seems to be a bug, but there is maybe an explanation and a way out to solve this problem.

Thanks in advance for your help.

Cheers,
Eric.

### DBeaver Version

Community edition Version 26.1.2.202607051737

### Operating System

Zorin OS 17.3 Core

### Database and driver

1. PostgreSQL 15.18.0
2. JDBC driver : org.postgresql:postgresql:RELEASE [42.7.11]

### Steps to reproduce

_No response_

### Additional context

_No response_

Contributor guide

Open the contributing guide

Research direction

Start by reproducing the issue in DBeaver 26.1.2 with PostgreSQL 15.18 and JDBC driver 42.7.11, comparing the table metadata with and without the schema filter. The fix is done when spatial columns remain geometry and the table retains its spatial tools after filtering schemas.

Written by the indexing model from the issue text.

Assessment

Tech stack
java, postgresql
Domain
databases
Issue type
Bug
Difficulty
4/5
Estimated time
3-5 days
Activity status
Active
Clarity
Needs clarification
Newbie friendliness
42/100

Get new issues in your inbox

A short digest of beginner-friendly GitHub issues.