[postgis-tickets] [PostGIS] #5033: Breaking change in PostGIS 3.1 with introduction of gridSize

PostGIS trac at osgeo.org
Thu Dec 16 04:48:53 PST 2021


#5033: Breaking change in PostGIS 3.1 with introduction of gridSize
----------------------+---------------------------
  Reporter:  robe     |      Owner:  pramsey
      Type:  defect   |     Status:  new
  Priority:  medium   |  Milestone:  PostGIS 3.1.5
 Component:  postgis  |    Version:  3.1.x
Resolution:           |   Keywords:
----------------------+---------------------------

Comment (by strk):

 One problem with the current approach is that the {{{ create or replace
 view }}} currently performed is NOT retaining all view option (ie: column
 names, check options).

 If a view has custom columns, for example, the create or replace will
 fail.
 In case of local check option, it will be silently changed to cascaded
 check option.

 I'm thinking it could be easier to just NOT attempt to redefine views but
 rather just warn the user about leaving these "legacy" function signatures
 around (both on upgrade, via WARNING and from postgis_full_version)

-- 
Ticket URL: <https://trac.osgeo.org/postgis/ticket/5033#comment:7>
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.


More information about the postgis-tickets mailing list