• Tom Lane's avatar
    Fix up pg_dump's handling of per-attribute compression options. · aa25d108
    Tom Lane authored
    The approach used in commit bbe0a81d would've been disastrous for
    portability of dumps.  Instead handle non-default compression options
    in separate ALTER TABLE commands.  This reduces chatter for the
    common case where most columns are compressed the same way, and it
    makes it possible to restore the dump to a server that lacks any
    knowledge of per-attribute compression options (so long as you're
    willing to ignore syntax errors from the ALTER TABLE commands).
    
    There's a whole lot left to do to mop up after bbe0a81d, but
    I'm fast-tracking this part because we need to see if it's
    enough to make the buildfarm's cross-version-upgrade tests happy.
    
    Justin Pryzby and Tom Lane
    
    Discussion: https://postgr.es/m/20210119190720.GL8560@telsasoft.com
    aa25d108
pg_backup_archiver.c 125 KB