public inbox for [email protected]
help / color / mirror / Atom feedFrom: PG Doc comments form <[email protected]>
To: [email protected]
Cc: [email protected]
Subject: Missing information about CREATE TRIGGER on temporary tables
Date: Tue, 08 Mar 2022 15:32:23 +0000
Message-ID: <164675354342.1369298.14513879086676370656@wrigleys.postgresql.org> (raw)
The following documentation comment has been logged on the website:
Page: https://www.postgresql.org/docs/14/sql-createtrigger.html
Description:
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() ...
view thread (3+ messages) latest in thread
reply
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: [email protected]
Cc: [email protected], [email protected], [email protected]
Subject: Re: Missing information about CREATE TRIGGER on temporary tables
In-Reply-To: <164675354342.1369298.14513879086676370656@wrigleys.postgresql.org>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by agora; see mirroring instructions
for how to clone and mirror all data and code used for this inbox