<div dir="ltr"><div><div><span style="font-family:courier new,monospace"><font color="#0000ff"><span>select version() || ' ' || ' ' ||
postgis_full_version();<br><br><font><span style="font-family:arial,helvetica,sans-serif">yiel</span><font><span style="font-family:arial,helvetica,sans-serif">ds</span><br><br>PostgreSQL 9.1.7 on x86_64-unknown-linux-gnu, compiled by gcc (Ubuntu/Linaro 4.7.2-2ubuntu1) 4.7.2, 64-bit POSTGIS="2.1.0SVN r11081" GEOS="3.4.0dev-CAPI-1.8.0 r3762" PROJ="Rel. 4.7.1, 23 September 2009" LIBXML="2.8.0" LIBJSON="UNKNOWN"<br>
<br></font></font></span></font></span></div><font color="#0000ff" face="Arial"><span><font><font><span style="font-family:courier new,monospace"><span style="font-family:arial,helvetica,sans-serif"><font>Looking through my <font>history</font>, it was an SVN pull</font>:</span><br>
<br>svn checkout <a href="http://svn.osgeo.org/postgis/trunk/">http://svn.osgeo.org/postgis/trunk/</a> postgis-2.1.0SVN<br>cd postgis-2.1.0SVN/<br>./autogen.sh <br>./configure --with-gui --with-topology<br>./configure --with-gui --without-raster --with-topology<br>
make<br>make comments<br>make cheatsheets <br>sudo make install<br>sudo ldconfig<br>sudo make comments-install</span><br><br></font></font></span></font></div><font color="#0000ff" face="Arial"><span><font><font><font>:D <font>Looks like I was feeling my way around in the dark a bit there... .</font></font><br>
</font></font></span></font></div><div class="gmail_extra"><br><br><div class="gmail_quote">On Fri, Feb 8, 2013 at 10:20 PM, Paragon Corporation <span dir="ltr"><<a href="mailto:lr@pcorp.us" target="_blank">lr@pcorp.us</a>></span> wrote:<br>
<blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex"><u></u>
<div>
<div dir="ltr" align="left"><font color="#0000ff" face="Arial"><span>Which version of trunk are you running with and where
did you get it from: Direct from svn or tar ball (and if tar ball what
link)?</span></font></div>
<div dir="ltr" align="left"><font color="#0000ff" face="Arial"><span></span></font> </div>
<div dir="ltr" align="left"><font color="#0000ff" face="Arial"><span>I just tried with Winnie's 9.2 latest Windows build
built fresh whenever there is a change and it installed fine creating a new
postgis. Didn't try 9.1 though.</span></font></div>
<div dir="ltr" align="left"><font color="#0000ff" face="Arial"><span></span></font> </div>
<div dir="ltr" align="left"><font color="#0000ff" face="Arial"><span></span></font> </div>
<div dir="ltr" align="left"><font color="#0000ff" face="Arial"><span>select version() || ' ' || ' ' ||
postgis_full_version();</span></font></div>
<div dir="ltr" align="left"><font color="#0000ff" face="Arial"><span></span></font> </div>
<div dir="ltr" align="left"><font color="#0000ff" face="Arial"><span>--</span></font></div>
<div dir="ltr" align="left"><font color="#0000ff" face="Arial"><span>PostgreSQL 9.2.2, compiled by Visual C++ build 1600,
64-bit POSTGIS="2.1.0SVN r11085" GEOS="3.4.0dev-CAPI-1.8.0 r0" PROJ="Rel.
4.8.0, 6 March 2012" GDAL="GDAL 1.9.2, released 2012/10/08" LIBXML="2.7.8"
LIBJSON="UNKNOWN" RASTER</span></font></div>
<div dir="ltr" align="left"><font color="#0000ff" face="Arial"><span></span></font> </div>
<div dir="ltr" align="left"><font color="#0000ff" face="Arial"><span></span></font> </div>
<div dir="ltr" align="left"><font color="#0000ff" face="Arial"><span></span></font> </div>
<div dir="ltr" align="left"><font color="#0000ff" face="Arial"><span>If you are running an older -- its possible there was a
temporary issue that was fixed, though I'm not aware of one.
</span></font></div>
<div dir="ltr" align="left"><font color="#0000ff" face="Arial"><span>In the make sed strips out all BEGIN COMMITS as well as
a bunch of other things that are illegal in extension scripts and replaces
them with equivalent extension commands. It also adds additional helper
functions it uses during the process and then drops after.</span></font></div>
<div dir="ltr" align="left"><font color="#0000ff" face="Arial"><span></span></font> </div>
<div dir="ltr" align="left"><font color="#0000ff" face="Arial"><span></span></font> </div><font color="#0000ff" face="Arial"></font><br>
<div dir="ltr" align="left" lang="en-us">
<hr>
<font face="Tahoma"><div class="im"><b>From:</b> <a href="mailto:postgis-devel-bounces@lists.osgeo.org" target="_blank">postgis-devel-bounces@lists.osgeo.org</a>
[mailto:<a href="mailto:postgis-devel-bounces@lists.osgeo.org" target="_blank">postgis-devel-bounces@lists.osgeo.org</a>] <b>On Behalf Of </b>Stephen
Mather<br></div><b>Sent:</b> Friday, February 08, 2013 5:13 PM<div><div class="h5"><br><b>To:</b> PostGIS
Development Discussion<br><b>Subject:</b> Re: [postgis-devel] PostGIS 2.1
"transaction control statements"<br></div></div></font><br></div><div><div class="h5">
<div></div>
<div dir="ltr">
<div>-- $Id: postgis.sql.in.c 10806 2012-12-06 17:56:37Z pramsey
$<br>...<br>BEGIN;<br>...<br><br>Yes, the BEGIN and END are there. So, how
does it work? In the MAKE of the extension, sed is supposed to strip out
all transaction statements, or this just slipped into the SVN
somehow?<br><br></div>Best,<br>Steve<br></div>
<div class="gmail_extra"><br><br>
<div class="gmail_quote">On Fri, Feb 8, 2013 at 4:37 PM, Paragon Corporation <span dir="ltr"><<a href="mailto:lr@pcorp.us" target="_blank">lr@pcorp.us</a>></span> wrote:<br>
<blockquote style="BORDER-LEFT:#ccc 1px solid;MARGIN:0px 0px 0px 0.8ex;PADDING-LEFT:1ex" class="gmail_quote"><u></u>
<div>
<div dir="ltr" align="left"><span><font color="#0000ff" face="Arial">Hmm that's the
same version I'm runnning though I'm running mine under
mingw.</font></span></div>
<div dir="ltr" align="left"><span><font color="#0000ff" face="Arial"></font></span> </div>
<div dir="ltr" align="left"><span><font color="#0000ff" face="Arial">I thought maybe
you were having a sed issue that someone else complained about, though they
were on Mac and had to do with sed compatibility switch.</font></span></div>
<div><span><font color="#0000ff" face="Arial"></font></span> </div>
<div><span><font color="#0000ff" face="Arial">In your extension folder of your
PostgreSQL install, </font></span></div>
<div><span><font color="#0000ff" face="Arial"></font></span> </div>
<div><span><font color="#0000ff" face="Arial">If you open up
postgis-2.1.0SVN.sql</font></span></div>
<div><span><font color="#0000ff" face="Arial"></font></span> </div>
<div><span><font color="#0000ff" face="Arial">Does it start with BEGIN and end
with a COMMIT;?</font></span></div>
<div><span><font color="#0000ff" face="Arial"></font></span> </div>
<div><span><font color="#0000ff" face="Arial">If it does -- remove those.
The postgis extension build line:</font></span></div>
<div><span><font color="#0000ff" face="Arial"></font></span> </div>
<div><span><font color="#0000ff" face="Arial">sql_bits/postgis.sql:
../../postgis/postgis.sql<br> sed -e 's/BEGIN;//g' -e
's/COMMIT;//g' $< > $@<br></font></span></div>
<div><span><font color="#0000ff" face="Arial"> should have done this but it
sounds like it didn't for some reason. </font></span></div>
<div><span><font color="#0000ff" face="Arial"></font></span> </div>
<div><span><font color="#0000ff" face="Arial"></font></span> </div>
<div><span><font color="#0000ff" face="Arial">Those commands aren't legal in an
extension script since the extension machinery already wraps an extension in a
transaction.</font></span></div>
<div><span><font color="#0000ff" face="Arial"></font></span> </div>
<div><span><font color="#0000ff" face="Arial">Hope that helps,</font></span></div>
<div><span><font color="#0000ff" face="Arial">Regina</font></span></div>
<div><br></div>
<div dir="ltr" align="left" lang="en-us">
<hr>
<font face="Tahoma">
<div><b>From:</b> <a href="mailto:postgis-devel-bounces@lists.osgeo.org" target="_blank">postgis-devel-bounces@lists.osgeo.org</a> [mailto:<a href="mailto:postgis-devel-bounces@lists.osgeo.org" target="_blank">postgis-devel-bounces@lists.osgeo.org</a>] <b>On Behalf Of
</b>Stephen Mather<br></div><b>Sent:</b> Friday, February 08, 2013 4:24
PM<br><b>To:</b> PostGIS Development Discussion<br><b>Subject:</b> Re:
[postgis-devel] PostGIS 2.1 "transaction control
statements"<br></font><br></div>
<div>
<div>
<div></div>
<div dir="ltr">GNU sed 4.2.1<br></div>
<div class="gmail_extra"><br><br>
<div class="gmail_quote">On Fri, Feb 8, 2013 at 3:08 PM, Paragon Corporation
<span dir="ltr"><<a href="mailto:lr@pcorp.us" target="_blank">lr@pcorp.us</a>></span> wrote:<br>
<blockquote style="BORDER-LEFT:#ccc 1px solid;MARGIN:0px 0px 0px 0.8ex;PADDING-LEFT:1ex" class="gmail_quote"><u></u>
<div>
<div dir="ltr" align="left"><span><font color="#0000ff" face="Arial">It sounds like
the BEGIN /END transaction did not get stripped in your extension
building.</font></span></div>
<div dir="ltr" align="left"><span><font color="#0000ff" face="Arial"></font></span> </div>
<div dir="ltr" align="left"><span><font color="#0000ff" face="Arial">What version of
sed do you have?</font></span></div>
<div dir="ltr" align="left"><span><font color="#0000ff" face="Arial"></font></span> </div>
<div dir="ltr" align="left"><span><font color="#0000ff" face="Arial">Thanks,</font></span></div>
<div dir="ltr" align="left"><span><font color="#0000ff" face="Arial">Regina</font></span></div>
<div dir="ltr" align="left"><span><font color="#0000ff" face="Arial"><a href="http://www.postgis.us" target="_blank">http://www.postgis.us</a></font></span></div>
<div dir="ltr" align="left"><span><font color="#0000ff" face="Arial"><a href="http://postgis.net" target="_blank">http://postgis.net</a></font></span></div>
<div dir="ltr" align="left"><span></span> </div><br>
<div dir="ltr" align="left" lang="en-us">
<hr>
<font face="Tahoma"><b>From:</b> <a href="mailto:postgis-devel-bounces@lists.osgeo.org" target="_blank">postgis-devel-bounces@lists.osgeo.org</a> [mailto:<a href="mailto:postgis-devel-bounces@lists.osgeo.org" target="_blank">postgis-devel-bounces@lists.osgeo.org</a>] <b>On Behalf Of
</b>Stephen Mather<br><b>Sent:</b> Friday, February 08, 2013 9:19
AM<br><b>To:</b> <a href="mailto:postgis-devel@lists.osgeo.org" target="_blank">postgis-devel@lists.osgeo.org</a><br><b>Subject:</b>
[postgis-devel] PostGIS 2.1 "transaction control
statements"<br></font><br></div>
<div>
<div>
<div></div>
<div dir="ltr">
<div>
<div>
<div>Hi All,<br></div> Bounce me to
users, if appropriate, but I have put together an SVN build of PostGIS on
Ubuntu 12.10 and postgresql 9.1, with GEOS 3.4.0dev. All went well in
the configure/make/make install mantra. When I got to the CREATE
EXTENSION step I got the following cryptic message:<br><br>"transaction
control statements are not allowed with an extension
script"<br><br></div>I've had no problem loading PostGIS using the old
method with sql scripts, but thought I'd highlight this oddity in case it
was useful and as yet unreported.<br><br>Best,<br></div>Steve
Mather<br></div></div></div></div><br>_______________________________________________<br>postgis-devel
mailing list<br><a href="mailto:postgis-devel@lists.osgeo.org" target="_blank">postgis-devel@lists.osgeo.org</a><br><a href="http://lists.osgeo.org/cgi-bin/mailman/listinfo/postgis-devel" target="_blank">http://lists.osgeo.org/cgi-bin/mailman/listinfo/postgis-devel</a><br>
<br></blockquote></div><br></div></div></div></div><br>_______________________________________________<br>postgis-devel
mailing list<br><a href="mailto:postgis-devel@lists.osgeo.org" target="_blank">postgis-devel@lists.osgeo.org</a><br><a href="http://lists.osgeo.org/cgi-bin/mailman/listinfo/postgis-devel" target="_blank">http://lists.osgeo.org/cgi-bin/mailman/listinfo/postgis-devel</a><br>
<br></blockquote></div><br></div></div></div></div>
<br>_______________________________________________<br>
postgis-devel mailing list<br>
<a href="mailto:postgis-devel@lists.osgeo.org">postgis-devel@lists.osgeo.org</a><br>
<a href="http://lists.osgeo.org/cgi-bin/mailman/listinfo/postgis-devel" target="_blank">http://lists.osgeo.org/cgi-bin/mailman/listinfo/postgis-devel</a><br>
<br></blockquote></div><br></div>