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.
In response to
pgsql-hackers by date
|Next:||From: Heikki Linnakangas||Date: 2012-01-16 19:17:42|
|Subject: Re: foreign key locks, 2nd attempt|
|Previous:||From: Peter Eisentraut||Date: 2012-01-16 18:52:35|
|Subject: Re: pg_basebackup option for handling symlinks|