Re[2]: [HACKERS] Fwd: Joins and links - Mailing list pgsql-hackers

From Leon
Subject Re[2]: [HACKERS] Fwd: Joins and links
Date
Msg-id 1332.990706@udmnet.ru
Whole thread Raw
In response to Re: [HACKERS] Fwd: Joins and links  (Bruce Momjian <maillist@candle.pha.pa.us>)
List pgsql-hackers
Hello Bruce,

Tuesday, July 06, 1999 you wrote:

B> Actually, there is:

B>         select ctid from pg_class;

B>         ctid
B>         ------
B>         (0,1)
B>         (0,2)
B>         ...

B> The number is the block number offset in the block.  It doesn't help
B> because UPDATED rows would get a new tid.  Tid's can be used for short
B> periods if you are sure the data in the table doesn't change, and there
B> is a TODO item to allow ctid reference in the WHERE clause.

It seems that you are moving in a right direction. But these tids
seem to be of short-term use, anyway. Why not to upgrade to full-featured
links at once?

Best regards, Leon




pgsql-hackers by date:

Previous
From: Leon
Date:
Subject: Re[4]: [HACKERS] Fwd: Joins and links
Next
From: Tom Lane
Date:
Subject: Re: Re[4]: [HACKERS] Fwd: Joins and links