From: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
---|---|
To: | Csaba Nagy <nagy(at)ecircle-ag(dot)com> |
Cc: | Jeff Davis <pgsql(at)j-davis(dot)com>, Gregory Stark <stark(at)enterprisedb(dot)com>, Ragnar <gnari(at)hive(dot)is>, Postgres general mailing list <pgsql-general(at)postgresql(dot)org> |
Subject: | Re: Online index builds |
Date: | 2006-12-13 17:01:06 |
Message-ID: | 8976.1166029266@sss.pgh.pa.us |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-announce pgsql-general pgsql-www |
Csaba Nagy <nagy(at)ecircle-ag(dot)com> writes:
> With the "mess" you refer to the new index, and the fact it is
> impossible to delete it if not possible to replace the old one ? I fail
> to see why... you WILL get an exclusive lock, so you should be able to
> delete the index.
Consider the ALTER OWNER example ...
regards, tom lane
From | Date | Subject | |
---|---|---|---|
Next Message | David Fetter | 2006-12-18 08:20:40 | == PostgreSQL Weekly News - December 17 2006 == |
Previous Message | Csaba Nagy | 2006-12-13 16:38:39 | Re: Online index builds |
From | Date | Subject | |
---|---|---|---|
Next Message | Rafal Pietrak | 2006-12-13 17:01:34 | Re: A VIEW mimicing a TABLE |
Previous Message | Tom Lane | 2006-12-13 16:59:18 | Re: Weird PG 8.1.3 date error |
From | Date | Subject | |
---|---|---|---|
Next Message | wheel | 2006-12-13 20:09:21 | Subcribing to this list, what's the secret? |
Previous Message | Csaba Nagy | 2006-12-13 16:38:39 | Re: Online index builds |