Hi,<br>I have no success trying the function probe_geometry_columns() with Postgis 1.5.0 <br><br>1) Not sure but comparing the SQL with Postgis 1.3.3:<br>the clause (in the INSERT step and not the count of probed)<br>"sridcheck.consrc LIKE '(<b>srid</b>('||a.attname||') = %)' in postgis 1.3.3<br>
is now:<br>"sridcheck.consrc LIKE '(<b>st_srid</b>('||a.attname||') = %)' in postgis 1.5.0<br>
This looks like a tipo error. (this is not the function here but the constraint text in pg_constraint) <br><br><br>2) I have a second problem with pg_constraint table and the "consrc" field.<br>Most of time I have something like :<br>
"(public.srid(the_geom) = 27492)" <br>and not (as expected by the function probe_geometry_columns()) :<br>"(srid(the_geom) = 27492)"<br><br>Thanks for any feed-back.<br><br>Fred.<br><br><br>