Copying fetures to PostgreSQL layer not copying same name attribute value

[ar-siddiqui]

What is the bug or the crash?

I have a GPKG layer which has source data, one of the columns is 'name' string datatype. I am trying to copy features from it to a PSQL table which also has column 'name' varchar datatype. Features are copying fine but the column 'name' value is not copying over.

This is not the case if you copy to any other format.

Steps to reproduce the issue

1. Create PSQL table

CREATE SCHEMA modeling_domains;
CREATE TABLE modeling_domains.hucs (
    name VARCHAR (12) NOT NULL PRIMARY KEY,
    geom geometry(POLYGON, 3857)
);

2. Copy all features from the attached gpkg to the SQL table. source.zip

3. 'name' column would not carry over.

Versions

Checked in both 3.28 and 3.22

Supported QGIS version

• I'm running a supported QGIS version according to the roadmap.

New profile

• I tried with a new QGIS profile

Additional context

No response

[troopa81]

It's because name field is a primary key and is regenerated to avoid fid collision.

You can add a serial PRIMARY KEY not based on name and add the UNIQUE constraint on name.

This is the intended behavior, see #42511