System columns appeared when using data transfer
- 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
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