Consider:
rhaas=# create table foo (a text);
CREATE TABLE
rhaas=# create unique index on foo (a collate "C");
CREATE INDEX
rhaas=# alter table foo add primary key using index foo_a_idx;
ALTER TABLE
rhaas=# \d foo
Table "public.foo"
Column | Type | Modifiers
--------+------+-----------
a | text | not null
Indexes:
"foo_a_idx" PRIMARY KEY, btree (a COLLATE "C")
Now dump and restore this database. Then:
rhaas=# \d foo
Table "public.foo"
Column | Type | Modifiers
--------+------+-----------
a | text | not null
Indexes:
"foo_a_idx" PRIMARY KEY, btree (a)
Notice that the collation specifier is gone. Oops.
--
Robert Haas
EnterpriseDB: http://www.enterprisedb.com
The Enterprise PostgreSQL Company
--
Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-hackers
