diff options
| author | Tom Lane <tgl@sss.pgh.pa.us> | 2020-09-28 14:48:01 -0400 |
|---|---|---|
| committer | Tom Lane <tgl@sss.pgh.pa.us> | 2020-09-28 14:48:01 -0400 |
| commit | 042d8017ec7bca244db4a53bc3d72d218495136d (patch) | |
| tree | be709ad37a991ccbf4b40f6efe57e9b45bcc586c /src | |
| parent | 72647ac3bf0f11732483eac2cd9b5cf4972f2e1f (diff) | |
| download | postgresql-042d8017ec7bca244db4a53bc3d72d218495136d.tar.gz postgresql-042d8017ec7bca244db4a53bc3d72d218495136d.zip | |
Stabilize create_table regression test.
Adding \d+ to the test in commit 2dfa3fea8 was ill-advised,
because the partitions' names are such that their sort order
is locale dependent. We could rename them to avoid that,
but it doesn't seem worth the trouble; just take \d+ out again.
Per buildfarm.
Diffstat (limited to 'src')
| -rw-r--r-- | src/test/regress/expected/create_table.out | 11 | ||||
| -rw-r--r-- | src/test/regress/sql/create_table.sql | 2 |
2 files changed, 0 insertions, 13 deletions
diff --git a/src/test/regress/expected/create_table.out b/src/test/regress/expected/create_table.out index 45f4a734478..1fc266dd65c 100644 --- a/src/test/regress/expected/create_table.out +++ b/src/test/regress/expected/create_table.out @@ -1042,17 +1042,6 @@ create table test_part_coll2 partition of test_part_coll_posix for values from ( create table test_part_coll_cast partition of test_part_coll_posix for values from (name 'm' collate "C") to ('s'); -- ok; partition collation silently overrides the default collation of type 'name' create table test_part_coll_cast2 partition of test_part_coll_posix for values from (name 's') to ('z'); -\d+ test_part_coll_posix - Partitioned table "public.test_part_coll_posix" - Column | Type | Collation | Nullable | Default | Storage | Stats target | Description ---------+------+-----------+----------+---------+----------+--------------+------------- - a | text | | | | extended | | -Partition key: RANGE (a COLLATE "POSIX") -Partitions: test_part_coll FOR VALUES FROM ('a') TO ('g'), - test_part_coll2 FOR VALUES FROM ('g') TO ('m'), - test_part_coll_cast FOR VALUES FROM ('m') TO ('s'), - test_part_coll_cast2 FOR VALUES FROM ('s') TO ('z') - drop table test_part_coll_posix; -- Partition bound in describe output \d+ part_b diff --git a/src/test/regress/sql/create_table.sql b/src/test/regress/sql/create_table.sql index 22602aae5d2..cee822aa8b6 100644 --- a/src/test/regress/sql/create_table.sql +++ b/src/test/regress/sql/create_table.sql @@ -833,8 +833,6 @@ create table test_part_coll_cast partition of test_part_coll_posix for values fr -- ok; partition collation silently overrides the default collation of type 'name' create table test_part_coll_cast2 partition of test_part_coll_posix for values from (name 's') to ('z'); -\d+ test_part_coll_posix - drop table test_part_coll_posix; -- Partition bound in describe output |