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