COMMIT in PostgreSQL - Mailing list pgsql-general

From stefan@extum.com
Subject COMMIT in PostgreSQL
Date
Msg-id Pine.LNX.4.44.0207201446300.3777-100000@extum.com
Whole thread Raw
Responses Re: COMMIT in PostgreSQL
List 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


pgsql-general by date:

Previous
From: stefan@extum.com
Date:
Subject: Re: id and ID in CREATE TABLE
Next
From: Steve Brett
Date:
Subject: Re: COMMIT in PostgreSQL