Re: [GENERAL] removal of types

Поиск
Список
Период
Сортировка
От Bruce Momjian
Тема Re: [GENERAL] removal of types
Дата
Msg-id 199808111434.KAA13760@candle.pha.pa.us
обсуждение исходный текст
Ответ на Re: [GENERAL] removal of types  (Vadim Mikheev <vadim@krs.ru>)
Список pgsql-general
> Bruce Momjian wrote:
> >
> > I would like to remove the following types in 6.4:
> >
> >         oidint2
> >         oidint4
> >         oidname
> >
> > These store composite values, i.e., stores an oid and an int2.  Not sure
> > why these ever existed, and I would be surprised if anyone used them.
>
> local1_template1.bki.source:
>
> declare index pg_attribute_relid_attnam_index on pg_attribute
>         using btree(mkoidname(attrelid, attname) oidname_ops)
>                                                  ^^^^^^^
> declare index pg_attribute_relid_attnum_index on pg_attribute
>         using btree(mkoidint2(attrelid, attnum) oidint2_ops)
>                                                 ^^^^^^^
> Actually, having multi-key indices we could use them
> istead of functional indices...

Yes.  I would have to add multi-key functionality the bootstrap process.


--
Bruce Momjian                          |  830 Blythe Avenue
maillist@candle.pha.pa.us              |  Drexel Hill, Pennsylvania 19026
  +  If your life is a hard drive,     |  (610) 353-9879(w)
  +  Christ can be your backup.        |  (610) 853-3000(h)

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

Предыдущее
От: Dimitri
Дата:
Сообщение: Optimizer Question
Следующее
От: "Ryan Mchale"
Дата:
Сообщение: clean database