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
