Bug report #14104
DB Manager: sequence issue when copying a table from a PostGIS schema into another
|Affected QGIS version:||2.12.2||Regression?:||No|
|Operating System:||Easy fix?:||No|
|Pull Request or Patch supplied:||No||Resolution:||duplicate|
|Crashes QGIS or corrupts data:||No||Copied to github as #:||22110|
In QGIS 2.12.2 sequences of serial columns don't get lost when copying a table from a schema into another by drag and drop in the DB Manager (see Bug report #12956). Unfortunately the sequences don't consider existing rows. So it's impossible to add new features in the table.
ERROR: duplicate key value violates unique constraint "test_geometry_pkey"
DETAIL: Key (gid)=(1) already exists.