Обсуждение: removal of types
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)
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
> 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)