From 63676ebff402050f6b0b347188f5e857474da9e1 Mon Sep 17 00:00:00 2001 From: Robert Haas Date: Sun, 26 Dec 2010 21:32:07 -0500 Subject: [PATCH] Corrections to patch adding SQL/MED error codes. My previous commit, 85cff3ce7f360d139d87aee836d75a6202fee066 on 2010-12-25, failed to update errcodes.sgml or plerrcodes.h. This patch corrects that oversight, per a gripe from Tom Lane, and also corrects a typographical error. --- doc/src/sgml/errcodes.sgml | 167 ++++++++++++++++++++++++++++++++ src/include/utils/errcodes.h | 2 +- src/pl/plpgsql/src/plerrcodes.h | 108 +++++++++++++++++++++ 3 files changed, 276 insertions(+), 1 deletion(-) diff --git a/doc/src/sgml/errcodes.sgml b/doc/src/sgml/errcodes.sgml index 3288687172..3a1baf5883 100644 --- a/doc/src/sgml/errcodes.sgml +++ b/doc/src/sgml/errcodes.sgml @@ -1410,6 +1410,173 @@ + +Class HV — Foreign Data Wrapper Error (SQL/MED) + + + +HV000 +FDW ERROR +fdw_error + + + +HV005 +FDW COLUMN NAME NOT FOUND +fdw_column_name_not_found + + + +HV002 +FDW DYNAMIC PARAMETER VALUE NEEDED +fdw_dynamic_parameter_value_needed + + + +HV010 +FDW FUNCTION SEQUENCE ERROR +fdw_function_sequence_error + + + +HV021 +FDW INCONSISTENT DESCRIPTOR INFORMATION +fdw_inconsistent_descriptor_information + + + +HV024 +FDW INVALID ATTRIBUTE VALUE +fdw_invalid_attribute_value + + + +HV007 +FDW INVALID COLUMN NAME +fdw_invalid_column_name + + + +HV008 +FDW INVALID COLUMN NUMBER +fdw_invalid_column_number + + + +HV004 +FDW INVALID DATA TYPE +fdw_invalid_data_type + + + +HV006 +FDW INVALID DATA TYPE DESCRIPTORS +fdw_invalid_data_type_descriptors + + + +HV091 +FDW INVALID DESCRIPTOR FIELD IDENTIFIER +fdw_invalid_descriptor_field_identifier + + + +HV00B +FDW INVALID HANDLE +fdw_invalid_handle + + + +HV00C +FDW INVALID OPTION INDEX +fdw_invalid_option_index + + + +HV00D +FDW INVALID OPTION NAME +fdw_invalid_option_name + + + +HV090 +FDW INVALID STRING LENGTH OR BUFFER LENGTH +fdw_invalid_string_length_or_buffer_length + + + +HV00A +FDW INVALID STRING FORMAT +fdw_invalid_string_format + + + +HV009 +FDW INVALID USE OF NULL POINTER +fdw_invalid_use_of_null_pointer + + + +HV014 +FDW TOO MANY HANDLES +fdw_too_many_handles + + + +HV001 +FDW OUT OF MEMORY +fdw_out_of_memory + + + +HV00P +FDW NO SCHEMAS +fdw_no_schemas + + + +HV00J +FDW OPTION NAME NOT FOUND +fdw_option_name_not_found + + + +HV00K +FDW REPLY HANDLE +fdw_reply_handle + + + +HV00Q +FDW SCHEMA NOT FOUND +fdw_schema_not_found + + + +HV00R +FDW TABLE NOT FOUND +fdw_table_not_found + + + +HV00L +FDW UNABLE TO CREATE EXECUTION +fdw_unable_to_create_execution + + + +HV00M +FDW UNABLE TO CREATE REPLY +fdw_unable_to_create_reply + + + +HV00N +FDW UNABLE TO ESTABLISH CONNECTION +fdw_unable_to_establish_connection + + + Class P0 — PL/pgSQL Error diff --git a/src/include/utils/errcodes.h b/src/include/utils/errcodes.h index 3b332b6e4e..80a4ca1acc 100644 --- a/src/include/utils/errcodes.h +++ b/src/include/utils/errcodes.h @@ -368,7 +368,7 @@ #define ERRCODE_FDW_REPLY_HANDLE MAKE_SQLSTATE('H','V', '0','0','K') #define ERRCODE_FDW_SCHEMA_NOT_FOUND MAKE_SQLSTATE('H','V', '0','0','Q') #define ERRCODE_FDW_TABLE_NOT_FOUND MAKE_SQLSTATE('H','V', '0','0','R') -#define ERRCODE_FDW_UNALBE_TO_CREATE_EXECUTION MAKE_SQLSTATE('H','V', '0','0','L') +#define ERRCODE_FDW_UNABLE_TO_CREATE_EXECUTION MAKE_SQLSTATE('H','V', '0','0','L') #define ERRCODE_FDW_UNABLE_TO_CREATE_REPLY MAKE_SQLSTATE('H','V', '0','0','M') #define ERRCODE_FDW_UNABLE_TO_ESTABLISH_CONNECTION MAKE_SQLSTATE('H','V', '0','0','N') diff --git a/src/pl/plpgsql/src/plerrcodes.h b/src/pl/plpgsql/src/plerrcodes.h index 30465de1fb..1bcc4d6deb 100644 --- a/src/pl/plpgsql/src/plerrcodes.h +++ b/src/pl/plpgsql/src/plerrcodes.h @@ -759,6 +759,114 @@ "plpgsql_error", ERRCODE_PLPGSQL_ERROR }, +{ + "fdw_error", ERRCODE_FDW_ERROR +}, + +{ + "fdw_column_name_not_found", ERRCODE_FDW_COLUMN_NAME_NOT_FOUND +}, + +{ + "fdw_dynamic_parameter_value_needed", ERRCODE_FDW_DYNAMIC_PARAMETER_VALUE_NEEDED +}, + +{ + "fdw_function_sequence_error", ERRCODE_FDW_FUNCTION_SEQUENCE_ERROR +}, + +{ + "fdw_inconsistent_descriptor_information", ERRCODE_FDW_INCONSISTENT_DESCRIPTOR_INFORMATION +}, + +{ + "fdw_invalid_attribute_value", ERRCODE_FDW_INVALID_ATTRIBUTE_VALUE +}, + +{ + "fdw_invalid_column_name", ERRCODE_FDW_INVALID_COLUMN_NAME +}, + +{ + "fdw_invalid_column_number", ERRCODE_FDW_INVALID_COLUMN_NUMBER +}, + +{ + "fdw_invalid_data_type", ERRCODE_FDW_INVALID_DATA_TYPE +}, + +{ + "fdw_invalid_data_type_descriptors", ERRCODE_FDW_INVALID_DATA_TYPE_DESCRIPTORS +}, + +{ + "fdw_invalid_descriptor_field_identifier", ERRCODE_FDW_INVALID_DESCRIPTOR_FIELD_IDENTIFIER +}, + +{ + "fdw_invalid_handle", ERRCODE_FDW_INVALID_HANDLE +}, + +{ + "fdw_invalid_option_index", ERRCODE_FDW_INVALID_OPTION_INDEX +}, + +{ + "fdw_invalid_option_name", ERRCODE_FDW_INVALID_OPTION_NAME +}, + +{ + "fdw_invalid_string_length_or_buffer_length", ERRCODE_FDW_INVALID_STRING_LENGTH_OR_BUFFER_LENGTH +}, + +{ + "fdw_invalid_string_format", ERRCODE_FDW_INVALID_STRING_FORMAT +}, + +{ + "fdw_invalid_use_of_null_pointer", ERRCODE_FDW_INVALID_USE_OF_NULL_POINTER +}, + +{ + "fdw_too_many_handles", ERRCODE_FDW_TOO_MANY_HANDLES +}, + +{ + "fdw_out_of_memory", ERRCODE_FDW_OUT_OF_MEMORY +}, + +{ + "fdw_no_schemas", ERRCODE_FDW_NO_SCHEMAS +}, + +{ + "fdw_option_name_not_found", ERRCODE_FDW_OPTION_NAME_NOT_FOUND +}, + +{ + "fdw_reply_handle", ERRCODE_FDW_REPLY_HANDLE +}, + +{ + "fdw_schema_not_found", ERRCODE_FDW_SCHEMA_NOT_FOUND +}, + +{ + "fdw_table_not_found", ERRCODE_FDW_TABLE_NOT_FOUND +}, + +{ + "fdw_unable_to_create_execution", ERRCODE_FDW_UNABLE_TO_CREATE_EXECUTION +}, + +{ + "fdw_unable_to_create_reply", ERRCODE_FDW_UNABLE_TO_CREATE_REPLY +}, + +{ + "fdw_unable_to_establish_connection", ERRCODE_FDW_UNABLE_TO_ESTABLISH_CONNECTION +}, + { "raise_exception", ERRCODE_RAISE_EXCEPTION }, -- 2.40.0