[postgis-devel] Issue 74 in postgis: AddGeometryColumndoes notdetect search_path properly
robe.dnd at cityofboston.gov
Tue Dec 2 13:42:38 PST 2008
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
From: postgis-devel-bounces at postgis.refractions.net
[mailto:postgis-devel-bounces at postgis.refractions.net] On Behalf Of
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
K. I'll change the geometry constraint to use geometrytype().
Obe, Regina wrote:
> Always good to have documentation when the memory fails
> That's why GeometryType was the only non ST I kept
> When reading MM documents I do see a lot of reference to
> So I thought the behavior was intentional. See for example DB2 and
> seem to be the most OGC compliant of all the spatial dbs out there.
> -----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
> detect search_path properly
> Umm. Yup, you're correct, I misread my skim read of the function ...
> 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
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.
More information about the postgis-devel