Skip to content

Commit 63676eb

Browse files
robertmhaasrobertmhaas
committed
Corrections to patch adding SQL/MED error codes.
My previous commit, 85cff3c 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.
1 parent a534728 commit 63676eb

File tree

3 files changed

+276
-1
lines changed

3 files changed

+276
-1
lines changed

‎doc/src/sgml/errcodes.sgml

Lines changed: 167 additions & 0 deletions
Original file line numberDiff line numberDiff line change
@@ -1410,6 +1410,173 @@
14101410
</row>
14111411

14121412

1413+
<row>
1414+
<entry spanname="span13"><emphasis role="bold">Class HV &mdash; Foreign Data Wrapper Error (SQL/MED)</></entry>
1415+
</row>
1416+
1417+
<row>
1418+
<entry><literal>HV000</literal></entry>
1419+
<entry>FDW ERROR</entry>
1420+
<entry>fdw_error</entry>
1421+
</row>
1422+
1423+
<row>
1424+
<entry><literal>HV005</literal></entry>
1425+
<entry>FDW COLUMN NAME NOT FOUND</entry>
1426+
<entry>fdw_column_name_not_found</entry>
1427+
</row>
1428+
1429+
<row>
1430+
<entry><literal>HV002</literal></entry>
1431+
<entry>FDW DYNAMIC PARAMETER VALUE NEEDED</entry>
1432+
<entry>fdw_dynamic_parameter_value_needed</entry>
1433+
</row>
1434+
1435+
<row>
1436+
<entry><literal>HV010</literal></entry>
1437+
<entry>FDW FUNCTION SEQUENCE ERROR</entry>
1438+
<entry>fdw_function_sequence_error</entry>
1439+
</row>
1440+
1441+
<row>
1442+
<entry><literal>HV021</literal></entry>
1443+
<entry>FDW INCONSISTENT DESCRIPTOR INFORMATION</entry>
1444+
<entry>fdw_inconsistent_descriptor_information</entry>
1445+
</row>
1446+
1447+
<row>
1448+
<entry><literal>HV024</literal></entry>
1449+
<entry>FDW INVALID ATTRIBUTE VALUE</entry>
1450+
<entry>fdw_invalid_attribute_value</entry>
1451+
</row>
1452+
1453+
<row>
1454+
<entry><literal>HV007</literal></entry>
1455+
<entry>FDW INVALID COLUMN NAME</entry>
1456+
<entry>fdw_invalid_column_name</entry>
1457+
</row>
1458+
1459+
<row>
1460+
<entry><literal>HV008</literal></entry>
1461+
<entry>FDW INVALID COLUMN NUMBER</entry>
1462+
<entry>fdw_invalid_column_number</entry>
1463+
</row>
1464+
1465+
<row>
1466+
<entry><literal>HV004</literal></entry>
1467+
<entry>FDW INVALID DATA TYPE</entry>
1468+
<entry>fdw_invalid_data_type</entry>
1469+
</row>
1470+
1471+
<row>
1472+
<entry><literal>HV006</literal></entry>
1473+
<entry>FDW INVALID DATA TYPE DESCRIPTORS</entry>
1474+
<entry>fdw_invalid_data_type_descriptors</entry>
1475+
</row>
1476+
1477+
<row>
1478+
<entry><literal>HV091</literal></entry>
1479+
<entry>FDW INVALID DESCRIPTOR FIELD IDENTIFIER</entry>
1480+
<entry>fdw_invalid_descriptor_field_identifier</entry>
1481+
</row>
1482+
1483+
<row>
1484+
<entry><literal>HV00B</literal></entry>
1485+
<entry>FDW INVALID HANDLE</entry>
1486+
<entry>fdw_invalid_handle</entry>
1487+
</row>
1488+
1489+
<row>
1490+
<entry><literal>HV00C</literal></entry>
1491+
<entry>FDW INVALID OPTION INDEX</entry>
1492+
<entry>fdw_invalid_option_index</entry>
1493+
</row>
1494+
1495+
<row>
1496+
<entry><literal>HV00D</literal></entry>
1497+
<entry>FDW INVALID OPTION NAME</entry>
1498+
<entry>fdw_invalid_option_name</entry>
1499+
</row>
1500+
1501+
<row>
1502+
<entry><literal>HV090</literal></entry>
1503+
<entry>FDW INVALID STRING LENGTH OR BUFFER LENGTH</entry>
1504+
<entry>fdw_invalid_string_length_or_buffer_length</entry>
1505+
</row>
1506+
1507+
<row>
1508+
<entry><literal>HV00A</literal></entry>
1509+
<entry>FDW INVALID STRING FORMAT</entry>
1510+
<entry>fdw_invalid_string_format</entry>
1511+
</row>
1512+
1513+
<row>
1514+
<entry><literal>HV009</literal></entry>
1515+
<entry>FDW INVALID USE OF NULL POINTER</entry>
1516+
<entry>fdw_invalid_use_of_null_pointer</entry>
1517+
</row>
1518+
1519+
<row>
1520+
<entry><literal>HV014</literal></entry>
1521+
<entry>FDW TOO MANY HANDLES</entry>
1522+
<entry>fdw_too_many_handles</entry>
1523+
</row>
1524+
1525+
<row>
1526+
<entry><literal>HV001</literal></entry>
1527+
<entry>FDW OUT OF MEMORY</entry>
1528+
<entry>fdw_out_of_memory</entry>
1529+
</row>
1530+
1531+
<row>
1532+
<entry><literal>HV00P</literal></entry>
1533+
<entry>FDW NO SCHEMAS</entry>
1534+
<entry>fdw_no_schemas</entry>
1535+
</row>
1536+
1537+
<row>
1538+
<entry><literal>HV00J</literal></entry>
1539+
<entry>FDW OPTION NAME NOT FOUND</entry>
1540+
<entry>fdw_option_name_not_found</entry>
1541+
</row>
1542+
1543+
<row>
1544+
<entry><literal>HV00K</literal></entry>
1545+
<entry>FDW REPLY HANDLE</entry>
1546+
<entry>fdw_reply_handle</entry>
1547+
</row>
1548+
1549+
<row>
1550+
<entry><literal>HV00Q</literal></entry>
1551+
<entry>FDW SCHEMA NOT FOUND</entry>
1552+
<entry>fdw_schema_not_found</entry>
1553+
</row>
1554+
1555+
<row>
1556+
<entry><literal>HV00R</literal></entry>
1557+
<entry>FDW TABLE NOT FOUND</entry>
1558+
<entry>fdw_table_not_found</entry>
1559+
</row>
1560+
1561+
<row>
1562+
<entry><literal>HV00L</literal></entry>
1563+
<entry>FDW UNABLE TO CREATE EXECUTION</entry>
1564+
<entry>fdw_unable_to_create_execution</entry>
1565+
</row>
1566+
1567+
<row>
1568+
<entry><literal>HV00M</literal></entry>
1569+
<entry>FDW UNABLE TO CREATE REPLY</entry>
1570+
<entry>fdw_unable_to_create_reply</entry>
1571+
</row>
1572+
1573+
<row>
1574+
<entry><literal>HV00N</literal></entry>
1575+
<entry>FDW UNABLE TO ESTABLISH CONNECTION</entry>
1576+
<entry>fdw_unable_to_establish_connection</entry>
1577+
</row>
1578+
1579+
14131580
<row>
14141581
<entry spanname="span13"><emphasis role="bold">Class P0 &mdash; PL/pgSQL Error</></entry>
14151582
</row>

