From: | Denis Perchine <dyp(at)perchine(dot)com> |
---|---|
To: | pgsql-general(at)postgresql(dot)org |
Subject: | Re: Recreating indices safely |
Date: | 2001-09-19 17:32:02 |
Message-ID: | 200109191730.f8JHUSt11505@gw.ac-sw.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
On Wednesday 19 September 2001 11:25, Tom Lane wrote:
> 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".
Hmmm... I got deadlock detected... Something was interfered as well...
--
Sincerely Yours,
Denis Perchine
----------------------------------
E-Mail: dyp(at)perchine(dot)com
HomePage: http://www.perchine.com/dyp/
FidoNet: 2:5000/120.5
----------------------------------
From | Date | Subject | |
---|---|---|---|
Next Message | Patrick Welche | 2001-09-19 17:39:16 | Re: Major change to CVS effective immediately ... |
Previous Message | Arne Weiner | 2001-09-19 17:22:19 | Re: Why, why, why |