Evan Carroll <me@xxxxxxxxxxxxxxx> writes: > Also, here is a copy of the complete script -- including the citext > creation statements from the dump, with the patch, with the bugged > statements. Well, if that's how you're creating citext, then yeah it's broken. As of 9.1 the citext type needs to be created with the attribute "COLLATABLE = true". The suggested UPDATE statements are a means of correcting a failure to do that after-the-fact, but they don't cover any domains that have already been created on top of citext. regards, tom lane -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