‎src/include/utils/errcodes.h

Lines changed: 1 addition & 1 deletion
Original file line numberDiff line numberDiff line change
@@ -368,7 +368,7 @@
368368
#define ERRCODE_FDW_REPLY_HANDLE MAKE_SQLSTATE('H','V', '0','0','K')
369369
#define ERRCODE_FDW_SCHEMA_NOT_FOUND MAKE_SQLSTATE('H','V', '0','0','Q')
370370
#define ERRCODE_FDW_TABLE_NOT_FOUND MAKE_SQLSTATE('H','V', '0','0','R')
371-
#define ERRCODE_FDW_UNALBE_TO_CREATE_EXECUTION MAKE_SQLSTATE('H','V', '0','0','L')
371+
#define ERRCODE_FDW_UNABLE_TO_CREATE_EXECUTION MAKE_SQLSTATE('H','V', '0','0','L')
372372
#define ERRCODE_FDW_UNABLE_TO_CREATE_REPLY MAKE_SQLSTATE('H','V', '0','0','M')
373373
#define ERRCODE_FDW_UNABLE_TO_ESTABLISH_CONNECTION MAKE_SQLSTATE('H','V', '0','0','N')
374374

‎src/pl/plpgsql/src/plerrcodes.h

Lines changed: 108 additions & 0 deletions
Original file line numberDiff line numberDiff line change
@@ -759,6 +759,114 @@
759759
"plpgsql_error", ERRCODE_PLPGSQL_ERROR
760760
},
761761

