Обсуждение: removal of types

Поиск
Список
Период
Сортировка

removal of types

От
Bruce Momjian
Дата:
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.

Comments?

--
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)

Re: [GENERAL] removal of types

От
Vadim Mikheev
Дата:
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...

Vadim

Re: [GENERAL] removal of types

От
Bruce Momjian
Дата:
> 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)