Re: Recreating indices safely - Mailing list pgsql-general

From Tom Lane
Subject Re: Recreating indices safely
Date
Msg-id 27273.1000873554@sss.pgh.pa.us
Whole thread Raw
In response to Recreating indices safely  (Denis Perchine <dyp@perchine.com>)
Responses Re: Recreating indices safely
Re: Recreating indices safely
List 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

pgsql-general by date:

Previous
From: Justin Clift
Date:
Subject: Re: www.postgresql.org
Next
From: "Serge V. Tarasov"
Date:
Subject: Re: adding a superuser