public inbox for [email protected]  

help / color / mirror / Atom feed

From: David G. Johnston <[email protected]>
To: Sebastien Flaesch <[email protected]>
To: Pg Docs <[email protected]>
Subject: Re: Missing information about CREATE TRIGGER on temporary tables
Date: Tue, 8 Mar 2022 09:38:39 -0700
Message-ID: <CAKFQuwbVJ_+5vaHkbhCGiK7mPrZ5LtL0HN_tjN2MnG_MoiShwg@mail.gmail.com> (raw)
In-Reply-To: <164675354342.1369298.14513879086676370656@wrigleys.postgresql.org>
References: <164675354342.1369298.14513879086676370656@wrigleys.postgresql.org>

On Tue, Mar 8, 2022 at 9:25 AM PG Doc comments form <[email protected]>
wrote:

> 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() ...
>

Assuming this was moderated and so delayed.  Answered on the -sql list
email thread:

https://www.postgresql.org/message-id/CAKFQuwZNZzgpo%2BP8bF6HG%3DVMq9ZZaw2kpvpgq1KaaL59NFVUTw%40mail...

In short, temporary tables are tables, and the naming behavior is
documented on this page.

David J.

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: <CAKFQuwbVJ_+5vaHkbhCGiK7mPrZ5LtL0HN_tjN2MnG_MoiShwg@mail.gmail.com>

* 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