I notice this in 7.3.4:
test=# create table test (a int4, b int4);
CREATE TABLE
test=# create index idx on test(a) where b is null;
CREATE INDEX
test=# \d test
Table public.test
Column | Type | Modifiers
+-+---
a | integer |
b | integer |
Indexes: idx
Christopher Kings-Lynne [EMAIL PROTECTED] writes:
I cannot think of any commit that fixed that??? Is it fixed in 7.3.5?
7.3.5 exhibits the same misbehavior. The bug is actually that the index
doesn't get dropped when you drop the column, and it was fixed here:
2003-05-28 12:03 tgl