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

[Stephen Mather]

-- $Id: postgis.sql.in.c 10806 2012-12-06 17:56:37Z pramsey $
...
BEGIN;
...

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?

Best,
Steve


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

> **
> 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
>>
>>
>
> _______________________________________________
> 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/b5ba1c59/attachment.html>