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.klaver@xxxxxxxxxxx
