[postgis-devel] Issue 74 in postgis: AddGeometryColumndoes notdetect search_path properly

[Obe, Regina]

I just noticed that IBM DB2 and Informix have an 

ST_AsShape function which converts a geometry to ESRI Shape binary
thingy and of course ArcSDE has the same thing.  That's just made up
right - not part of the spec and they are abusing the ST_ prefix as we
are?  Though I suppose it would be useful function to have for
something. 

-----Original Message-----
From: postgis-devel-bounces at postgis.refractions.net
[mailto:postgis-devel-bounces at postgis.refractions.net] On Behalf Of
Kevin Neufeld
Sent: Tuesday, December 02, 2008 4:33 PM
To: PostGIS Development Discussion
Subject: Re: [postgis-devel] Issue 74 in postgis: AddGeometryColumndoes
notdetect search_path properly

Yeah, this is the problem of merging specifications:  SQL/MM has
ST_Point, SimpleFeatures has POINT.  It looks like it's 
all laid out in Table B1 (page69) comparing the differences between the
standards.

K. I'll change the geometry constraint to use geometrytype().

Obe, Regina wrote:
> Always good to have documentation when the memory fails
> 
>
http://postgis.refractions.net/documentation/manual-svn/ST_GeometryType.
> html
> 
> That's why GeometryType was the only non ST I kept
> 
>
http://postgis.refractions.net/documentation/manual-svn/ST_GeometryType.
> html 
> 
> When reading MM documents I do see a lot of reference to 
> 
> ST_Geometry
> 	ST_Polygon
> 	ST_Point
> 
> etc.
> 
> So I thought the behavior was intentional.  See for example DB2 and
they
> seem to be the most OGC compliant of all the spatial dbs out there.
> 
>
http://aix2.caspur.it/ibm/db2/8.1/doc/htmlcd/en_US/index.htm?openup=opt/
> rsbp4118.htm
> 
> -----Original Message-----
> From: postgis-devel-bounces at postgis.refractions.net
> [mailto:postgis-devel-bounces at postgis.refractions.net] On Behalf Of
> codesite-noreply at google.com
> Sent: Tuesday, December 02, 2008 4:11 PM
> To: postgis-devel at postgis.refractions.net
> Subject: [postgis-devel] Issue 74 in postgis: AddGeometryColumn does
> notdetect search_path properly
> 
> 
> Comment #7 on issue 74 by ke... at refractions.net: AddGeometryColumn
does
> not  
> detect search_path properly
> http://code.google.com/p/postgis/issues/detail?id=74
> 
> Umm. Yup, you're correct, I misread my skim read of the function ...
> missed  
> the
> concatenation at the end of the function.
> 
> In any case, I agree that this is not correct behaviour as it does not

> follow the specs.
> 
_______________________________________________
postgis-devel mailing list
postgis-devel at postgis.refractions.net
http://postgis.refractions.net/mailman/listinfo/postgis-devel
-----------------------------------------
The substance of this message, including any attachments, may be
confidential, legally privileged and/or exempt from disclosure
pursuant to Massachusetts law. It is intended
solely for the addressee. If you received this in error, please
contact the sender and delete the material from any computer.