COMMIT in PostgreSQL

From: stefan(at)extum(dot)com
To: pgsql-general(at)postgresql(dot)org
Subject: COMMIT in PostgreSQL
Date: 2002-07-20 11:50:34
Message-ID: Pine.LNX.4.44.0207201446300.3777-100000@extum.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general


Hey,

I was running a script which does some INSERTS and UPDATE some table. I
found that there is no need for COMMIT; After each statement the TABLE is
immediately commited. Other session via psql can sees ASAP the changes to
the table. So it seems a bit different than Oracle's COMMIT . Can somebody
explain me why this is so in PostgreSQL ?

Are the modifications done without commit statement ?

PostgreSQL looks really interesting and seems to be good SQL compliant.
stefan

Responses

Browse pgsql-general by date

  From Date Subject
Next Message stefan 2002-07-20 12:03:02 Re: COMMIT in PostgreSQL
Previous Message stefan 2002-07-20 11:33:22 Re: id and ID in CREATE TABLE