Can I read the data without commit

Поиск
Список
Период
Сортировка
От John Fabiani
Тема Can I read the data without commit
Дата
Msg-id 2388789.tLQtTxa0cR@linux-12
обсуждение исходный текст
Ответы Re: Can I read the data without commit  ("Jonathan S. Katz" <jonathan.katz@excoventures.com>)
Список pgsql-sql
Hi,
I know this is a newbie question but I have never had the need to do the 
following.

I start a transaction.
Begin

Then I insert a lot of data - let's say two hundred rows.

Now I need to read the same data (so the user can review).

If the user thinks all is right then 
commit.

Can I read the data I just inserted without committing?

Johnf


В списке pgsql-sql по дате отправления:

Предыдущее
От: Bear
Дата:
Сообщение: Problem with inserting data produced by the function (when the function is performed).
Следующее
От: "Jonathan S. Katz"
Дата:
Сообщение: Re: Can I read the data without commit