Re: pg can create duplicated index without any errors even warnning

Поиск
Список
Период
Сортировка
От Peter Geoghegan
Тема Re: pg can create duplicated index without any errors even warnning
Дата
Msg-id CAH2-WzmQz3n1s7jyqwnWeEE0Ktm7G7juxx3QcrFg-i3xKxYAqw@mail.gmail.com
обсуждение исходный текст
Ответ на pg can create duplicated index without any errors even warnning  (Alex <zhihui.fan1213@gmail.com>)
Ответы Re: pg can create duplicated index without any errors even warnning  (Michael Paquier <michael@paquier.xyz>)
Список pgsql-hackers
On Mon, Aug 5, 2019 at 7:34 PM Alex <zhihui.fan1213@gmail.com> wrote:
> is this by design?

Yes. Being able to do this is useful for several reasons. For example,
it's useful to be able to create a new, equivalent index before
dropping the original when the original is bloated. (You could use
REINDEX instead, but that has some disadvantages that you might want
to avoid.)

Questions like this are better suited to the pgsql-general list.

--
Peter Geoghegan



В списке pgsql-hackers по дате отправления:

Предыдущее
От: Masahiko Sawada
Дата:
Сообщение: Re: [Proposal] Table-level Transparent Data Encryption (TDE) and KeyManagement Service (KMS)
Следующее
От: Michael Paquier
Дата:
Сообщение: Re: Assertion for logically decoding multi inserts into the catalog