Re: Index Administration: pg_index vs. pg_get_indexdef()

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: Index Administration: pg_index vs. pg_get_indexdef()
Дата
Msg-id 10601.1132721768@sss.pgh.pa.us
обсуждение исходный текст
Ответ на Index Administration: pg_index vs. pg_get_indexdef()  ("Thomas F. O'Connell" <tfo@sitening.com>)
Ответы Re: Index Administration: pg_index vs. pg_get_indexdef()  ("Thomas F. O'Connell" <tfo@sitening.com>)
Список pgsql-general
"Thomas F. O'Connell" <tfo@sitening.com> writes:
> In an old thread <http://archives.postgresql.org/pgsql-admin/2004-01/
> msg00271.php>, Tom Lane suggested that it would be "unreasonable" to
> use pg_index to reconstruct (expressional) indexes (in 7.4). The
> suggested alternative was to use pg_get_indexdef().

IIRC, the point I was trying to make was that making client code try to
interpret the contents of pg_index.indexprs or pg_index.indpred is a
losing proposition.  If you feel that you'd rather read the other fields
of pg_index for yourself, I won't argue with you.

            regards, tom lane

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

Предыдущее
От: "Rick Schumeyer"
Дата:
Сообщение: tsearch2: more than one index per table?
Следующее
От: "Thomas F. O'Connell"
Дата:
Сообщение: Re: Index Administration: pg_index vs. pg_get_indexdef()