Обсуждение: BUG #7684: pg_dumpall doesn't sort "CREATE SERVER"s options correctly
BUG #7684: pg_dumpall doesn't sort "CREATE SERVER"s options correctly
От
timur.luchkin@gmail.com
Дата:
The following bug has been logged on the website: Bug reference: 7684 Logged by: Timur Luchkin Email address: timur.luchkin@gmail.com PostgreSQL version: 9.2.1 Operating system: OpenSolaris Description: = Looks like pg_dumpall sorts 'create server FOREIGN DATA WRAPPER' options (keys) as varchar and not as integer. = Example from dumped sql (see "pX" option key): CREATE SERVER can_master_cluster FOREIGN DATA WRAPPER plproxy OPTIONS ( connection_lifetime '1800', p0 'dbname=3Ddatabase11 host=3Dxxx-11 port=3D9811', p1 'dbname=3Ddatabase12 host=3Dxxx-12 port=3D9812', p10 'dbname=3Ddatabase21 host=3Dxxx-21 port=3D9821', p11 'dbname=3Ddatabase22 host=3Dxxx-22 port=3D9822', p12 'dbname=3Ddatabase23 host=3Dxxx-23 port=3D9823', p13 'dbname=3Ddatabase24 host=3Dxxx-24 port=3D9824', p14 'dbname=3Ddatabase25 host=3Dxxx-25 port=3D9825', p15 'dbname=3Ddatabase26 host=3Dxxx-26 port=3D9826', p2 'dbname=3Ddatabase13 host=3Dxxx-13 port=3D9813', p3 'dbname=3Ddatabase14 host=3Dxxx-14 port=3D9814', p4 'dbname=3Ddatabase15 host=3Dxxx-15 port=3D9815', p5 'dbname=3Ddatabase16 host=3Dxxx-16 port=3D9816', p6 'dbname=3Ddatabase17 host=3Dxxx-17 port=3D9817', p7 'dbname=3Ddatabase18 host=3Dxxx-18 port=3D9818', p8 'dbname=3Ddatabase19 host=3Dxxx-19 port=3D9819', p9 'dbname=3Ddatabase20 host=3Dxxx-20 port=3D9820' ); which causes next error during the load: ERROR: Pl/Proxy: partitions must be numbered consecutively HINT: next valid partition number is 2 STATEMENT: CREATE SERVER can_master_cluster ... Old 9.0 'pg_dumpall' doing job correct.
timur.luchkin@gmail.com writes: > Looks like pg_dumpall sorts 'create server FOREIGN DATA WRAPPER' options > (keys) as varchar and not as integer. AFAIK there's no particular guarantee that they're dumped in any specific order. > which causes next error during the load: > ERROR: Pl/Proxy: partitions must be numbered consecutively > HINT: next valid partition number is 2 I'd say this is either a bug or a misdesign of pl/proxy. It should not be expecting that FDW options are stored in any specific physical order. Suggest reporting it at plproxy-users@pgfoundry.org. regards, tom lane