Re: How to discover what table is

Now I have the same problem with a different message.
I´ve added a table on all schemas and did a refresh publication. when
postgres sees a new table on publisher he goes to replicamand trucates that
table to start copying. ok but I have 300 schemas, how can I know what
schema that table belongs to ?

On log of replica server ...

Message
cannot truncate a table referenced in a foreign key constraint
Detail
Table "rel_indicacao" references "cad_digitacao".
Hint
Truncate table "rel_indicacao" at the same time, or use TRUNCATE ...
CASCADE.




--
Sent from: https://www.postgresql-archive.org/PostgreSQL-general-f1843780.html