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(dot)klaver(at)aklaver(dot)com