From: | Leon <leon(at)udmnet(dot)ru> |
---|---|
To: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>, Bruce Momjian <maillist(at)candle(dot)pha(dot)pa(dot)us>, pgsql-hackers(at)postgreSQL(dot)org |
Subject: | Re[2]: [HACKERS] Fwd: Joins and links |
Date: | 1999-07-05 19:46:17 |
Message-ID: | 1332.990706@udmnet.ru |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | 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
From | Date | Subject | |
---|---|---|---|
Next Message | Tom Lane | 1999-07-05 20:33:04 | Re: Re[4]: [HACKERS] Fwd: Joins and links |
Previous Message | Leon | 1999-07-05 19:32:47 | Re[4]: [GENERAL] Joins and links |