[postgis-devel] PostGIS 2.1 "transaction control statements"

[Paragon Corporation]

Hmm that's the same version I'm runnning though I'm running mine under
mingw.
 
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.
 
In your extension folder of your PostgreSQL install, 
 
If you open up postgis-2.1.0SVN.sql
 
Does it start with BEGIN and end with a COMMIT;?
 
If it does -- remove those.  The postgis extension build line:
 
sql_bits/postgis.sql: ../../postgis/postgis.sql
 sed -e 's/BEGIN;//g' -e 's/COMMIT;//g'  $< > $@

 should have done this but it sounds like it didn't for some reason.  
 
 
Those commands aren't legal in an extension script since the extension
machinery already wraps an extension in a transaction.
 
Hope that helps,
Regina

  _____  

From: postgis-devel-bounces at lists.osgeo.org
[mailto:postgis-devel-bounces at lists.osgeo.org] On Behalf Of Stephen Mather
Sent: Friday, February 08, 2013 4:24 PM
To: PostGIS Development Discussion
Subject: Re: [postgis-devel] PostGIS 2.1 "transaction control statements"


GNU sed 4.2.1



On Fri, Feb 8, 2013 at 3:08 PM, Paragon Corporation <lr at pcorp.us> wrote:



It sounds like the BEGIN /END transaction did not get stripped in your
extension building.
 
What version of sed do you have?
 
Thanks,
Regina
http://www.postgis.us
http://postgis.net
 

  _____  

From: postgis-devel-bounces at lists.osgeo.org
[mailto:postgis-devel-bounces at lists.osgeo.org] On Behalf Of Stephen Mather
Sent: Friday, February 08, 2013 9:19 AM
To: postgis-devel at lists.osgeo.org
Subject: [postgis-devel] PostGIS 2.1 "transaction control statements"


Hi All,

       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:

"transaction control statements are not allowed with an extension script"


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.

Best,

Steve Mather


_______________________________________________
postgis-devel mailing list
postgis-devel at lists.osgeo.org
http://lists.osgeo.org/cgi-bin/mailman/listinfo/postgis-devel




-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/postgis-devel/attachments/20130208/b7637b76/attachment.html>