Re: Index - Mailing list pgsql-general

From Ravi Krishna
Subject Re: Index
Date
Msg-id 22DDC49C-6FAD-4B45-AC05-464C263F7E98@aol.com
Whole thread Raw
In response to Index  (Sonam Sharma <sonams1209@gmail.com>)
List pgsql-general
>
> I have created indexes with certain set of columns. Now I want to remove one of the column and add new column. Can
thisdone without dropping the index? 
>

If you intent is to avoid taking that table offline while the index is being built, you can do this:

1. create index concurrently on the new set of columns
2. once (1) done drop old index




pgsql-general by date:

Previous
From: Luca Ferrari
Date:
Subject: Re: Index
Next
From: Yessica Brinkmann
Date:
Subject: I think that my data is saved correctly, but when printing again,other data appears