Re: a few questions (and doubts) about xid

Поиск
Список
Период
Сортировка
От Luca Ferrari
Тема Re: a few questions (and doubts) about xid
Дата
Msg-id 200707270920.57235.fluca1978@infinito.it
обсуждение исходный текст
Ответ на Re: a few questions (and doubts) about xid  (Tom Lane <tgl@sss.pgh.pa.us>)
Ответы Re: a few questions (and doubts) about xid  (Alvaro Herrera <alvherre@commandprompt.com>)
Список pgsql-general
Thanks all for your comments. Just another little hint here (sorry for trivial
questions):

    if (TransactionIdIsCurrentTransactionId(HeapTupleHeaderGetXmax(tuple)))
    {
        if (tuple->t_infomask & HEAP_IS_LOCKED)
            return true;
        if (HeapTupleHeaderGetCmax(tuple) >= GetCurrentCommandId())
            return true;        /* deleted after scan started */
        else
            return false;        /* deleted before scan started */
    }

what does that "deleted after scan started" means? How is possible that the
current transaction has deleted the tuple with a command higher than the one
that is still executing? An example could clearify....

Thanks,
Luca

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

Предыдущее
От: "Stuart"
Дата:
Сообщение: generating part of composite key
Следующее
От: "Albe Laurenz"
Дата:
Сообщение: Re: NOTICE Acepted as Error After Upgrade