a.bhattacha...@sungard.com wrote: > Hi All, > > > > I am new to Postgresql and I need to turn off the AUTO COMMIT in > PostgreSQL 8.3.Can anyone guide me how to do it as SET AUTOCOMMIT = off; > does not seem to be supported any more in PostgreSQL 8.3.
Just explicitly begin a transaction, like you do in most databases: BEGIN; INSERT ... UPDATE ... COMMIT; Are you perhaps using PostgreSQL from JDBC or ODBC? If so, those client interfaces provide their own ways to manage the "autocommit" setting - which internally just tells the driver to create a transaction and not commit it until you ask it to. One thing to understand by the way: If you're not running a statement in an explicit transaction, it just creates its own transaction when it starts, runs, then commits automatically when it finishes. There's no functional difference between: BEGIN; INSERT ...; COMMIT; and a stand-alone: INSERT ...; -- Craig Ringer -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
