Re: How to check for successfull inserts

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: How to check for successfull inserts
Дата
Msg-id 4088.1015687703@sss.pgh.pa.us
обсуждение исходный текст
Ответ на Re: How to check for successfull inserts  ("Arguile" <arguile@lucentstudios.com>)
Список pgsql-general
"Arguile" <arguile@lucentstudios.com> writes:
>> The only other thing I can think of off the top of my head is to
>> count(*) the table in question before and after and return the
>> difference. As you're within a transaction it will be accurate,
>> if rather unwieldy.

> *Danger! Danger Will Robinson!*

> I wasn't thinking properly when I typed this.

Yes you were.  Set the transaction mode to SERIALIZABLE and it'll
work just fine ...

            regards, tom lane

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

Предыдущее
От: Rob Hoopman
Дата:
Сообщение: RULE with conditional behaviour?
Следующее
От: Tom Lane
Дата:
Сообщение: Re: Fsync on/off For Various Filesystems/Platforms (Ending Note)