COMMIT in PostgreSQL

Поиск
Список
Период
Сортировка
От stefan@extum.com
Тема COMMIT in PostgreSQL
Дата
Msg-id Pine.LNX.4.44.0207201446300.3777-100000@extum.com
обсуждение исходный текст
Ответы Re: COMMIT in PostgreSQL  (Stephane Bortzmeyer <bortzmeyer@nic.fr>)
Список 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 по дате отправления:

Предыдущее
От: stefan@extum.com
Дата:
Сообщение: Re: id and ID in CREATE TABLE
Следующее
От: Steve Brett
Дата:
Сообщение: Re: COMMIT in PostgreSQL