[postgis-users] Cross posting: Postgresql 7.4 & cygwin Transactions disabled?

[Jody Garnett]

I have just talked to Dave Blasby - it seems that 7.4 is doing things a 
little differently on the database side of things. It seems that we 
would have to use an updated jdbc driver - and I am not sure if such a 
thing exists yet.

Ideas?

Jody

David Blasby wrote:

>> There has been a bug report that doing transactions with postGIS 0.8 
>> and postgresql 7.4 on cygwin does not work.  The error says 'SET 
>> AUTOCOMMIT TO OFF is no longer supported'.  I looked into this a bit 
>> and it looks like postgresql may have decided to not allow people to 
>> turn autocommit off, for some reason like the application should 
>> manage resources better or something.  We need to look into it further.
>>
>>
>> Could this possibly be true?
>
>
> I belive "SET AUTOCOMMIT = OFF" is no longer supported in 7.4.
>
> If you havent setup a transaction, your commands will be 
> "automagically" surrounded by a 'BEGIN;...COMMIT;' block.
>
> If you have setup a transaction, you must either COMMIT it or ROLLBACK 
> it.
>
> What do you think this should do:
>
> SET AUTOCOMMIT = ON;
> BEGIN;
> insert into mytable values (777);
> ROLLBACK;
>
> If you say '777' should *NOT* be in 'mytable', they you agree with 
> postgresql.  If you say it should be in 'mytable', then why do you 
> think the database should be ignoring the ROLLBACK command?
>
> dave
>
>
> _______________________________________________
> postgis-users mailing list
> postgis-users at postgis.refractions.net
> http://postgis.refractions.net/mailman/listinfo/postgis-users