On 2022-Jan-22, Amit Kapila wrote:
> CREATE TABLE parent (a int primary key, b int not null, c varchar)
> PARTITION BY RANGE(a);
> CREATE TABLE child PARTITION OF parent FOR VALUES FROM (0) TO (250);
> CREATE UNIQUE INDEX b_index on child(b);
> ALTER TABLE child REPLICA IDENTITY using INDEX b_index;
>
> In this, the parent table's replica identity is the primary
> key(default) and the child table's replica identity is the b_index.
Why is the partition's replica identity different from its parent's?
Does that even make sense?
--
Álvaro Herrera 39°49'30"S 73°17'W — https://www.EnterpriseDB.com/
"La verdad no siempre es bonita, pero el hambre de ella sí"