Re: Plans for 8.2?

On Thu, Jan 12, 2006 at 07:46:18PM -0500, Tom Lane wrote:

> >   * Transaction was committed/aborted/crashed - we have to update pg_clog
> >   * if transaction is still marked as running.
> >   */
> >  if (!TransactionIdDidCommit(xid) && !TransactionIdDidAbort(xid))
> >   TransactionIdAbort(xid);
>
> The comment's "have to" is an overstatement.  The transaction would be
> treated as crashed anyway, it's just that this is a convenient place to
> make pg_clog a bit cleaner.  I'm not real sure why we bother, actually.

Because that's what makes PostgreSQL such a reliable
product. You follow your intuition and taste and bother
doing cleanup even if you cannot immediately tell whether
it's *really* needed.

Better safe than sorry. Not a bad idea for a database.

Karsten (who is storing clinical data in PostgreSQL)
--
GPG key ID E4071346 @ wwwkeys.pgp.net
E167 67FD A291 2BEA 73BD  4537 78B9 A9F9 E407 1346