jose luis pillado <josel.pillado@xxxxxxxxx> writes: > This solution worked with a real schema, but it did not with a temporary > one. ... > Is there any way to make this work? The temp schema is intentionally excluded from the search path for functions and operators, because otherwise it's just too easy to trojan-horse things. If you really want to create and call a temp function, you have to schema-qualify its name when you call it. To make that a bit less messy, you can use "pg_temp" as an alias for your session's temp schema, rather than having to find out which numbered temp schema you're really using. regards, tom lane
