>>>>> "Tom" == Tom Lane <t...@sss.pgh.pa.us> writes:
>> So while helping someone with an unrelated issue, I did a quick >> query to look for collation-dependent indexes, and was rather >> shocked to find that not only are there two such in the system >> catalogs, both set to "default" collation, but that one of them is >> in a _shared_ catalog (pg_shseclabel). >> How did that happen? And how could it possibly work? Tom> It probably doesn't, and the reason nobody has noticed is that the Tom> security label stuff has fewer users than I have fingers (and Tom> those people aren't using provider names that would cause anything Tom> interesting to happen). Or possibly not mixing locales between databases. Tom> The most obvious fix is to change "provider" to a NAME column. Tom> What was the other case? We might want to add a regression test Tom> to check for collation-dependent system indexes ... pg_seclabel (also "provider"). -- Andrew (irc:RhodiumToad) -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers
