<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD>
<META content="text/html; charset=us-ascii" http-equiv=Content-Type>
<META name=GENERATOR content="MSHTML 9.00.8112.16457"></HEAD>
<BODY>
<DIV dir=ltr align=left><SPAN class=098062821-08022013><FONT color=#0000ff
size=2 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 class=098062821-08022013><FONT color=#0000ff
size=2 face=Arial></FONT></SPAN> </DIV>
<DIV dir=ltr align=left><SPAN class=098062821-08022013><FONT color=#0000ff
size=2 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 class=098062821-08022013><FONT color=#0000ff size=2
face=Arial></FONT></SPAN> </DIV>
<DIV><SPAN class=098062821-08022013><FONT color=#0000ff size=2 face=Arial>In
your extension folder of your PostgreSQL install, </FONT></SPAN></DIV>
<DIV><SPAN class=098062821-08022013><FONT color=#0000ff size=2
face=Arial></FONT></SPAN> </DIV>
<DIV><SPAN class=098062821-08022013><FONT color=#0000ff size=2 face=Arial>If you
open up postgis-2.1.0SVN.sql</FONT></SPAN></DIV>
<DIV><SPAN class=098062821-08022013><FONT color=#0000ff size=2
face=Arial></FONT></SPAN> </DIV>
<DIV><SPAN class=098062821-08022013><FONT color=#0000ff size=2 face=Arial>Does
it start with BEGIN and end with a COMMIT;?</FONT></SPAN></DIV>
<DIV><SPAN class=098062821-08022013><FONT color=#0000ff size=2
face=Arial></FONT></SPAN> </DIV>
<DIV><SPAN class=098062821-08022013><FONT color=#0000ff size=2 face=Arial>If it
does -- remove those. The postgis extension build
line:</FONT></SPAN></DIV>
<DIV><SPAN class=098062821-08022013><FONT color=#0000ff size=2
face=Arial></FONT></SPAN> </DIV>
<DIV><SPAN class=098062821-08022013><FONT color=#0000ff size=2
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 class=098062821-08022013><FONT color=#0000ff size=2
face=Arial> should have done this but it sounds like it didn't for some
reason. </FONT></SPAN></DIV>
<DIV><SPAN class=098062821-08022013><FONT color=#0000ff size=2
face=Arial></FONT></SPAN> </DIV>
<DIV><SPAN class=098062821-08022013><FONT color=#0000ff size=2
face=Arial></FONT></SPAN> </DIV>
<DIV><SPAN class=098062821-08022013><FONT color=#0000ff size=2 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 class=098062821-08022013><FONT color=#0000ff size=2
face=Arial></FONT></SPAN> </DIV>
<DIV><SPAN class=098062821-08022013><FONT color=#0000ff size=2 face=Arial>Hope
that helps,</FONT></SPAN></DIV>
<DIV><SPAN class=098062821-08022013><FONT color=#0000ff size=2
face=Arial>Regina</FONT></SPAN></DIV>
<DIV><BR></DIV>
<DIV dir=ltr lang=en-us class=OutlookMessageHeader align=left>
<HR tabIndex=-1>
<FONT size=2 face=Tahoma><B>From:</B> postgis-devel-bounces@lists.osgeo.org
[mailto:postgis-devel-bounces@lists.osgeo.org] <B>On Behalf Of </B>Stephen
Mather<BR><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 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 lang=en-us align=left>
<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 class=h5>
<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">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></BODY></HTML>