Re: No longer possible to query catalogs for index capabilities?

Поиск
Список
Период
Сортировка
От Andrew Gierth
Тема Re: No longer possible to query catalogs for index capabilities?
Дата
Msg-id 8737mxo747.fsf@news-spur.riddles.org.uk
обсуждение исходный текст
Ответ на Re: No longer possible to query catalogs for index capabilities?  (Tom Lane <tgl@sss.pgh.pa.us>)
Ответы Re: No longer possible to query catalogs for index capabilities?  (Peter Eisentraut <peter.eisentraut@2ndquadrant.com>)
Список pgsql-hackers
>>>>> "Tom" == Tom Lane <tgl@sss.pgh.pa.us> writes:
Tom> Andrew still hasn't shown a concrete example of what he needs toTom> do and why.

The issue I ran into was the exact same one as in the JDBC thread I
linked to earlier: correctly interpreting pg_index.indoption (to get the
ASC / DESC and NULLS FIRST/LAST settings), which requires knowing
whether amcanorder is true to determine whether to look at the bits at
all. The guy I was helping was using an earlier pg version, so it didn't
affect him (yet); I hit it when trying to test the query on 9.6.

-- 
Andrew (irc:RhodiumToad)



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

Предыдущее
От: Andrew Gierth
Дата:
Сообщение: Re: No longer possible to query catalogs for index capabilities?
Следующее
От: "Joshua D. Drake"
Дата:
Сообщение: Re: No longer possible to query catalogs for index capabilities?