Postgres Pro
Downloads
Home   >   mailing lists

Re: propagating replica identity to partitions - Mailing list pgsql-hackers

From Peter Eisentraut
Subject Re: propagating replica identity to partitions
Date
Msg-id a1750098-5d90-1e61-2beb-c8b74e3332eb@2ndquadrant.com
Whole thread Raw
In response to Re: propagating replica identity to partitions  (Alvaro Herrera <alvherre@2ndquadrant.com>)
Responses Re: propagating replica identity to partitions
List pgsql-hackers
Tree view 
On 2019-02-28 23:41, Alvaro Herrera wrote:
> Maybe ADD GENERATED AS IDENTITY / DROP IDENTITY should recurse; not
> really sure about this one.  Peter?

No, the intention is that only the partition root has the identity
property.  If you wanted to make it recurse, then you'd need to arrange
it so that all partitions refer to the same sequence, but that's
currently not possible.

-- 
Peter Eisentraut              http://www.2ndQuadrant.com/
PostgreSQL Development, 24x7 Support, Remote DBA, Training & Services

pgsql-hackers by date:

Previous
From: Peter Eisentraut
Date:
Subject: Re: pg_basebackup ignores the existing data directory permissions
Next
From: Tomas Vondra
Date:
Subject: Re: [HACKERS] PATCH: multivariate histograms and MCV lists