Horton

Re: Recreating indices safely

Tom Lane <tgl@sss.pgh.pa.us>

View thread View on postgr.es
From: Tom Lane <tgl@sss.pgh.pa.us>
To: Denis Perchine <dyp@perchine.com>
Cc: pgsql-general@postgresql.org
Date: 2001-09-19T04:25:54Z
Lists: pgsql-general 
Denis Perchine <dyp@perchine.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