Re: FK Constraint sort order with pg_dump

On 7/21/22 10:59, Christian Barthel wrote:
> On Thursday, July 21, 2022, Adrian Klaver wrote:

>> Why does it matter?
>
> As the comment in pg_dump.c states, logically identical schemas should
> produce identical dumps:
>
> | * We rely on dependency information to help us determine a safe order,
> | so * the initial sort is mostly for cosmetic purposes: we sort by name
> | to * ensure that logically identical schemas will dump identically.
> <https://git.postgresql.org/gitweb/?p=postgresql.git;a=blob;f=src/bin/pg_dump/pg_dump.c#l883>
>
> This is done for most objects (tables, functions etc). Why not for FK
> constraints?
>
> It makes comparing schemas on different postgres instances simpler
> (i.e. when you’re working with testing, staging, live systems etc).
>

Alright that I can see.

--
Adrian Klaver
adrian(dot)klaver(at)aklaver(dot)com