pg_dump losing index column collations for unique and primary keys

Поиск
Список
Период
Сортировка
От Alexey Bashtanov
Тема pg_dump losing index column collations for unique and primary keys
Дата
Msg-id b05ce36a-cefb-ca5e-b386-a400535b1c0b@imap.cc
обсуждение исходный текст
Ответы Re: pg_dump losing index column collations for unique and primary keys  (Tom Lane <tgl@sss.pgh.pa.us>)
Список pgsql-bugs
Hello,

I found that pg_dump fails to note down the collations used primary and 
unique keys supporting indexes.
To reproduce:

create table f(a text);
create unique index f_pkey on f(a collate "C.UTF-8");
alter table f add primary key using index f_pkey;
\d f

pg_dump -t f

The only way to dump it correctly is to create indexes explicitly and 
then use them in constraint definitions.
Please could someone have a look at the patch attached. Thank you.

Best,
   Alex

Вложения

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

Предыдущее
От: MOHAN KUMAR DORAIRAJ
Дата:
Сообщение: Re: BUG #16145: Not able to terminate active session
Следующее
От: Tomas Vondra
Дата:
Сообщение: Re: BUG #16145: Not able to terminate active session