[postgis-tickets] [PostGIS] #4160: CREATE or UPDATE extension fails if layer / topology table exists in the public schema

[PostGIS]

#4160: CREATE or UPDATE extension fails if layer / topology table exists in the
public schema
-----------------------------------+---------------------------
 Reporter:  Algunenano             |      Owner:  strk
     Type:  defect                 |     Status:  new
 Priority:  medium                 |  Milestone:  PostGIS 2.5.0
Component:  build/upgrade/install  |    Version:  trunk
 Keywords:                         |
-----------------------------------+---------------------------
 `CREATE` extension fails when either `public.layer` or `public.topology`
 exists, which blocks installation or updating the extension.

 Example with creation:
 {{{
 postgis_test=# create extension postgis_topology;
 CREATE EXTENSION
 postgis_test=# drop extension postgis_topology;
 DROP EXTENSION
 postgis_test=# create table layer ( a int );
 CREATE TABLE
 postgis_test=# create extension postgis_topology;
 ERROR:  table "layer" is not a member of the extension being created
 }}}


 With the update:
 {{{
 postgis_test=# create extension postgis_topology;
 CREATE EXTENSION
 postgis_test=# create table layer ( a int );
 CREATE TABLE
 "2.5.0rc1dev"      "2.5.0rc1devnext"
 postgis_test=# \dt public.*
               List of relations
  Schema |      Name       | Type  |  Owner
 --------+-----------------+-------+----------
  public | layer           | table | postgres
  public | spatial_ref_sys | table | postgres
 (2 rows)

 postgis_test=# \dt topology.*
            List of relations
   Schema  |   Name   | Type  |  Owner
 ----------+----------+-------+----------
  topology | layer    | table | postgres
  topology | topology | table | postgres
 (2 rows)

 postgis_test=# alter extension postgis_topology update TO
 "2.5.0rc1devnext" ;
 ERROR:  table "layer" is not a member of the extension being created
 }}}

-- 
Ticket URL: <https://trac.osgeo.org/postgis/ticket/4160>
PostGIS <http://trac.osgeo.org/postgis/>
The PostGIS Trac is used for bug, enhancement & task tracking, a user and developer wiki, and a view into the subversion code repository of PostGIS project.