Re: [GENERAL] removal of types

From: Bruce Momjian <maillist(at)candle(dot)pha(dot)pa(dot)us>
To: vadim(at)krs(dot)ru (Vadim Mikheev)
Cc: pgsql-general(at)postgreSQL(dot)org
Subject: Re: [GENERAL] removal of types
Date: 1998-08-11 14:34:01
Message-ID: 199808111434.KAA13760@candle.pha.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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(at)candle(dot)pha(dot)pa(dot)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)

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Tom Good 1998-08-11 17:04:38 Re: [GENERAL] clean database
Previous Message Ryan Mchale 1998-08-11 11:17:00 clean database