Re: Missing information about CREATE TRIGGER on temporary tables

Поиск
Список
Период
Сортировка
От David G. Johnston
Тема Re: Missing information about CREATE TRIGGER on temporary tables
Дата
Msg-id CAKFQuwbVJ_+5vaHkbhCGiK7mPrZ5LtL0HN_tjN2MnG_MoiShwg@mail.gmail.com
обсуждение исходный текст
Ответ на Missing information about CREATE TRIGGER on temporary tables  (PG Doc comments form <noreply@postgresql.org>)
Список pgsql-docs
On Tue, Mar 8, 2022 at 9:25 AM PG Doc comments form <noreply@postgresql.org> 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:


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

David J.

В списке pgsql-docs по дате отправления:

Предыдущее
От: Jian He
Дата:
Сообщение: list all the Boolean flags in pg_class that are maintained lazily.
Следующее
От: Tom Lane
Дата:
Сообщение: Re: Missing information about CREATE TRIGGER on temporary tables