Re: Synchronous commit not... synchronous?

On Fri, Nov 2, 2012 at 4:42 AM, Daniel Farina <daniel(at)heroku(dot)com> wrote:
> On Wed, Oct 31, 2012 at 10:10 PM, Michael Paquier
> <michael(dot)paquier(at)gmail(dot)com> wrote:
>> Btw, I believe that this is correct behavior, because in Peter's case the
>> manual command gets the priority on the value of synchronous_commit, no?
>> If anybody thinks that I am wrong, feel free to argue on that of course...
>
> The idea of canceling a COMMIT statement causing a COMMIT seems pretty
> strange to me.
>
> I would also not expect a cancelled INSERT statement to INSERT, as
> seems would happen by applying the same rules in the
> autocommit/implicit commit case here.

So how should we handle the case where cancel request or SIGINT arrives
while COMMIT is waiting for its WAL to be replicated to the standby? It's hard
to rollback the COMMIT because its WAL has already been flushed to
the disk locally. You think that we should prevent COMMIT at that state
from being canceled?

Regards,

--
Fujii Masao