762+
{
763+
"fdw_error", ERRCODE_FDW_ERROR
764+
},
765+
766+
{
767+
"fdw_column_name_not_found", ERRCODE_FDW_COLUMN_NAME_NOT_FOUND
768+
},
769+
770+
{
771+
"fdw_dynamic_parameter_value_needed", ERRCODE_FDW_DYNAMIC_PARAMETER_VALUE_NEEDED
772+
},
773+
774+
{
775+
"fdw_function_sequence_error", ERRCODE_FDW_FUNCTION_SEQUENCE_ERROR
776+
},
777+
778+
{
779+
"fdw_inconsistent_descriptor_information", ERRCODE_FDW_INCONSISTENT_DESCRIPTOR_INFORMATION
780+
},
781+
782+
{
783+
"fdw_invalid_attribute_value", ERRCODE_FDW_INVALID_ATTRIBUTE_VALUE
784+
},
785+
786+
{
787+
"fdw_invalid_column_name", ERRCODE_FDW_INVALID_COLUMN_NAME
788+
},
789+
790+
{
791+
"fdw_invalid_column_number", ERRCODE_FDW_INVALID_COLUMN_NUMBER
792+
},
793+
794+
{
795+
"fdw_invalid_data_type", ERRCODE_FDW_INVALID_DATA_TYPE
796+
},
797+
798+
{
799+
"fdw_invalid_data_type_descriptors", ERRCODE_FDW_INVALID_DATA_TYPE_DESCRIPTORS
800+
},
801+
802+
{
803+
"fdw_invalid_descriptor_field_identifier", ERRCODE_FDW_INVALID_DESCRIPTOR_FIELD_IDENTIFIER
804+
},
805+
806+
{
807+
"fdw_invalid_handle", ERRCODE_FDW_INVALID_HANDLE
808+
},
809+
810+
{
811+
"fdw_invalid_option_index", ERRCODE_FDW_INVALID_OPTION_INDEX
812+
},
813+
814+
{
815+
"fdw_invalid_option_name", ERRCODE_FDW_INVALID_OPTION_NAME
816+
},
817+
818+
{
819+
"fdw_invalid_string_length_or_buffer_length", ERRCODE_FDW_INVALID_STRING_LENGTH_OR_BUFFER_LENGTH
820+
},
821+
822+
{
823+
"fdw_invalid_string_format", ERRCODE_FDW_INVALID_STRING_FORMAT
824+
},
825+
826+
{
827+
"fdw_invalid_use_of_null_pointer", ERRCODE_FDW_INVALID_USE_OF_NULL_POINTER
828+
},
829+
830+
{
831+
"fdw_too_many_handles", ERRCODE_FDW_TOO_MANY_HANDLES
832+
},
833+
834+
{
835+
"fdw_out_of_memory", ERRCODE_FDW_OUT_OF_MEMORY
836+
},
837+
838+
{
839+
"fdw_no_schemas", ERRCODE_FDW_NO_SCHEMAS
840+
},
841+
842+
{
843+
"fdw_option_name_not_found", ERRCODE_FDW_OPTION_NAME_NOT_FOUND
844+
},
845+
846+
{
847+
"fdw_reply_handle", ERRCODE_FDW_REPLY_HANDLE
848+
},
849+
850+
{
851+
"fdw_schema_not_found", ERRCODE_FDW_SCHEMA_NOT_FOUND
852+
},
853+
854+
{
855+
"fdw_table_not_found", ERRCODE_FDW_TABLE_NOT_FOUND
856+
},
857+
858+
{
859+
"fdw_unable_to_create_execution", ERRCODE_FDW_UNABLE_TO_CREATE_EXECUTION
860+
},
861+
862+
{
863+
"fdw_unable_to_create_reply", ERRCODE_FDW_UNABLE_TO_CREATE_REPLY
864+
},
865+
866+
{
867+
"fdw_unable_to_establish_connection", ERRCODE_FDW_UNABLE_TO_ESTABLISH_CONNECTION
868+
},
869+
762870
{
763871
"raise_exception", ERRCODE_RAISE_EXCEPTION
764872
},

0 commit comments

Comments
 (0)