Re: Questions about update, delete, ctid...

Поиск
Список
Период
Сортировка
От Florian G. Pflug
Тема Re: Questions about update, delete, ctid...
Дата
Msg-id 44CCC426.4080408@phlo.org
обсуждение исходный текст
Ответ на Re: Questions about update, delete, ctid...  (Martijn van Oosterhout <kleptog@svana.org>)
Ответы Re: Questions about update, delete, ctid...  (Martijn van Oosterhout <kleptog@svana.org>)
Список pgsql-general
Martijn van Oosterhout wrote:
> On Fri, Jul 28, 2006 at 12:00:19PM +0200, DANTE Alexandra wrote:
>> - is it correct to think that the ctid of the old version of the tuple
>> is a link to newer version ? In my example, is it correct to think that
>> the tuple :
>> 140049    |    0 | (0,12) |          11 | IRAQ
>> has become :
>> new value |    0 | (0,26) |          11 | ITALY
>
> The word "become" is not really right. The old version has become
> invisible to you and the new version is visible. Some other
> transactions will see the old one, some the new one. However, there is
> a link between the old and the new version do detect conflicting
> updates.

That sounds interesting... how is that link between old and new
tuple implemented? I've been playing with the idea to implement
"update table foo where current of <cursor>", and such a link
would help tremendously. I read the code, but couldn't find any
such link - which part of the code should I read closer?

greetings, Florian Pflug


В списке pgsql-general по дате отправления:

Предыдущее
От: Martijn van Oosterhout
Дата:
Сообщение: Re: Corrupted DB? could not open file pg_clog/####
Следующее
От: Martijn van Oosterhout
Дата:
Сообщение: Re: Questions about update, delete, ctid...