diff options
author | Michael Paquier <michael@paquier.xyz> | 2023-02-28 08:04:13 +0900 |
---|---|---|
committer | Michael Paquier <michael@paquier.xyz> | 2023-02-28 08:04:13 +0900 |
commit | b8da37b3ada2e547983538b3e49f8079f85ce120 (patch) | |
tree | d3ecf7af84a5b492e7a2b62b79df0398f3c8bccd /src/test/regress/expected/enum.out | |
parent | 728560db7d868b3ded9a8675742083ab89bcff7c (diff) | |
download | postgresql-b8da37b3ada2e547983538b3e49f8079f85ce120.tar.gz |
Rework pg_input_error_message(), now renamed pg_input_error_info()
pg_input_error_info() is now a SQL function able to return a row with
more than just the error message generated for incorrect data type
inputs when these are able to handle soft failures, returning more
contents of ErrorData, as of:
- The error message (same as before).
- The error detail, if set.
- The error hint, if set.
- SQL error code.
All the regression tests that relied on pg_input_error_message() are
updated to reflect the effects of the rename.
Per discussion with Tom Lane and Andrew Dunstan.
Author: Nathan Bossart
Discussion: https://postgr.es/m/139a68e1-bd1f-a9a7-b5fe-0be9845c6311@dunslane.net
Diffstat (limited to 'src/test/regress/expected/enum.out')
-rw-r--r-- | src/test/regress/expected/enum.out | 21 |
1 files changed, 12 insertions, 9 deletions
diff --git a/src/test/regress/expected/enum.out b/src/test/regress/expected/enum.out index 4b45fcf8f0..01159688e5 100644 --- a/src/test/regress/expected/enum.out +++ b/src/test/regress/expected/enum.out @@ -37,18 +37,21 @@ SELECT pg_input_is_valid('mauve', 'rainbow'); f (1 row) -SELECT pg_input_error_message('mauve', 'rainbow'); - pg_input_error_message ------------------------------------------------ - invalid input value for enum rainbow: "mauve" +SELECT * FROM pg_input_error_info('mauve', 'rainbow'); + message | detail | hint | sql_error_code +-----------------------------------------------+--------+------+---------------- + invalid input value for enum rainbow: "mauve" | | | 22P02 (1 row) -SELECT pg_input_error_message(repeat('too_long', 32), 'rainbow'); - pg_input_error_message ----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- - invalid input value for enum rainbow: "too_longtoo_longtoo_longtoo_longtoo_longtoo_longtoo_longtoo_longtoo_longtoo_longtoo_longtoo_longtoo_longtoo_longtoo_longtoo_longtoo_longtoo_longtoo_longtoo_longtoo_longtoo_longtoo_longtoo_longtoo_longtoo_longtoo_longtoo_longtoo_longtoo_longtoo_longtoo_long" -(1 row) +\x +SELECT * FROM pg_input_error_info(repeat('too_long', 32), 'rainbow'); +-[ RECORD 1 ]--+--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- +message | invalid input value for enum rainbow: "too_longtoo_longtoo_longtoo_longtoo_longtoo_longtoo_longtoo_longtoo_longtoo_longtoo_longtoo_longtoo_longtoo_longtoo_longtoo_longtoo_longtoo_longtoo_longtoo_longtoo_longtoo_longtoo_longtoo_longtoo_longtoo_longtoo_longtoo_longtoo_longtoo_longtoo_longtoo_long" +detail | +hint | +sql_error_code | 22P02 +\x -- -- adding new values -- |