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

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

Previous
From: Rob Hoopman
Date:
Subject: RULE with conditional behaviour?
Next
From: Tom Lane
Date:
Subject: Re: Fsync on/off For Various Filesystems/Platforms (Ending Note)