search

dbeaver / dbeaver

Free universal database tool and SQL client
https://dbeaver.io
Apache License 2.0
40.54k stars 3.49k forks source link

System columns appeared when using data transfer #23127

Open pkExec opened 8 months ago

pkExec commented 8 months ago

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

LonwoLonwo commented 8 months ago

Hello @pkExec

the system columns are appearing

Could you please explain this point more? Where are they appearing? At what moment?

pkExec commented 8 months ago

@LonwoLonwo see the following screenshots: t1 t2

Destrolaric commented 8 months ago

@pkExec Thank you for your report.