From: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
---|---|
To: | Peter Eisentraut <peter_e(at)gmx(dot)net> |
Cc: | pgsql-hackers(at)postgreSQL(dot)org |
Subject: | ALTER TYPE COLLATABLE? |
Date: | 2011-02-17 22:50:24 |
Message-ID: | 11548.1297983024@sss.pgh.pa.us |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-hackers |
I observe the following discrepancy between the 9.0 and 9.1 citext
install scripts:
***************
*** 52,58 ****
STORAGE = extended,
-- make it a non-preferred member of string type category
CATEGORY = 'S',
! PREFERRED = false
);
--
--- 49,56 ----
STORAGE = extended,
-- make it a non-preferred member of string type category
CATEGORY = 'S',
! PREFERRED = false,
! COLLATABLE = true
);
--
What are we going to do to allow the citext update script to fix this?
I see no sign that ALTER TYPE can fix it (and am unsure that we'd want
to add such a feature, particularly not right now). Is it time for
a direct UPDATE on the pg_type row? If so, to what? I see
pg_type.typcollation is supposed to be an OID, so how the heck does
one map a bool CREATE TYPE parameter into the catalog entry?
regards, tom lane
From | Date | Subject | |
---|---|---|---|
Next Message | Josh Berkus | 2011-02-17 22:55:12 | Re: Replication server timeout patch |
Previous Message | Jesper Krogh | 2011-02-17 22:35:23 | Re: Estimates not taking null_frac element into account with @@ operator? (8.4 .. git-head) |