The following bug has been logged on the website:
Bug reference: 15063
Logged by: Dan Goodliffe
Email address: dan@randomdan.homeip.net
PostgreSQL version: 10.2
Operating system: Linux
Description:
Given a publication which uses FOR ALL TABLES, so that future tables are
included...
Create a temporary table with no keys or identity etc:
LOG: statement: CREATE TEMPORARY TABLE tmp_masks(atomSpec text[],dateAdded
date,email text,message text,n int,person text)
Execute an update against the table, the update fails:
ERROR: cannot update table "tmp_masks" because it does not have a replica
identity and publishes updates
HINT: To enable updating the table, set REPLICA IDENTITY using ALTER
TABLE.
STATEMENT: UPDATE tmp_masks SET dateadded = dateadded + INTERVAL '1000
years' WHERE dateadded < '1400-01-01'
(yes, the SQL is a hack to fix typos)
I'm not sure if the temporary table has been added to the publication (which
isn't supported) or if the presence of the FOR ALL TABLES publication alone
(without the table being added to it) is enough to trigger the problem.
I can provide more debug/details etc if required given an idea of what's
needed and how to get it.
Thanks.
