Re: pgsql: Get rid of pg_class.reltoastidxid.

Поиск
Список
Период
Сортировка
От Andres Freund
Тема Re: pgsql: Get rid of pg_class.reltoastidxid.
Дата
Msg-id 20140115122948.GF9762@awork2.anarazel.de
обсуждение исходный текст
Ответ на pgsql: Get rid of pg_class.reltoastidxid.  (Fujii Masao <fujii@postgresql.org>)
Ответы Re: pgsql: Get rid of pg_class.reltoastidxid.  (Michael Paquier <michael.paquier@gmail.com>)
Список pgsql-committers
Hi Fujii, Michael,

Coverity indicated that there's a problem with this - a quick look
confirms that:

    foreach(lc, indexlist)
        (*toastidxs)[i++] = index_open(lfirst_oid(lc), lock);

    /* Fetch the first valid index in list */
    for (i = 0; i < *num_indexes; i++)
    {
        Relation toastidx = *toastidxs[i];
        if (toastidx->rd_index->indisvalid)
        {
            res = i;
            found = true;
            break;
        }
    }

Note how the second access to toastidxs is missing parentheses. It
should be (*toastidxs)[i].

I think this happens to mostly work because usually the older index will
still be valid when we open the toast indexes when there are multiple
ones and RelationGetIndexList() returns indexes in toast order.

Greetings,

Andres Freund

--
 Andres Freund                       http://www.2ndQuadrant.com/
 PostgreSQL Development, 24x7 Support, Training & Services


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

Предыдущее
От: Tom Lane
Дата:
Сообщение: pgsql: Improve FILES section of psql reference page.
Следующее
От: Michael Paquier
Дата:
Сообщение: Re: pgsql: Get rid of pg_class.reltoastidxid.