DB Manager - Renaming constraints and indexes fails when renaming a table

[qgib]

Author Name: Paul Kanelli (Paul Kanelli)
Original Redmine Issue: 13823
Affected QGIS version: master
Redmine category:db_manager

---

When creating a table named 'lakes' in the DB Manager a constraint 'lakes_pkey' and the index 'sidx_lakes_geom' is created. But when renaming the table the constraint and the index don't get new names. So it's not possible to create a table named 'lakes' after renaming the original 'lakes' table.

@error: Relation „sidx_lakes_geom“ already exists@

---

Related issue(s): #15946 (relates)
Redmine related issue(s): 6798

---

[qgib]

Author Name: Paul Kanelli (Paul Kanelli)

---

• fixed_version_id was configured as Version 2.14

[qgib]

Author Name: Paul Kanelli (Paul Kanelli)

---

Also renaming the sequence of a serial column fails:

CREATE TABLE lakes
(
gid SERIAL NOT NULL,
geom geometry(polygon, SRID),
CONSTRAINT lakes_pkey PRIMARY KEY (gid)
);

Default value for column 'gid' is 'nextval('lakes_gid_seq'::regclass)'. It's not renamed after renaming table 'lakes'.

[qgib]

Author Name: Paul Kanelli (Paul Kanelli)

---

See also http://gis.stackexchange.com/questions/181532/renaming-a-table-in-the-qgis-db-manager

[qgib]

Author Name: Sebastian Dietrich (Sebastian Dietrich)

---

The workaround is to delete the constraints and recreate them. They are recreated with the correct name according to DB-Manager's naming scheme.

Note the linked ticket #22110 regarding the sequence issue.

[qgib]

Author Name: Sebastian Dietrich (Sebastian Dietrich)

---

• os_version was changed from 7 to
• version was changed from 2.12.0 to master
• operating_system was changed from Windows to

[qgib]

Author Name: Giovanni Manghi (@gioman)

---

• regression was configured as 0
• easy_fix was configured as 0

[qgib]

Author Name: Jürgen Fischer (@jef-n)

---

• description was changed from When creating a table named 'lakes' in the DB Manger a constraint 'lakes_pkey' and the index 'sidx_lakes_geom' is created. But when renaming the table the constraint and the index don't get new names. So it's not possible to create a table named 'lakes' after renaming the original 'lakes' table.

@error: Relation „sidx_lakes_geom“ already exists@ to When creating a table named 'lakes' in the DB Manager a constraint 'lakes_pkey' and the index 'sidx_lakes_geom' is created. But when renaming the table the constraint and the index don't get new names. So it's not possible to create a table named 'lakes' after renaming the original 'lakes' table.

@error: Relation „sidx_lakes_geom“ already exists@

[qgib]

Author Name: Giovanni Manghi (@gioman)

---

End of life notice: QGIS 2.18 LTR

Source:
http://blog.qgis.org/2019/03/09/end-of-life-notice-qgis-2-18-ltr/

---

• status_id was changed from Open to Closed
• resolution was changed from to end of life