Re: CURRENT OF causes an error when IndexOnlyScan is used

Поиск
Список
Период
Сортировка
От Anastasia Lubennikova
Тема Re: CURRENT OF causes an error when IndexOnlyScan is used
Дата
Msg-id a6ddf99c-6579-e65a-6abd-c0b6259c15c2@postgrespro.ru
обсуждение исходный текст
Ответ на Re: CURRENT OF causes an error when IndexOnlyScan is used  (Aleksander Alekseev <a.alekseev@postgrespro.ru>)
Ответы Re: CURRENT OF causes an error when IndexOnlyScan is used
Список pgsql-hackers
20.02.2018 12:52, Aleksander Alekseev:
> Hi Anastasia,
>
>> I'd like to propose the patch that fixes the issue.
>> We already have a way to return heaptuple from IndexOnlyScan,
>> but it was not applied to b-tree for some reason.
>>
>> Attached patch solves the reported bug.
>> Moreover, it will come in handy for "index with included attributes" feature
>> [1],
>> where we can store long (and even TOASTed) attributes in indextuple.
>>
>> [1] https://commitfest.postgresql.org/17/1350/
> I believe the patch should include a test that tries to reproduce an
> issue it tries to fix.
>
> Also maybe this code that repeats 3 times can be moved to a separate
> procedure?

Good point. Updated version with test is attached.

-- 
Anastasia Lubennikova
Postgres Professional: http://www.postgrespro.com
The Russian Postgres Company


Вложения

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

Предыдущее
От: David Rowley
Дата:
Сообщение: Re: [HACKERS] Runtime Partition Pruning
Следующее
От: Tom Lane
Дата:
Сообщение: Off-cycle back-branch releases next week