Only dump non-default sequence access methods
authorCraig Ringer <craig@2ndquadrant.com>
Tue, 26 May 2015 02:18:10 +0000 (10:18 +0800)
committerCraig Ringer <craig@2ndquadrant.com>
Tue, 26 May 2015 02:22:56 +0000 (10:22 +0800)
commit1592812131d84de56ba258c333f936e5e19647e2
treec2805a2ee90ffadb150a8f1470b8217b14fba2d4
parent3a125a7221a02426e5f3ece209a1064fa8c4c0b5
Only dump non-default sequence access methods

To prevent issues with UDR and with restoring BDR dumps to non-BDR
databases, don't emit a USING clause unless the pg_seqam catalog is
present and the dumped sequence uses a non-default sequence access
method.

The dump should be restored with default_seqam = 'local' to ensure
that local sequences aren't transformed into 'bdr' sequences during
restore.
src/bin/pg_dump/pg_dump.c