Re: ALTER TABLE .. ADD PRIMARY KEY .. USING INDEX has dump-restore hazard

Поиск
Список
Период
Сортировка
От Michael Paquier
Тема Re: ALTER TABLE .. ADD PRIMARY KEY .. USING INDEX has dump-restore hazard
Дата
Msg-id CAB7nPqRjuDRi2Br1zuY3F7iN9+yAvGustLEyJLy3ZbuQ7KcoKQ@mail.gmail.com
обсуждение исходный текст
Ответ на Re: ALTER TABLE .. ADD PRIMARY KEY .. USING INDEX has dump-restore hazard  (Michael Paquier <michael.paquier@gmail.com>)
Список pgsql-hackers
On Thu, Jul 23, 2015 at 9:06 AM, Michael Paquier
<michael.paquier@gmail.com> wrote:
> Yeah, I think we should be able to define a collation in this case.
> For example it is as well possible to pass a WITH clause with storage
> parameters, though we do not document it in
> table_constraint_using_index
> (http://www.postgresql.org/docs/devel/static/sql-altertable.html).

Mistake here, please ignore this remark. USING INDEX does not accept
WITH storage_parameter but ADD CONSTRAINT without an index does and it
is documented in CREATE TABLE.
-- 
Michael



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

Предыдущее
От: Kouhei Kaigai
Дата:
Сообщение: Re: Parallel Seq Scan
Следующее
От: Paul Ramsey
Дата:
Сообщение: Re: [PATCH] postgres_fdw extension support