Hi hackers! While working on an extension I encountered a quite tricky question - the extension (with functions in C) creates tables during function calls, these tables must be protected from direct users' queries, at the same time they must remain accessible for all functions of this extension for all users allowed to use this extension.
Could you please advise or give some hint on what is the correct (and secure) way to implement this? Currently I use the owner of the extension as owner when creating such a table inside the function, but maybe there are some pitfalls in this kind of solution? Thanks in advance. -- Regards, Nikita Malakhov Postgres Professional The Russian Postgres Company https://postgrespro.ru/
