On 12/28/18 12:59 PM, Mitar wrote:
Hi!
On Fri, Dec 28, 2018 at 12:57 PM Adrian Klaver
<adrian.klaver@xxxxxxxxxxx> wrote:
CREATE OR REPLACE FUNCTION pg_temp.my_function()
And it does what?
Copies/transforms data from posts into posts_temp.
When a row is added to "posts" table outside of my session, function
"my_function" is called, but it seems it cannot access "posts_temp"
table. It seems that "my_function" is called in the session of the
Temp tables can not be seen by other sessions.
Sure, but why is a temporary function used as a temporary trigger made
There is no such thing as a temporary trigger.
from my session not run inside my session? Then it could see a
temporary table made in my session.
Except that is not what your OP stated:
"And I add it to a regular table as a trigger:
CREATE TRIGGER posts_insert AFTER INSERT ON posts REFERENCING NEW
TABLE AS new_table FOR EACH STATEMENT EXECUTE FUNCTION
pg_temp.my_function();
When a row is added to "posts" table outside of my session, function
"my_function" is called, but it seems it cannot access "posts_temp"
table."
So are you talking about another case now?
Mitar
--
Adrian Klaver
adrian.klaver@xxxxxxxxxxx
