From: | Jim Vanns <jvanns(at)ilm(dot)com> |
---|---|
To: | pgsql-general(at)lists(dot)postgresql(dot)org |
Subject: | Re: CREATE TEMPORARY TABLE LIKE |
Date: | 2023-05-25 13:19:51 |
Message-ID: | CAH7vdhNqswRSCj7RSLf12YZrAet411P3PGiXXTiv-RO0cRtQwA@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
I just wrote a little test case... it appears not. Triggers aren't
fired in the temporary table.
Jim
On Thu, 25 May 2023 at 14:06, Jim Vanns <jvanns(at)ilm(dot)com> wrote:
>
> Hi everyone,
>
> When basing a temporary table of a source table, are triggers included
> by default? I have this statement;
>
> CREATE TEMPORARY TABLE dev_main (
> LIKE prod_main
> INCLUDING ALL
> EXCLUDING INDEXES
> EXCLUDING CONSTRAINTS
> ) ON COMMIT DELETE ROWS;
>
> And wondering if there is a trigger (row-based after) on prod_main
> it'll fire also on dev_main? I can't find anything in the
> documentation that suggests either way nor can I see an explicit
> EXCLUDING option to be sure triggers aren't copied.
>
> Does anyone know?
>
> Cheers,
>
> Jim
>
> --
> Jim Vanns
> Principal Production Engineer
> Industrial Light & Magic, London
--
Jim Vanns
Principal Production Engineer
Industrial Light & Magic, London
From | Date | Subject | |
---|---|---|---|
Next Message | Jelte Fennema | 2023-05-25 13:23:40 | Re: Adding SHOW CREATE TABLE |
Previous Message | Ron | 2023-05-25 13:10:42 | Re: DB migration : Sybase to Postgres |