From 6ff21c05302592874b8149421711e06043b954fe Mon Sep 17 00:00:00 2001
From: Peter Eisentraut
Date: Mon, 15 Apr 2024 09:28:48 +0200
Subject: psql: Make output of \dD more stable

\dD showed domain check constraints in arbitrary order, which can
cause regression test failures, which was exposed by commit
9895b35cb8.  To fix, order the constraints by conname, which matches
what psql does in other queries listing constraints.
---
 src/test/regress/expected/domain.out | 2 +-
 1 file changed, 1 insertion(+), 1 deletion(-)

(limited to 'src/test')

diff --git a/src/test/regress/expected/domain.out b/src/test/regress/expected/domain.out
index db0b8a180a3..f65b66345ab 100644
--- a/src/test/regress/expected/domain.out
+++ b/src/test/regress/expected/domain.out
@@ -789,7 +789,7 @@ alter domain con add check (VALUE > 0);
                                          List of domains
  Schema | Name |  Type   | Collation | Nullable | Default |                Check                 
 --------+------+---------+-----------+----------+---------+--------------------------------------
- public | con  | integer |           |          |         | CHECK (VALUE < 34) CHECK (VALUE > 0)
+ public | con  | integer |           |          |         | CHECK (VALUE > 0) CHECK (VALUE < 34)
 (1 row)
 
 insert into domcontest values (-5); -- fails
-- 
cgit v1.2.3