Re: Phantom Command ID

From: Heikki Linnakangas <heikki(at)enterprisedb(dot)com>
To: PostgreSQL-development <pgsql-hackers(at)postgresql(dot)org>
Subject: Re: Phantom Command ID
Date: 2006-09-21 11:00:56
Message-ID: 451270E8.5090905@enterprisedb.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

Another question is, what should cmin and cmax system columns return? If
we overlay cmin and cmax, cmin and cmax on-disk will always be the same
value. And with phantom cids, it wouldn't be meaningful outside the
inserting/deleting transaction.

The options that I can think of are:

1. Only return cmin and cmax when they mean something, that is within
the inserting / deleting transaction. This is not good if you want to
use them for debugging (and what other use do they have?)

2. Cmin and cmax return the value that's stored on disk, whether or not
they make sense.

3. Remove cmin and cmax system columns to avoid confusion, and replace
them with cminmax, that returns what's on disk.

--
Heikki Linnakangas
EnterpriseDB http://www.enterprisedb.com

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Simon Riggs 2006-09-21 12:22:08 Re: [COMMITTERS] pgsql: Add documentation for new in-core advisory
Previous Message Heikki Linnakangas 2006-09-21 09:46:22 Re: Phantom Command ID