timur(dot)luchkin(at)gmail(dot)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(at)pgfoundry(dot)org(dot)
regards, tom lane