Bug report #14104
DB Manager: sequence issue when copying a table from a PostGIS schema into another
| Status: | Closed | ||
|---|---|---|---|
| Priority: | Normal | ||
| Assignee: | - | ||
| 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 |
Description
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.
Related issues
History
#1
Updated by Paul Kanelli over 8 years ago
- File sequence.mp4 added
I've uploaded a screencast. The issue may also appear when importing a file in the DB manager!
#2
Updated by Paul Kanelli over 8 years ago
See also #6798
#3
Updated by Giovanni Manghi over 8 years ago
- Resolution set to duplicate
- Status changed from Open to Closed