"evaluate default value on providers side" block insert on table in the schema with autoincrement (3.22.10-Białowieża)

[3rm4c]

What is the bug or the crash?

when you activate the project option "evaluate default value on providers side" it is impossible to use the auto-increment value on table in the schema

Steps to reproduce the issue

create schema test_schema;
create table test_schema.test_geom(
id integer generated always as identity primary key,
geom geometry(point, 4326)
);
create table test_schema.test_not_geom(
id integer generated always as identity primary key,
test_string VARCHAR(128)
);

if create point on table test_geom
Provider errors:
PostGIS error while adding features: ERROR: null value in column "id" of relation "test_geom" violates not-null constraint
DETAIL: Failing row contains (null, 0101000020E61000007AB3B57B06C821406D3766D23F374640).

or string on table test_not_geom return error
Provider errors:
PostGIS error while adding features: ERROR: null value in column "id" of relation "test_not_geom" violates not-null constraint
DETAIL: Failing row contains (null, fgdgdfgdfgf).

in public schema run correctly

Versions

<style type="text/css"> p, li { white-space: pre-wrap; } </style>

QGIS version	3.22.10-Białowieża	QGIS code revision	6a63fd3
Qt version	5.15.3
Python version	3.10.4
GDAL/OGR version	3.4.1
PROJ version	8.2.1
EPSG Registry database version	v10.041 (2021-12-03)
GEOS version	3.10.2-CAPI-1.16.0
SQLite version	3.37.2
PDAL version	2.3.0
PostgreSQL client version	14.4 (Ubuntu 14.4-0ubuntu0.22.04.1)
SpatiaLite version	5.0.1
QWT version	6.1.4
QScintilla2 version	2.11.6
OS version	Ubuntu 22.04.1 LTS
Active Python plugins
Qgis2threejs	2.7.1
profiletool	4.2.2
DataPlotly	3.9.1
qfieldsync	v4.1.1
GroupStats	2.2.6
quick_map_services	0.19.29
Pic2Map	version 3.3
rvt-qgis	0.9.2
qgis2web	3.16.0
OSMDownloader	1.0.3
qgis_resource_sharing	0.16.0
grassprovider	2.12.99
processing	2.12.99
MetaSearch	0.3.5
sagaprovider	2.12.99
db_manager	0.1.20

QGIS version 3.22.10-Białowieża QGIS code revision [6a63fd3](https://github.com/qgis/QGIS/commit/6a63fd37b0) Qt version 5.15.3 Python version 3.10.4 GDAL/OGR version 3.4.1 PROJ version 8.2.1 EPSG Registry database version v10.041 (2021-12-03) GEOS version 3.10.2-CAPI-1.16.0 SQLite version 3.37.2 PDAL version 2.3.0 PostgreSQL client version 14.4 (Ubuntu 14.4-0ubuntu0.22.04.1) SpatiaLite version 5.0.1 QWT version 6.1.4 QScintilla2 version 2.11.6 OS version Ubuntu 22.04.1 LTS

Active Python plugins
Qgis2threejs
2.7.1
profiletool
4.2.2
DataPlotly
3.9.1
qfieldsync
v4.1.1
GroupStats
2.2.6
quick_map_services
0.19.29
Pic2Map
version 3.3
rvt-qgis
0.9.2
qgis2web
3.16.0
OSMDownloader
1.0.3
qgis_resource_sharing
0.16.0
grassprovider
2.12.99
processing
2.12.99
MetaSearch
0.3.5
sagaprovider
2.12.99
db_manager
0.1.20

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