Re: How to check for successfull inserts

Поиск
Список
Период
Сортировка
От Arguile
Тема Re: How to check for successfull inserts
Дата
Msg-id LLENKEMIODLDJNHBEFBOOEJAEFAA.arguile@lucentstudios.com
обсуждение исходный текст
Ответ на Re: How to check for successfull inserts  ("Arguile" <arguile@lucentstudios.com>)
Ответы Re: How to check for successfull inserts  (Tom Lane <tgl@sss.pgh.pa.us>)
Список pgsql-general
Arguile mistakenly wrote:
>
> 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. For the count(*) to be
guaranteed accurate you would have to lock the table in at least a SHARE
MODE level lock. Probably not what you want.



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

Предыдущее
От: "Arguile"
Дата:
Сообщение: Re: How to check for successfull inserts
Следующее
От: Mark kirkwood
Дата:
Сообщение: Fsync on/off For Various Filesystems/Platforms