<snip> Now I'm wondering about stray entries in pg_cast. Also, do you have any extensions loaded in that DB that aren't in your other ones? </snip>
Our databases are deployed with automation tools. They should all be created the same. They all have the same 17 extensions. I've asked a DBA to confirm. This issue only appears in the function I have listed. A similar function, same contents and parameter but with a different name, works the way I would expect. On Fri, Jul 25, 2025 at 1:10 PM Tom Lane <t...@sss.pgh.pa.us> wrote: > Rumpi Gravenstein <rgrav...@gmail.com> writes: > > No ... just one version: > > D'oh, actually this would have complained if there was more > than one match, so that theory is wrong: > > > xxxx_pub_dev_2_db=# DROP FUNCTION if exists _sa_setup_role; > > DROP FUNCTION > > Now I'm wondering about stray entries in pg_cast. Also, > do you have any extensions loaded in that DB that aren't > in your other ones? > > regards, tom lane > -- Rumpi Gravenstein
