Re: Tom Lane > Well, the idea was exactly to forbid that sort of setup. Fwiw, pgsphere has remove the problematic operators now:
https://github.com/postgrespro/pgsphere/commit/e810f5ddd827881b06a92a303c5c9fbf997b892e > However, if we get sufficient pushback maybe we should > reconsider --- for example, maybe it'd be sane to enforce > the restriction in ALTER but not CREATE? Hmm, that seems backwards, I'd expect that CREATE might have some checks that could circumvent using ALTER if I really insisted. If CREATE can create things that I can't reach by ALTERing existing other things, that's weird. Let's keep it like it is now in PG17. Christoph
