Improved highlighting of text search content for multi-word phrases and eliminating partial matches; Includes a methodology for delivering highlighted search result content 5x-10x faster that the PostgreSQL built-in ts_headline function
If the type already exists, catch the exception and move on. If some other kind of exception happens, it will also get ignored, but... hopefully that's uncommon.
This isn't really necessary if the code is being properly loaded as an extension, because you can drop the entire extension and then load up the new version. But @thevermeer and I were loading the code directly on a remote DB where we couldn't install extensions, and running into problems with updating.
I think this is generally pretty safe. The "other kinds of exception" would be like, lacking permissions, but that will break other things so it shouldn't be untraceable.
If the type already exists, catch the exception and move on. If some other kind of exception happens, it will also get ignored, but... hopefully that's uncommon.
This isn't really necessary if the code is being properly loaded as an extension, because you can drop the entire extension and then load up the new version. But @thevermeer and I were loading the code directly on a remote DB where we couldn't install extensions, and running into problems with updating.
I think this is generally pretty safe. The "other kinds of exception" would be like, lacking permissions, but that will break other things so it shouldn't be untraceable.