Tom Lane wrote: > Bruce Momjian <[EMAIL PROTECTED]> writes: > > Yea, my question is if you choose "after", do you get everything that > > happens until the "after" transaction commits, or just when it begins. > > If I stop after xid 125, and xid 126 starts and stops before 125 > > commits, does 126 get restored? > > Yes. You don't get to be selective about what to keep: it's everything > up to a certain time instant, and nothing after that. Stopping by XID > is just a different way of identifying what that time instant is. > > BTW, stopping "before" an XID actually means stopping just before its > commit or abort record, so transactions that ended before it did will > be included in the recovery.
OK, I added a mention of this in the docs. -- Bruce Momjian | http://candle.pha.pa.us [EMAIL PROTECTED] | (610) 359-1001 + If your life is a hard drive, | 13 Roberts Road + Christ can be your backup. | Newtown Square, Pennsylvania 19073 ---------------------------(end of broadcast)--------------------------- TIP 9: the planner will ignore your desire to choose an index scan if your joining column's datatypes do not match
