| From: | Vadim Mikheev <vadim(at)krs(dot)ru> |
|---|---|
| To: | Bruce Momjian <maillist(at)candle(dot)pha(dot)pa(dot)us> |
| Cc: | PostgreSQL-general <pgsql-general(at)postgreSQL(dot)org> |
| Subject: | Re: [GENERAL] removal of types |
| Date: | 1998-08-11 07:13:30 |
| Message-ID: | 35CFEF1A.387CC67F@krs.ru |
| 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...
Vadim
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Dimitri | 1998-08-11 08:37:30 | Optimizer Question |
| Previous Message | Bruce Momjian | 1998-08-11 06:24:46 | removal of types |