Re: How to trace client sql requests?

Поиск
Список
Период
Сортировка
От Alban Hertroys
Тема Re: How to trace client sql requests?
Дата
Msg-id 215D5260-3D98-4CFF-A5BA-50C7A8504E3A@solfertje.student.utwente.nl
обсуждение исходный текст
Ответ на How to trace client sql requests?  ("James B. Byrne" <byrnejb@harte-lyne.ca>)
Список pgsql-general
On Jul 10, 2009, at 7:38 PM, James B. Byrne wrote:

> I have a situation with a Rails project where test data in
> mysteriously "disappearing" in the middle of a test run.  I would
> like to see the exact SQL of all client requests issued against a
> single table during a fixed time span.


Are you sure you're looking at that data from the same connection, or
if not, that the inserts get committed? I've seen data "disappear" if
people forgot they were in a transaction block and didn't commit at
the end.

Alban Hertroys

--
If you can't see the forest for the trees,
cut the trees and you'll see there is no forest.


!DSPAM:737,4a58614910131561119940!



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

Предыдущее
От: Alban Hertroys
Дата:
Сообщение: Re: Best practices to WorkFlow design?
Следующее
От: Niederland
Дата:
Сообщение: Re: Postgres 8.4 literal escaping