Results 1 to 2 of 2
  1. #1
    Join Date
    Mar 2004
    Posts
    205

    Unanswered: set autocommit equivalent ?

    Hi,

    What is the Postgres equivalent for "set autocommit on" of Oracle ?

    Thanks,
    Sam

  2. #2
    Join Date
    Sep 2001
    Location
    Vienna
    Posts
    400

    autocommit

    http://www.postgresql.org/docs/7.4/i...lease-7-4.html

    The server-side autocommit setting was removed and reimplemented in client applications and languages. Server-side autocommit was causing too many problems with languages and applications that wanted to control their own autocommit behavior, so autocommit was removed from the server and added to individual client APIs as appropriate.


    set autocommit to on;

    set autocommit to off; removed

    Autocommit is always true at the moment
    hope this helps
    http://www.postgresql.org
    --Postgresql is the only kind of thing--

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •