Denis Perchine <dyp(at)perchine(dot)com> writes:
> BTW, using begin; lock table; create index;drop index;commit; is not working,
??
regression=# create table foo (f1 text);
CREATE
regression=# create index fooi1 on foo(f1);
CREATE
regression=# begin;
BEGIN
regression=# lock table foo;
LOCK TABLE
regression=# create index fooi2 on foo(f1);
CREATE
regression=# drop index fooi1;
DROP
regression=# end;
COMMIT
Please define "not working".
regards, tom lane