Re: How to check for successfull inserts - Mailing list pgsql-general

From Arguile
Subject Re: How to check for successfull inserts
Date
Msg-id LLENKEMIODLDJNHBEFBOOEJAEFAA.arguile@lucentstudios.com
Whole thread Raw
In response to Re: How to check for successfull inserts  ("Arguile" <arguile@lucentstudios.com>)
Responses Re: How to check for successfull inserts  (Tom Lane <tgl@sss.pgh.pa.us>)
List 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 by date:

Previous
From: "Arguile"
Date:
Subject: Re: How to check for successfull inserts
Next
From: Mark kirkwood
Date:
Subject: Fsync on/off For Various Filesystems/Platforms