Text to centreline function can't be used in Materialized Views: "ERROR: cannot create temporary table within security-restricted operation"

[radumas]

It's because it works by creating a temporary table and that's not allowed within a Mat View https://stackoverflow.com/a/51876069/4047679.

Possible fixes:

1. (unclear) Create randomly generated tablenames and delete at the end of the function
2. (unclear) Create a sequential tablename in a temp schema and delete and the end of the function
3. (dangerous?) Drop the table if exists, and then create it. Could lead to race condition or interrupted work
4. (lots of effort) Rewrite the function to be entirely... procedural code (no querying)