[postgis-users] Problem with probe_geometry_columns()
lehodey at gmail.com
Tue May 18 08:06:04 PDT 2010
this is not the function but the constraint definition in the pg_constraint
table. (look at the "consrc" field)
I do a fresh install of 1.5
On Tue, May 18, 2010 at 4:00 PM, Mark Cave-Ayland <
mark.cave-ayland at siriusit.co.uk> wrote:
> Fred Lehodey wrote:
>> I have no success trying the function probe_geometry_columns() with
>> Postgis 1.5.0
>> 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
>> This looks like a tipo error. (this is not the function here but the
>> constraint text in pg_constraint)
> No, this is correct. The non ST_ prefix functions have been deprecated
> since PostGIS 1.2-ish. Do you actually have an ST_srid() function in your
> database, e.g. does the following work?
> select st_srid(st_geomfromtext('POINT(0 50)', 4326));
> Also, did you do a fresh install of 1.5 or did you run the upgrade script
> on an existing 1.3 install?
> 2) I have a second problem with pg_constraint table and the "consrc"
>> 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.
> Hmmmm. Do you have multiple schemas in your database/PostGIS installation?
> Or have you tried to install PostGIS into a specific schema?
> Mark Cave-Ayland - Senior Technical Architect
> PostgreSQL - PostGIS
> Sirius Corporation plc - control through freedom
> t: +44 870 608 0063
> Sirius Labs: http://www.siriusit.co.uk/labs
> postgis-users mailing list
> postgis-users at postgis.refractions.net
-------------- next part --------------
An HTML attachment was scrubbed...
More information about the postgis-users