To be confirmed by the developer community... The reference page about CREATE TRIGGER should indicate if it's allowed to create triggers on temp tables. This seems to be the supported, but I was wondering what happens with the trigger name when created on a temp table. It appears that no conflict can occur with other processes, and the same trigger name can be used by different processes. Checking the system tables, it appears that the trigger is created in user's pg_my_temp_schema() ...
Assuming this was moderated and so delayed. Answered on the -sql list email thread:
