On Thu, Nov 1, 2012 at 1:03 PM, David Fetter <david@fetter.org> wrote:
On Wed, Oct 31, 2012 at 06:39:20PM -0700, Peter van Hardenberg wrote: > This was rather surprising - my synchronous commit was... not > cancelled. Is this expected behaviour?
I believe it is.
Does the following do the right thing?
SET synchronous_commit='on'; BEGIN; INSERT INTO data VALUES ('baz'); COMMIT;^c
Oh, and how did you get that cancel in?
He enforced a manual cancel from client with something like Ctrl+C to cancel query. In this case you do not wait for the slave to confirm that the commit information has been flushed on its disk.
