Any idea if alter table drop column and background vacuum will be
implemented by 7.3?
It's really critical for large applications that must run 24/7.

Stephen



Fri, 21 Jun 2002 02:36:06 -0400
"Stephen" <jleelim@hotmail.com>
Alter table drop column and background vacuum?
During the discussion of bools and hash index and partial indexes and 
index growth and everything else, I tried to make a partial index on a 
bool field and got the error that "data type bool has no default operator 
for class hash..."

So, can I cast something to make this work, or is it possible to make 
hash indexes work with bools.  There are a few instances where a small 
percentage of a table is marked false while the rest is true, or vice 
versa, where a partial hash index would be nice to try, and may not have 
the ever expanding index problem that brtees have.

-- 
"Force has no place where there is need of skill.", "Haste in every 
business brings failures.", "This is the bitterest pain among men, to have 
much knowledge but no power." -- Herodotus



Fri, 21 Jun 2002 16:07:38 -0600 (MDT)
Scott Marlowe <scott.marlowe@ihs.com>
Hash and bools
Scott Marlowe <scott.marlowe@ihs.com> writes:
> During the discussion of bools and hash index and partial indexes and 
> index growth and everything else, I tried to make a partial index on a 
> bool field and got the error that "data type bool has no default operator 
> for class hash..."

Well, no.  I can't see much point in hashing for a datatype with only
two values.  (Of course, btree probably sucks too in this case.)

You could probably gin one up pretty quickly using the support routines
for char_ops, if you want one for testing.

			regards, tom lane

Sat, 22 Jun 2002 17:45:09 -0400
Tom Lane <tgl@sss.pgh.pa.us>
Re: Hash and bools 