diff options
| author | Alvaro Herrera <alvherre@alvh.no-ip.org> | 2024-07-12 13:44:19 +0200 |
|---|---|---|
| committer | Alvaro Herrera <alvherre@alvh.no-ip.org> | 2024-07-12 13:44:19 +0200 |
| commit | 34eb37f7921b0f0dd720570957858b9650dfc1ab (patch) | |
| tree | 8f06f8b918235cb7739aab15b34a1896f4d72c41 /src | |
| parent | 00a40e33c0a4b34e5c8456cd0b5ab4084bba78a0 (diff) | |
| download | postgresql-34eb37f7921b0f0dd720570957858b9650dfc1ab.tar.gz postgresql-34eb37f7921b0f0dd720570957858b9650dfc1ab.zip | |
Add ORDER BY to new test query
Per buildfarm.
Diffstat (limited to 'src')
| -rw-r--r-- | src/test/regress/expected/constraints.out | 3 | ||||
| -rw-r--r-- | src/test/regress/sql/constraints.sql | 3 |
2 files changed, 4 insertions, 2 deletions
diff --git a/src/test/regress/expected/constraints.out b/src/test/regress/expected/constraints.out index 03aec26657c..cf0b80d6169 100644 --- a/src/test/regress/expected/constraints.out +++ b/src/test/regress/expected/constraints.out @@ -639,7 +639,8 @@ CREATE UNIQUE INDEX t_b_idx ON t (b, a); ALTER INDEX t_a_idx ATTACH PARTITION tp_pkey; ALTER INDEX t_b_idx ATTACH PARTITION tp_b_a_key; SELECT conname, conparentid, conislocal, coninhcount - FROM pg_constraint WHERE conname IN ('tp_pkey', 'tp_b_a_key'); + FROM pg_constraint WHERE conname IN ('tp_pkey', 'tp_b_a_key') + ORDER BY conname DESC; conname | conparentid | conislocal | coninhcount ------------+-------------+------------+------------- tp_pkey | 0 | t | 0 diff --git a/src/test/regress/sql/constraints.sql b/src/test/regress/sql/constraints.sql index 034ebf38309..e3e3bea7091 100644 --- a/src/test/regress/sql/constraints.sql +++ b/src/test/regress/sql/constraints.sql @@ -462,7 +462,8 @@ CREATE UNIQUE INDEX t_b_idx ON t (b, a); ALTER INDEX t_a_idx ATTACH PARTITION tp_pkey; ALTER INDEX t_b_idx ATTACH PARTITION tp_b_a_key; SELECT conname, conparentid, conislocal, coninhcount - FROM pg_constraint WHERE conname IN ('tp_pkey', 'tp_b_a_key'); + FROM pg_constraint WHERE conname IN ('tp_pkey', 'tp_b_a_key') + ORDER BY conname DESC; ALTER TABLE t DETACH PARTITION tp; DROP TABLE t, tp; |