dbeaver / dbeaver/dbeaver

System columns appeared when using data transfer

Open
#23,127 3 comments 0 reactions 0 assignees View on GitHub
x:postgresql xf:datatransfer
Dominant language
Java
Stars
51.8k
Forks
4.4k
Avg merge
3d 10h
Merged PRs (30d)
185

Description

### Description

When I use data transfer to import a csv in an existing table, on the "target" columns, the system columns are appearing (tableoid, cmax, xmax, cmin, xmin, ctid).
This didn't occur in version 22, so it must be a relatively recent change.
This is an unwanted change, nobody wants to import into system columns. Or make it a preference that can be turned off.

### DBeaver Version

Community Edition Version 24.0.0.202403031740

### Operating System

_No response_

### Database and driver

Postgresql 12

### Steps to reproduce

_No response_

### Additional context

_No response_

Contributor guide

Open the contributing guide

Research direction

Start by reproducing the issue in DBeaver Community 24.0.0 with PostgreSQL 12 using the data transfer CSV import into an existing table. Trace how the target columns are populated and compare the result with version 22. Done means system columns such as tableoid, cmax, xmax, cmin, xmin, and ctid no longer appear as import targets, or can be disabled by a preference.

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
Stale
Clarity
Needs clarification
Newbie friendliness
25/100

Get new issues in your inbox

A short digest of beginner-friendly GitHub issues.