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 | 067cb6c5da6cfe60618c2951b061137233680c20 (patch) | |
| tree | 7dfbf8c7f51d188fadb1c3e0301adc2e8a2ac3ed /src | |
| parent | d0054432d480e958e4650c4b56de4a4a6e05da78 (diff) | |
| download | postgresql-067cb6c5da6cfe60618c2951b061137233680c20.tar.gz postgresql-067cb6c5da6cfe60618c2951b061137233680c20.zip | |
Add ORDER BY to new test query
Per buildfarm.
Diffstat (limited to 'src')
| -rw-r--r-- | src/test/regress/input/constraints.source | 3 | ||||
| -rw-r--r-- | src/test/regress/output/constraints.source | 3 |
2 files changed, 4 insertions, 2 deletions
diff --git a/src/test/regress/input/constraints.source b/src/test/regress/input/constraints.source index 47f2bfa0b4f..05185c00afb 100644 --- a/src/test/regress/input/constraints.source +++ b/src/test/regress/input/constraints.source @@ -443,7 +443,8 @@ ALTER INDEX t_a_idx ATTACH PARTITION tp_pkey; ALTER INDEX t_b_idx ATTACH PARTITION tp_b_a_key; ALTER TABLE t DETACH PARTITION tp; 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; DROP TABLE t, tp; CREATE TEMP TABLE t (a integer) PARTITION BY LIST (a); diff --git a/src/test/regress/output/constraints.source b/src/test/regress/output/constraints.source index 2b4a06f8160..eb4fcbe4dda 100644 --- a/src/test/regress/output/constraints.source +++ b/src/test/regress/output/constraints.source @@ -612,7 +612,8 @@ ALTER INDEX t_a_idx ATTACH PARTITION tp_pkey; ALTER INDEX t_b_idx ATTACH PARTITION tp_b_a_key; ALTER TABLE t DETACH PARTITION tp; 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 |