[postgis-tickets] [PostGIS] #3360: _raster_constraint_info_scale invalid input syntax

PostGIS trac at osgeo.org
Sat Nov 7 01:25:38 PST 2015


#3360: _raster_constraint_info_scale invalid input syntax
----------------------+---------------------------
  Reporter:  robe     |      Owner:  robe
      Type:  defect   |     Status:  new
  Priority:  blocker  |  Milestone:  PostGIS 2.2.1
 Component:  raster   |    Version:  2.2.x
Resolution:           |   Keywords:
----------------------+---------------------------
Changes (by robe):

 * owner:  dustymugs => robe


Comment:

 okay the culprit I think is when we introduced change to
 enforce_scalex_rast, enforce_scaley_rast to use round.  My constraint
 looks like this:


 ALTER TABLE public.prec
   ADD CONSTRAINT enforce_scalex_rast CHECK
 (round(st_scalex(rast)::numeric, 10) = round(0.00833333333333333, 10));

 So I guess the info function can't parse that.

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