No ideas? 2011/5/4 Jakub Królikowski <jakub@xxxxxxxxxxxxxxx>: > Hello, > > I've set pl_PL.UTF-8 collation on my database after upgrade do 9.0. > That means indexes for varchar column doesn't work anymore in selects > using "like" or "=" operators with that columns. > I know the solution - operator classes - which works very well. > But that means I have to find and recreate all indexes on varchar > column like this: > CREATE INDEX test_index ON test_table (col varchar_pattern_ops); > > Does anybody know if there is any possibility to set a default > operator class for varchar datatatype? > I can see that in system table pg_catalog.pg_opclass ther is a column > called "opcdefault". Does anybody has an experience with changing that > value? The idea is to set this default operator class and make after > that dump-restore of database data. Should work. > > Best regards, > > Jakub > -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
