diff options
| author | Robert Haas <rhaas@postgresql.org> | 2017-08-10 13:44:30 -0400 |
|---|---|---|
| committer | Robert Haas <rhaas@postgresql.org> | 2017-08-10 13:46:56 -0400 |
| commit | bb5d6e80b1387f0de58e55ac8e882f68ec6d4fcf (patch) | |
| tree | 5d6488d2901c72a8a5ad5984294b27691319aee1 /src/test/regress/expected/create_table.out | |
| parent | c1ef4e5cdb11cd562891f4ad2f30d1e3583a973d (diff) | |
| download | postgresql-bb5d6e80b1387f0de58e55ac8e882f68ec6d4fcf.tar.gz | |
Improve the error message when creating an empty range partition.
The previous message didn't mention the name of the table or the
bounds. Put the table name in the primary error message and the
bounds in the detail message.
Amit Langote, changed slightly by me. Suggestions on the exac
phrasing from Tom Lane, David G. Johnston, and Dean Rasheed.
Discussion: http://postgr.es/m/CA+Tgmoae6bpwVa-1BMaVcwvCCeOoJ5B9Q9-RHWo-1gJxfPBZ5Q@mail.gmail.com
Diffstat (limited to 'src/test/regress/expected/create_table.out')
| -rw-r--r-- | src/test/regress/expected/create_table.out | 6 |
1 files changed, 4 insertions, 2 deletions
diff --git a/src/test/regress/expected/create_table.out b/src/test/regress/expected/create_table.out index aa44c11273..babda8978c 100644 --- a/src/test/regress/expected/create_table.out +++ b/src/test/regress/expected/create_table.out @@ -567,10 +567,12 @@ CREATE TABLE range_parted2 ( ) PARTITION BY RANGE (a); -- trying to create range partition with empty range CREATE TABLE fail_part PARTITION OF range_parted2 FOR VALUES FROM (1) TO (0); -ERROR: cannot create range partition with empty range +ERROR: empty range bound specified for partition "fail_part" +DETAIL: Specified lower bound (1) is greater than or equal to upper bound (0). -- note that the range '[1, 1)' has no elements CREATE TABLE fail_part PARTITION OF range_parted2 FOR VALUES FROM (1) TO (1); -ERROR: cannot create range partition with empty range +ERROR: empty range bound specified for partition "fail_part" +DETAIL: Specified lower bound (1) is greater than or equal to upper bound (1). CREATE TABLE part0 PARTITION OF range_parted2 FOR VALUES FROM (minvalue) TO (1); CREATE TABLE fail_part PARTITION OF range_parted2 FOR VALUES FROM (minvalue) TO (2); ERROR: partition "fail_part" would overlap partition "part0" |