cannot modify table name or set schema on tables with postgis geometry column (RM #2006)

[dpage]

Issue migrated from Redmine: https://redmine.postgresql.org/issues/2006 Originally created by Donovan Cameron at 2016-12-08 21:14:26 UTC.

Getting an error when trying to rename a TABLE, or alter which SCHEMA it resides in from the properties window (right click table then select properties).

All tables that get this error are ones that have a GEOMETRY type column for PostGIS.

The error complains that "public.geometry" type doesn't exist or isn't a valid column type.

The SQL that's generated for renaming a table, similar to SET SCHEMA:

ALTER TABLE schema.table RENAME TO new_table;

ALTER TABLE schema.table ALTER COLUMN geom TYPE "public.geometry";

So it looks like it has an additional SQL command there regarding ALTER COLUMN that probably isn't needed.

[dpage]

Comment migrated from Redmine: https://redmine.postgresql.org/issues/2006#note-1 Originally created by Dave Page at 2016-12-09 11:42:27 UTC.

Redmine ticket header update:

Name	Old Value	New Value
Fixed Version changed		1.2

[dpage]

Comment migrated from Redmine: https://redmine.postgresql.org/issues/2006#note-2 Originally created by Khushboo Vashi at 2016-12-16 11:28:33 UTC.

Redmine ticket header update:

Name	Old Value	New Value
Assigned To changed		Khushboo Vashi

[dpage]

Comment migrated from Redmine: https://redmine.postgresql.org/issues/2006#note-3 Originally created by Khushboo Vashi at 2016-12-30 07:02:38 UTC.

Redmine ticket header update:

Name	Old Value	New Value
Status changed	New	In Progress

[dpage]

Comment migrated from Redmine: https://redmine.postgresql.org/issues/2006#note-4 Originally created by Khushboo Vashi at 2016-12-30 10:12:53 UTC.

Patch submitted. https://www.postgresql.org/message-id/CAFOhELc-iNCKo0+bp6zg5gcwTiCrC4XdghjEkw=2kNu0wNi1PA@mail.gmail.com

[dpage]

Comment migrated from Redmine: https://redmine.postgresql.org/issues/2006#note-5 Originally created by Dave Page at 2017-01-09 02:39:08 UTC.

Fix committed.

Redmine ticket header update:

Name	Old Value	New Value
Status changed	In Progress	In Testing
Done Ratio changed	0	90

[dpage]

Comment migrated from Redmine: https://redmine.postgresql.org/issues/2006#note-6 Originally created by Fahar Abbas at 2017-01-09 12:58:15 UTC.

This RM is resolved:

commit ID:

commit 86f6857cb75c342972186255f19832f93f0a6c45

Resolved Platform: MAC 10.9(Python 3.5) MAC Ubuntu 14.04 Linux 64(Python 3.4)

Redmine ticket header update:

Name	Old Value	New Value
Status changed	In Testing	Resolved

[dpage]

Comment migrated from Redmine: https://redmine.postgresql.org/issues/2006#note-7 Originally created by Fahar Abbas at 2018-01-09 04:46:39 UTC.

Redmine ticket header update:

Name	Old Value	New Value
Done Ratio changed	90	100

[dpage]

Issue closed on Redmine.