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@anonymised.com
postgis-users Info Page