Thread: Alter table drop column and background vacuum?

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

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

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