Re: COMMIT in PostgreSQL
От | Sam Liddicott |
---|---|
Тема | Re: COMMIT in PostgreSQL |
Дата | |
Msg-id | D38A0FCD5830E848992DF2D4AF5F6F4FB953E3@conwy.leeds.ananova.internal обсуждение исходный текст |
Ответ на | COMMIT in PostgreSQL (stefan@extum.com) |
Список | pgsql-general |
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 >
В списке pgsql-general по дате отправления: