On mån, 2012-01-16 at 11:17 -0500, Robert Haas wrote: > I don't see how setting indisvalid to false helps with this, because > IIUC when a session sees indisvalid = false, it is supposed to avoid > using the index for queries but still make new index entries when a > write operation happens - but to drop an index, I think you'd need to > get into a state where no one was using the index for anything at all.
ISTM that one would need to set indisready to false instead. -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers
