Bug report #14104

DB Manager: sequence issue when copying a table from a PostGIS schema into another

Added by Paul Kanelli almost 8 years ago. Updated over 7 years ago.

Category:DB Manager
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.

sequence.mp4 (1.8 MB) Paul Kanelli, 2016-02-21 10:46 AM

Related issues

Duplicates QGIS Application - Bug report #6798: when copying a table by d&d from one schema to another th... Closed 2012-11-30


#1 Updated by Paul Kanelli almost 8 years ago

I've uploaded a screencast. The issue may also appear when importing a file in the DB manager!

#2 Updated by Paul Kanelli over 7 years ago

See also #6798

#3 Updated by Giovanni Manghi over 7 years ago

  • Resolution set to duplicate
  • Status changed from Open to Closed

Also available in: Atom PDF