Horton

Re: problems with table corruption continued

Tom Lane <tgl@sss.pgh.pa.us>

View thread
From: Tom Lane <tgl@sss.pgh.pa.us>
To: "Hiroshi Inoue" <Inoue@tpf.co.jp>
Cc: "Mikheev, Vadim" <vmikheev@SECTORBASE.COM>, "Brian Hirt" <bhirt@mobygames.com>, "Postgres Hackers" <pgsql-hackers@postgresql.org>, "Brian A Hirt" <bhirt@berkhirt.com>
Date: 2001-12-18T23:01:13Z
Lists: pgsql-hackers 
"Hiroshi Inoue" <Inoue@tpf.co.jp> writes:
> Should the change be TransactionIdIsInProgress(tuple->t_cmin) ?

I'd be willing to do
	if (tuple->t_cmin is my XID)
		do something;
	Assert(!TransactionIdIsInProgress(tuple->t_cmin));
if that makes you feel better.  But anything that's scanning
a table exclusive-locked by another transaction is broken.
(BTW: contrib/pgstattuple is thus broken.  Will fix.)

			regards, tom lane