subject:"\[GENERAL\] non\-zero xmax yet visible"

Re: [GENERAL] non-zero xmax yet visible

2014-01-15 Thread Ming Li

On Wed, Jan 15, 2014 at 10:48 AM, Michael Paquier michael.paqu...@gmail.com wrote: On Wed, Jan 15, 2014 at 1:26 AM, Ming Li mli89...@gmail.com wrote: I'm a little bit confused by the meaning of xmax. The documentation at http://www.postgresql.org/docs/current/static/ddl-system-columns.html

[GENERAL] non-zero xmax yet visible

2014-01-14 Thread Ming Li

I'm a little bit confused by the meaning of xmax. The documentation at http://www.postgresql.org/docs/current/static/ddl-system-columns.html says xmax The identity (transaction ID) of the deleting transaction, or zero for an undeleted row version. It is possible for this column to be nonzero in

Re: [GENERAL] non-zero xmax yet visible

2014-01-14 Thread Michael Paquier

On Wed, Jan 15, 2014 at 1:26 AM, Ming Li mli89...@gmail.com wrote: I'm a little bit confused by the meaning of xmax. The documentation at http://www.postgresql.org/docs/current/static/ddl-system-columns.html says xmax The identity (transaction ID) of the deleting transaction, or zero for