Re: How to discover what table is

On 3/10/20 5:16 AM, PegoraroF10 wrote:
> 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 ?

Postgres version(s)?

Are you using the built in logical replication or the pglogical plugin?


> 
> 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
> 
> 


-- 
Adrian Klaver
adrian.klaver@aklaver.com