is there a way for an application to know if an asynchronously
committed transaction is actually committed or not?
i want to issue some asynchronous transactions and, at some point later,
ensure that they are committed.
if my reading of the code is correct, an empty synchronous commit
(BEGIN;SET LOCAL SYNCHRONOUS_COMMIT TO ON;COMMIT;) doesn't flush
the log, right? if so, is there any good way to force a log flush?
a CHECKPOINT seems a bit overkill for my purpose.
pgsql-novice by date
|Next:||From: JORGE MALDONADO||Date: 2011-02-05 20:43:31|
|Subject: Backing up several PostgreSQL databases|
|Previous:||From: Tom Lane||Date: 2011-02-03 22:29:35|
|Subject: Re: "-t template0" in createdb |