[postgis-devel] SQL comment generation

Chris Hodgson chodgson at refractions.net
Mon Sep 22 09:31:43 PDT 2008


Or can we have the package-building process pre-build the documentation 
and include it and the comments in the source tarball? I guess that 
doesn't work for SVN checkouts... but for releases it seems like it 
could be nice.

Chris

Kevin Neufeld wrote:
> Great work on this Regina.  It looks good.
>
> Were you thinking this sql would be another file a user would load 
> into a postgis database in addition to lwpostgis.sql and 
> spatial_ref_sys.sql, or that we would concatenate it to 
> lwpostgis.sql.  I would love to see it in lwpostgis.sql, but that 
> would mean folks would now have to build the documentation to get a 
> spatially enabled database, whereas before they needn't bother.  Hmmmmm.
>
> I wonder if we can do both.  Have the makefile build the docs and 
> concatenate the comments during the main build process if xsltproc is 
> installed, otherwise, the docs don't build and lwpostgis.sql remains 
> as is.  No harm done.
>
> -- Kevin
>
> Obe, Regina wrote:
>> Mark,
>>
>> I created a new xsl folder and committed the postgis_comments.sql.xsl I
>> created to that.
>>
>> I also made some enhancements to it to include the arg names in the
>> comments.  Sample generated sql file is attached and seems to work just
>> fine with xsltproc.
>>
>> To test I ran the command
>>
>> xsltproc -o postgis_comments.sql xsl/postgis_comments.sql.xsl
>> reference_new.xml
>>
>> Though I guess that is not exactly the best place to put it.
>>
>> In the process I discovered there is really no
>> ST_BdPolyFromText(text),  ST_BdMPolyFromText(text)
>>
>> or
>>
>> ST_WktToSQL(text,srid)
>> even in the 1.4
>>
>> These seem counter-intuitive to me since we have such constructs for
>> ST_GeomFromText, ST_GeometryFromText.
>>
>> Anyrate if this all looks okay to you, can you integrate in the build
>> and figure out where the postgis_comments.sql should go.
>>
>> As I mentioned I was eventually planning to create similar xsl files
>> that will comb out aggregate, mm and 3d compatible functions and
>> generate an additional toc doc .xml file from those that will then be
>> processed by our docbook generation step and simply provide an index
>> listing of said functions.
>>
>> Can I chain these together like that? - xsl to generate docbox xml, then
>> docbook to build document?
>>
>> Thanks,
>> Regina
>>
>>
>>
>>
>>
>> -----------------------------------------
>> 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.
>>
>>
>> ------------------------------------------------------------------------
>>
>> This body part will be downloaded on demand.
> _______________________________________________
> postgis-devel mailing list
> postgis-devel at postgis.refractions.net
> http://postgis.refractions.net/mailman/listinfo/postgis-devel




More information about the postgis-devel mailing list