[postgis-users] Problem with probe_geometry_columns()

Fred Lehodey lehodey at gmail.com
Tue May 18 07:38:00 PDT 2010

I have no success trying the function probe_geometry_columns() with Postgis

1) Not sure but comparing the SQL with Postgis 1.3.3:
the clause  (in the INSERT step and not the count of probed)
"sridcheck.consrc LIKE '(*srid*('||a.attname||') = %)'   in postgis 1.3.3
is now:
"sridcheck.consrc LIKE '(*st_srid*('||a.attname||') = %)'  in postgis 1.5.0
This looks like a tipo error. (this is not the function here but the
constraint text in pg_constraint)

2) I have a second problem with pg_constraint table and the "consrc" field.
Most of time I have something like :
"(public.srid(the_geom) = 27492)"
and not (as expected by the function probe_geometry_columns()) :
"(srid(the_geom) = 27492)"

Thanks for any feed-back.

-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/postgis-users/attachments/20100518/31cd90a9/attachment.html>

More information about the postgis-users mailing list