Peter Eisentraut <peter.eisentraut@2ndquadrant.com> writes:
> What is the general coding principle here? "You need an CCI $WHEN"?
The general principle is "there should be a CCI after each independent
set of data/catalog changes". You don't typically need CCI between
the primitive actions of a single DDL statement like CREATE SEQUENCE,
because you know that those actions are independent and don't look at
each others' output. But you need one at the end, in case whatever
happens next should be able to see the results of the statement.
In another universe the rule might have been "CCI before each independent
set of actions", rather than after. But we haven't done it that way.
Mixing those two styles as a method of fixing bugs seems like a horrid
idea: you eventually end up with fore-AND-aft CCIs everywhere, because
nobody knows what the preceding or following statements might've done.
For better or worse, the PG rule is CCI-after, and the stuff that does
DDL on identity sequences has to fall in line.
regards, tom lane