Re: COMMIT in PostgreSQL

You probably need to execute a "begin;" statement first if you want to start
a transaction.

Sam


> -----Original Message-----
> From: stefan@extum.com [mailto:stefan@extum.com]
> Sent: 20 July 2002 12:51
> To: pgsql-general@postgresql.org
> Subject: [GENERAL] COMMIT in PostgreSQL
> 
> 
> 
> 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
> 
> 
> ---------------------------(end of 
> broadcast)---------------------------
> TIP 6: Have you searched our list archives?
> 
> http://archives.postgresql.org
>