On Thu, Nov 1, 2012 at 1:03 PM, David Fetter <david(at)fetter(dot)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';
> INSERT INTO data VALUES ('baz');
> Oh, and how did you get that cancel in?
He enforced a manual cancel from client with something like Ctrl+C to
In this case you do not wait for the slave to confirm that the commit
information has been flushed on its disk.
In response to
pgsql-hackers by date
|Next:||From: David Fetter||Date: 2012-11-01 04:48:13|
|Subject: Re: Synchronous commit not... synchronous?|
|Previous:||From: Amit kapila||Date: 2012-11-01 04:14:18|
|Subject: Re: alter table tablename add column - breaks pl/pgsql
function returns tablename|