On 1/11/17 3:35 PM, Petr Jelinek wrote: > On 11/01/17 18:32, Peter Eisentraut wrote: >> On 1/11/17 3:29 AM, Petr Jelinek wrote: >>> Okay, looking into my notes, I originally did this because we did not >>> allow adding tables without pkeys to publications which effectively >>> prohibited FOR ALL TABLES publication from working because of >>> information_schema without this. Since this is no longer the case I >>> think it's safe to skip the FirstNormalObjectId check. >> >> Wouldn't that mean that FOR ALL TABLES replicates the tables from >> information_schema? >> > > Yes, as they are not catalog tables, I thought that was your point.
But we shouldn't do that. So we need to exclude information_schema from "all tables" somehow. Just probably not by OID, since that is not fixed. -- Peter Eisentraut http://www.2ndQuadrant.com/ PostgreSQL Development, 24x7 Support, Remote DBA, Training & Services -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers