| 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: | Whole Thread | Raw Message | 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 |