• Tom Lane's avatar
    Create a script that can renumber manually-assigned OIDs. · a6417078
    Tom Lane authored
    This commit adds a Perl script renumber_oids.pl, which can reassign a
    range of manually-assigned OIDs to someplace else by modifying OID
    fields of the catalog *.dat files and OID-assigning macros in the
    catalog *.h files.
    
    Up to now, we've encouraged new patches that need manually-assigned
    OIDs to use OIDs just above the range of existing OIDs.  Predictably,
    this leads to patches stepping on each others' toes, as whichever
    one gets committed first creates an OID conflict that other patch
    author(s) have to resolve manually.  With the availability of
    renumber_oids.pl, we can eliminate a lot of this hassle.
    The new project policy, therefore, is:
    
    * Encourage new patches to use high OIDs (the documentation suggests
    choosing a block of OIDs at random in 8000..9999).
    
    * After feature freeze in each development cycle, run renumber_oids.pl
    to move all such OIDs down to lower numbers, thus freeing the high OID
    range for the next development cycle.
    
    This plan should greatly reduce the risk of OID collisions between
    concurrently-developed patches.  Also, if such a collision happens
    anyway, we have the option to resolve it without much effort by doing
    an off-schedule OID renumbering to get the first-committed patch out
    of the way.  Or a patch author could use renumber_oids.pl to change
    their patch's assignments without much pain.
    
    This approach does put a premium on not hard-wiring any OID values
    in places where renumber_oids.pl and genbki.pl can't fix them.
    Project practice in that respect seems to be pretty good already,
    but a follow-on patch will sand down some rough edges.
    
    John Naylor and Tom Lane, per an idea of Peter Geoghegan's
    
    Discussion: https://postgr.es/m/CAH2-WzmMTGMcPuph4OvsO7Ykut0AOCF_i-=eaochT0dd2BN9CQ@mail.gmail.com
    a6417078
toasting.h 3.77 KB