Olivier Macchioni <olivier(dot)macchioni(at)wingo(dot)ch> writes:
> - I assume there is a usage for hash indexes and we don't simply want to deprecate them
There's a school of thought that says we *should* deprecate them as
long as we don't have WAL support, but that viewpoint is not universally
subscribed to.
One of the arguments against Bruce's proposal to print a warning at hash
index creation is that it's a particularly ineffective form of
deprecation. In your example, since the hash index was created by some
app not manually, I'll bet nobody would have seen/noticed the warning
even if there had been one.
regards, tom lane