Bug report #17186
Updated by Jürgen Fischer about 7 years ago
D&D in browser (from shapefile for example) and the ogr based tool in processing do the right thing.
The PostGIS data provider seems to add only the PK
https://github.com/qgis/QGIS/blob/release-2_18/src/providers/postgres/qgspostgresprovider.cpp#L3655
Without nextval(), beside not being very handy is also very easy to get bigger problems, like #17185 like: https://issues.qgis.org/issues/17185
The PostGIS data provider seems to add only the PK
https://github.com/qgis/QGIS/blob/release-2_18/src/providers/postgres/qgspostgresprovider.cpp#L3655
Without nextval(), beside not being very handy is also very easy to get bigger problems, like #17185 like: https://issues.qgis.org/issues/17185