Re: 'DROP INDEX' kills stored rpocedures

On Wed, 2 Apr 2003, Vlad Krupin wrote:

> this is my first post to this mailing list, so if this is the wrong 
> list, direct me to the right one please.
> also, please cc: to me because I am not (yet) subscribed.
> 
> 1. I understand that working with indexes is outside the scope of 
> transaction. That is, if you start a transaction, then drop an index, at 
> that very moment, before the transaction is committed, the index will be 
> unavailable to any other concurrently running queries. I didn't find 
> that in documentation, but a small experiment showed that to be true.

Don't make assumptions like that.  In postgresql, DDL is transactionable.

begin;
drop index test;
create index test on table (field);
commit;

will work just fine.