=?UTF-8?Q?Darafei_=22Kom=D1=8Fpa=22_Praliaskouski?= <m...@komzpa.net> writes: > Thanks a lot RhodiumToad on IRC for suggestion of setting HASHES, MERGES on > OPERATOR =. > Now we have other problem: how do we set these flags on upgrade to new > version of extension? Dropping an OPERATOR = will drop all indexes an views > depending on it so isn't really an option.
I think you're going to have to use a direct UPDATE on pg_operator in the extension update script :-(. Perhaps ALTER OPERATOR should be able to handle changing these flags, but for now it can't. regards, tom lane