<!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=142492109-10022013><FONT color=#0000ff
size=2 face=Arial>Depends. The files should not have been created in
extensions folder of your source tree which are the ones that are copied to
extension folder of PostgreSQL install.</FONT></SPAN></DIV>
<DIV dir=ltr align=left><SPAN class=142492109-10022013><FONT color=#0000ff
size=2 face=Arial></FONT></SPAN> </DIV>
<DIV dir=ltr align=left><SPAN class=142492109-10022013><FONT color=#0000ff
size=2 face=Arial>But if you copied the generated postgis.sql from regular
source folder then yes that would explain it becuase the extension system would
see that as the file to use and then scream violently when it realized you tried
to trick it with an imposter :)</FONT></SPAN></DIV>
<DIV dir=ltr align=left><SPAN class=142492109-10022013><FONT color=#0000ff
size=2 face=Arial></FONT></SPAN> </DIV>
<DIV dir=ltr align=left><SPAN class=142492109-10022013><FONT color=#0000ff
size=2 face=Arial></FONT></SPAN> </DIV><BR>
<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> Sunday, February 10, 2013 1:56 AM<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>But if I copied those scripts from my install into their correct
final location, that would explain the strange affect, eh?
<DIV><BR></DIV>
<DIV>I think this is the result of some advanced work-arounds... .</DIV>
<DIV><BR></DIV>
<DIV>Best,<BR>Steve</DIV></DIV>
<DIV class=gmail_extra><BR><BR>
<DIV class=gmail_quote>On Sat, Feb 9, 2013 at 12:45 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>If you compiled
--without-raster then extensions should not have built at all since they don't
build without raster.</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>So that I suppose
could be the problem. if that is the case. Please ticket it.
The extension files shouldn't have even tried to build at
all.</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><BR>
<DIV dir=ltr lang=en-us align=left>
<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 11:00 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>
<DIV><SPAN style="FONT-FAMILY: courier new,monospace"><FONT
color=#0000ff><SPAN>select version() || ' ' || ' ' ||
postgis_full_version();<BR><BR><FONT size=+0><SPAN
style="FONT-FAMILY: arial,helvetica,sans-serif">yiel</SPAN><FONT size=+0><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 size=+0><FONT size=+0><SPAN
style="FONT-FAMILY: courier new,monospace"><SPAN
style="FONT-FAMILY: arial,helvetica,sans-serif"><FONT size=+0>Looking through
my <FONT size=+0>history</FONT>, it was an SVN pull</FONT>:</SPAN><BR><BR>svn
checkout <A href="http://svn.osgeo.org/postgis/trunk/"
target=_blank>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 size=+0><FONT size=+0><FONT
size=+0>:D <FONT size=+0>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
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><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 lang=en-us align=left>
<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 5:13 PM
<DIV>
<DIV><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>
<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 lang=en-us align=left>
<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 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>
<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"
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></BODY></HTML>