Temp tables and replication identities

Поиск
Список
Период
Сортировка
От Michael Lewis
Тема Temp tables and replication identities
Дата
Msg-id CAHOFxGpnP3Pf5bWRhyP-3NxgtfJsTNMzo0YtvNC75iB+4a=eTw@mail.gmail.com
обсуждение исходный текст
Список pgsql-general
I am curious about receiving an error on updating/inserting into a temp table when a replication for "all tables' is created in PG 10.6. Given temp tables are not replicated, it seems odd that an update fails unless a replication identity is defined.

To reproduce, try the below code. Uncomment line 3 and the error is gone of course. It just seems like the identity should not be need to be defined on a temp table since it won't be replicated anyway.

CREATE publication test1 FOR ALL TABLES;
CREATE TEMP TABLE testing123 ON COMMIT DROP AS ( SELECT 1 AS value );
/* ALTER TABLE pg_temp.testing123 REPLICA IDENTITY FULL; */
UPDATE testing123 SET value = 2;


Michael Lewis  |  Software Engineer
Entrata

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

Предыдущее
От: github kran
Дата:
Сообщение: Postgresql RDS DB Latency Chossing Hash join Plan
Следующее
От: Michael Lewis
Дата:
Сообщение: Re: Postgresql RDS DB Latency Chossing Hash join Plan