Re: Implementation of global temporary tables?
От
Zhaomo Yang
Тема
Re: Implementation of global temporary tables?
Дата
Msg-id
CA+0EDdBePOakZ__PvtmeZ77-q4MCEF-x8BvE=a3yU6_iD_2fVw@mail.gmail.com
Ответ на
Re: Implementation of global temporary tables? (Pavel Stehule)
Список
Дерево обсуждения
Implementation of global temporary tables? Pavel Stehule <pavel.stehule@gmail.com>
Re: Implementation of global temporary tables? Andres Freund <andres@2ndquadrant.com>
Re: Implementation of global temporary tables? Pavel Stehule <pavel.stehule@gmail.com>
Re: Implementation of global temporary tables? Andres Freund <andres@2ndquadrant.com>
Re: Implementation of global temporary tables? Pavel Stehule <pavel.stehule@gmail.com>
Re: Implementation of global temporary tables? Atri Sharma <atri.jiit@gmail.com>
Re: Implementation of global temporary tables? Pavel Stehule <pavel.stehule@gmail.com>
Re: Implementation of global temporary tables? Atri Sharma <atri.jiit@gmail.com>
Re: Implementation of global temporary tables? Pavel Stehule <pavel.stehule@gmail.com>
Re: Implementation of global temporary tables? Atri Sharma <atri.jiit@gmail.com>
Re: Implementation of global temporary tables? Pavel Stehule <pavel.stehule@gmail.com>
> there is other question - what is effect of ALTER TABLE of global temp table on
> instances of this table in active sessions?
As I said, we need to first agree on the behaviors of the existing commands. I can think of two options now for ALTER TABLE: 1) only allow ALTER TABLE when there is no other active sessions (this is how Oracle deals with it.) 2) handle it as if session copies inherit from the global copy and ALTER TABLE executes on the global copy.
Thanks,
Zhaomo
As I said, we need to first agree on the behaviors of the existing commands. I can think of two options now for ALTER TABLE: 1) only allow ALTER TABLE when there is no other active sessions (this is how Oracle deals with it.) 2) handle it as if session copies inherit from the global copy and ALTER TABLE executes on the global copy.
Thanks,
Zhaomo
В списке pgsql-hackers по дате отправления
