From ddfe26f6441c24660595c5efe5fd0bd3974cdc5c Mon Sep 17 00:00:00 2001 From: Robert Haas Date: Thu, 3 Feb 2011 22:32:49 -0500 Subject: Avoid maintaining three separate copies of the error codes list. MIME-Version: 1.0 Content-Type: text/plain; charset=UTF-8 Content-Transfer-Encoding: 8bit src/pl/plpgsql/src/plerrcodes.h, src/include/utils/errcodes.h, and a big chunk of errcodes.sgml are now automatically generated from a single file, src/backend/utils/errcodes.txt. Jan Urbański, reviewed by Tom Lane. --- doc/src/sgml/.gitignore | 1 + doc/src/sgml/Makefile | 4 +- doc/src/sgml/errcodes.sgml | 1559 +------------------------------ doc/src/sgml/filelist.sgml | 2 + doc/src/sgml/generate-errcodes-table.pl | 63 ++ 5 files changed, 70 insertions(+), 1559 deletions(-) create mode 100644 doc/src/sgml/generate-errcodes-table.pl (limited to 'doc/src') diff --git a/doc/src/sgml/.gitignore b/doc/src/sgml/.gitignore index 62a38d2183d..e1b84b490fe 100644 --- a/doc/src/sgml/.gitignore +++ b/doc/src/sgml/.gitignore @@ -16,6 +16,7 @@ # GENERATED_SGML /features-supported.sgml /features-unsupported.sgml +/errcodes-table.sgml /version.sgml /bookindex.sgml /HTML.index diff --git a/doc/src/sgml/Makefile b/doc/src/sgml/Makefile index a797499c792..add2c282c6b 100644 --- a/doc/src/sgml/Makefile +++ b/doc/src/sgml/Makefile @@ -52,7 +52,7 @@ override XSLTPROCFLAGS += --stringparam pg.version '$(VERSION)' GENERATED_SGML = bookindex.sgml version.sgml \ - features-supported.sgml features-unsupported.sgml + features-supported.sgml features-unsupported.sgml errcodes-table.sgml ALLSGML := $(wildcard $(srcdir)/*.sgml $(srcdir)/ref/*.sgml) $(GENERATED_SGML) @@ -136,6 +136,8 @@ features-supported.sgml: $(top_srcdir)/src/backend/catalog/sql_feature_packages. features-unsupported.sgml: $(top_srcdir)/src/backend/catalog/sql_feature_packages.txt $(top_srcdir)/src/backend/catalog/sql_features.txt $(PERL) $(srcdir)/mk_feature_tables.pl NO $^ > $@ +errcodes-table.sgml: $(top_srcdir)/src/backend/utils/errcodes.txt generate-errcodes-table.pl + $(PERL) $(srcdir)/generate-errcodes-table.pl $< > $@ ## ## Print diff --git a/doc/src/sgml/errcodes.sgml b/doc/src/sgml/errcodes.sgml index c05b4caf268..024ec71727e 100644 --- a/doc/src/sgml/errcodes.sgml +++ b/doc/src/sgml/errcodes.sgml @@ -75,1564 +75,7 @@ - -Class 00 — Successful Completion - - - -00000 -SUCCESSFUL COMPLETION -successful_completion - - - - -Class 01 — Warning - - - -01000 -WARNING -warning - - - -0100C -DYNAMIC RESULT SETS RETURNED -dynamic_result_sets_returned - - - -01008 -IMPLICIT ZERO BIT PADDING -implicit_zero_bit_padding - - - -01003 -NULL VALUE ELIMINATED IN SET FUNCTION -null_value_eliminated_in_set_function - - - -01007 -PRIVILEGE NOT GRANTED -privilege_not_granted - - - -01006 -PRIVILEGE NOT REVOKED -privilege_not_revoked - - - -01004 -STRING DATA RIGHT TRUNCATION -string_data_right_truncation - - - -01P01 -DEPRECATED FEATURE -deprecated_feature - - - - -Class 02 — No Data (this is also a warning class per the SQL standard) - - - -02000 -NO DATA -no_data - - - -02001 -NO ADDITIONAL DYNAMIC RESULT SETS RETURNED -no_additional_dynamic_result_sets_returned - - - - -Class 03 — SQL Statement Not Yet Complete - - - -03000 -SQL STATEMENT NOT YET COMPLETE -sql_statement_not_yet_complete - - - - -Class 08 — Connection Exception - - - -08000 -CONNECTION EXCEPTION -connection_exception - - - -08003 -CONNECTION DOES NOT EXIST -connection_does_not_exist - - - -08006 -CONNECTION FAILURE -connection_failure - - - -08001 -SQLCLIENT UNABLE TO ESTABLISH SQLCONNECTION -sqlclient_unable_to_establish_sqlconnection - - - -08004 -SQLSERVER REJECTED ESTABLISHMENT OF SQLCONNECTION -sqlserver_rejected_establishment_of_sqlconnection - - - -08007 -TRANSACTION RESOLUTION UNKNOWN -transaction_resolution_unknown - - - -08P01 -PROTOCOL VIOLATION -protocol_violation - - - - -Class 09 — Triggered Action Exception - - - -09000 -TRIGGERED ACTION EXCEPTION -triggered_action_exception - - - - -Class 0A — Feature Not Supported - - - -0A000 -FEATURE NOT SUPPORTED -feature_not_supported - - - - -Class 0B — Invalid Transaction Initiation - - - -0B000 -INVALID TRANSACTION INITIATION -invalid_transaction_initiation - - - - -Class 0F — Locator Exception - - - -0F000 -LOCATOR EXCEPTION -locator_exception - - - -0F001 -INVALID LOCATOR SPECIFICATION -invalid_locator_specification - - - - -Class 0L — Invalid Grantor - - - -0L000 -INVALID GRANTOR -invalid_grantor - - - -0LP01 -INVALID GRANT OPERATION -invalid_grant_operation - - - - -Class 0P — Invalid Role Specification - - - -0P000 -INVALID ROLE SPECIFICATION -invalid_role_specification - - - - -Class 20 — Case Not Found - - - -20000 -CASE NOT FOUND -case_not_found - - - - -Class 21 — Cardinality Violation - - - -21000 -CARDINALITY VIOLATION -cardinality_violation - - - - -Class 22 — Data Exception - - - -22000 -DATA EXCEPTION -data_exception - - - -2202E -ARRAY SUBSCRIPT ERROR -array_subscript_error - - - -22021 -CHARACTER NOT IN REPERTOIRE -character_not_in_repertoire - - - -22008 -DATETIME FIELD OVERFLOW -datetime_field_overflow - - - -22012 -DIVISION BY ZERO -division_by_zero - - - -22005 -ERROR IN ASSIGNMENT -error_in_assignment - - - -2200B -ESCAPE CHARACTER CONFLICT -escape_character_conflict - - - -22022 -INDICATOR OVERFLOW -indicator_overflow - - - -22015 -INTERVAL FIELD OVERFLOW -interval_field_overflow - - - -2201E -INVALID ARGUMENT FOR LOGARITHM -invalid_argument_for_logarithm - - - -22014 -INVALID ARGUMENT FOR NTILE FUNCTION -invalid_argument_for_ntile_function - - - -22016 -INVALID ARGUMENT FOR NTH_VALUE FUNCTION -invalid_argument_for_nth_value_function - - - -2201F -INVALID ARGUMENT FOR POWER FUNCTION -invalid_argument_for_power_function - - - -2201G -INVALID ARGUMENT FOR WIDTH BUCKET FUNCTION -invalid_argument_for_width_bucket_function - - - -22018 -INVALID CHARACTER VALUE FOR CAST -invalid_character_value_for_cast - - - -22007 -INVALID DATETIME FORMAT -invalid_datetime_format - - - -22019 -INVALID ESCAPE CHARACTER -invalid_escape_character - - - -2200D -INVALID ESCAPE OCTET -invalid_escape_octet - - - -22025 -INVALID ESCAPE SEQUENCE -invalid_escape_sequence - - - -22P06 -NONSTANDARD USE OF ESCAPE CHARACTER -nonstandard_use_of_escape_character - - - -22010 -INVALID INDICATOR PARAMETER VALUE -invalid_indicator_parameter_value - - - -22023 -INVALID PARAMETER VALUE -invalid_parameter_value - - - -2201B -INVALID REGULAR EXPRESSION -invalid_regular_expression - - - -2201W -INVALID ROW COUNT IN LIMIT CLAUSE -invalid_row_count_in_limit_clause - - - -2201X -INVALID ROW COUNT IN RESULT OFFSET CLAUSE -invalid_row_count_in_result_offset_clause - - - -22009 -INVALID TIME ZONE DISPLACEMENT VALUE -invalid_time_zone_displacement_value - - - -2200C -INVALID USE OF ESCAPE CHARACTER -invalid_use_of_escape_character - - - -2200G -MOST SPECIFIC TYPE MISMATCH -most_specific_type_mismatch - - - -22004 -NULL VALUE NOT ALLOWED -null_value_not_allowed - - - -22002 -NULL VALUE NO INDICATOR PARAMETER -null_value_no_indicator_parameter - - - -22003 -NUMERIC VALUE OUT OF RANGE -numeric_value_out_of_range - - - -22026 -STRING DATA LENGTH MISMATCH -string_data_length_mismatch - - - -22001 -STRING DATA RIGHT TRUNCATION -string_data_right_truncation - - - -22011 -SUBSTRING ERROR -substring_error - - - -22027 -TRIM ERROR -trim_error - - - -22024 -UNTERMINATED C STRING -unterminated_c_string - - - -2200F -ZERO LENGTH CHARACTER STRING -zero_length_character_string - - - -22P01 -FLOATING POINT EXCEPTION -floating_point_exception - - - -22P02 -INVALID TEXT REPRESENTATION -invalid_text_representation - - - -22P03 -INVALID BINARY REPRESENTATION -invalid_binary_representation - - - -22P04 -BAD COPY FILE FORMAT -bad_copy_file_format - - - -22P05 -UNTRANSLATABLE CHARACTER -untranslatable_character - - - -2200L -NOT AN XML DOCUMENT -not_an_xml_document - - - -2200M -INVALID XML DOCUMENT -invalid_xml_document - - - -2200N -INVALID XML CONTENT -invalid_xml_content - - - -2200S -INVALID XML COMMENT -invalid_xml_comment - - - -2200T -INVALID XML PROCESSING INSTRUCTION -invalid_xml_processing_instruction - - - -Class 23 — Integrity Constraint Violation - - - -23000 -INTEGRITY CONSTRAINT VIOLATION -integrity_constraint_violation - - - -23001 -RESTRICT VIOLATION -restrict_violation - - - -23502 -NOT NULL VIOLATION -not_null_violation - - - -23503 -FOREIGN KEY VIOLATION -foreign_key_violation - - - -23505 -UNIQUE VIOLATION -unique_violation - - - -23514 -CHECK VIOLATION -check_violation - - - -23P01 -EXCLUSION VIOLATION -exclusion_violation - - - - -Class 24 — Invalid Cursor State - - - -24000 -INVALID CURSOR STATE -invalid_cursor_state - - - - -Class 25 — Invalid Transaction State - - - -25000 -INVALID TRANSACTION STATE -invalid_transaction_state - - - -25001 -ACTIVE SQL TRANSACTION -active_sql_transaction - - - -25002 -BRANCH TRANSACTION ALREADY ACTIVE -branch_transaction_already_active - - - -25008 -HELD CURSOR REQUIRES SAME ISOLATION LEVEL -held_cursor_requires_same_isolation_level - - - -25003 -INAPPROPRIATE ACCESS MODE FOR BRANCH TRANSACTION -inappropriate_access_mode_for_branch_transaction - - - -25004 -INAPPROPRIATE ISOLATION LEVEL FOR BRANCH TRANSACTION -inappropriate_isolation_level_for_branch_transaction - - - -25005 -NO ACTIVE SQL TRANSACTION FOR BRANCH TRANSACTION -no_active_sql_transaction_for_branch_transaction - - - -25006 -READ ONLY SQL TRANSACTION -read_only_sql_transaction - - - -25007 -SCHEMA AND DATA STATEMENT MIXING NOT SUPPORTED -schema_and_data_statement_mixing_not_supported - - - -25P01 -NO ACTIVE SQL TRANSACTION -no_active_sql_transaction - - - -25P02 -IN FAILED SQL TRANSACTION -in_failed_sql_transaction - - - - -Class 26 — Invalid SQL Statement Name - - - -26000 -INVALID SQL STATEMENT NAME -invalid_sql_statement_name - - - - -Class 27 — Triggered Data Change Violation - - - -27000 -TRIGGERED DATA CHANGE VIOLATION -triggered_data_change_violation - - - - -Class 28 — Invalid Authorization Specification - - - -28000 -INVALID AUTHORIZATION SPECIFICATION -invalid_authorization_specification - - - -28P01 -INVALID PASSWORD -invalid_password - - - - -Class 2B — Dependent Privilege Descriptors Still Exist - - - -2B000 -DEPENDENT PRIVILEGE DESCRIPTORS STILL EXIST -dependent_privilege_descriptors_still_exist - - - -2BP01 -DEPENDENT OBJECTS STILL EXIST -dependent_objects_still_exist - - - - -Class 2D — Invalid Transaction Termination - - - -2D000 -INVALID TRANSACTION TERMINATION -invalid_transaction_termination - - - - -Class 2F — SQL Routine Exception - - - -2F000 -SQL ROUTINE EXCEPTION -sql_routine_exception - - - -2F005 -FUNCTION EXECUTED NO RETURN STATEMENT -function_executed_no_return_statement - - - -2F002 -MODIFYING SQL DATA NOT PERMITTED -modifying_sql_data_not_permitted - - - -2F003 -PROHIBITED SQL STATEMENT ATTEMPTED -prohibited_sql_statement_attempted - - - -2F004 -READING SQL DATA NOT PERMITTED -reading_sql_data_not_permitted - - - - -Class 34 — Invalid Cursor Name - - - -34000 -INVALID CURSOR NAME -invalid_cursor_name - - - - -Class 38 — External Routine Exception - - - -38000 -EXTERNAL ROUTINE EXCEPTION -external_routine_exception - - - -38001 -CONTAINING SQL NOT PERMITTED -containing_sql_not_permitted - - - -38002 -MODIFYING SQL DATA NOT PERMITTED -modifying_sql_data_not_permitted - - - -38003 -PROHIBITED SQL STATEMENT ATTEMPTED -prohibited_sql_statement_attempted - - - -38004 -READING SQL DATA NOT PERMITTED -reading_sql_data_not_permitted - - - - -Class 39 — External Routine Invocation Exception - - - -39000 -EXTERNAL ROUTINE INVOCATION EXCEPTION -external_routine_invocation_exception - - - -39001 -INVALID SQLSTATE RETURNED -invalid_sqlstate_returned - - - -39004 -NULL VALUE NOT ALLOWED -null_value_not_allowed - - - -39P01 -TRIGGER PROTOCOL VIOLATED -trigger_protocol_violated - - - -39P02 -SRF PROTOCOL VIOLATED -srf_protocol_violated - - - - -Class 3B — Savepoint Exception - - - -3B000 -SAVEPOINT EXCEPTION -savepoint_exception - - - -3B001 -INVALID SAVEPOINT SPECIFICATION -invalid_savepoint_specification - - - - -Class 3D — Invalid Catalog Name - - - -3D000 -INVALID CATALOG NAME -invalid_catalog_name - - - - -Class 3F — Invalid Schema Name - - - -3F000 -INVALID SCHEMA NAME -invalid_schema_name - - - - -Class 40 — Transaction Rollback - - - -40000 -TRANSACTION ROLLBACK -transaction_rollback - - - -40002 -TRANSACTION INTEGRITY CONSTRAINT VIOLATION -transaction_integrity_constraint_violation - - - -40001 -SERIALIZATION FAILURE -serialization_failure - - - -40003 -STATEMENT COMPLETION UNKNOWN -statement_completion_unknown - - - -40P01 -DEADLOCK DETECTED -deadlock_detected - - - - -Class 42 — Syntax Error or Access Rule Violation - - - -42000 -SYNTAX ERROR OR ACCESS RULE VIOLATION -syntax_error_or_access_rule_violation - - - -42601 -SYNTAX ERROR -syntax_error - - - -42501 -INSUFFICIENT PRIVILEGE -insufficient_privilege - - - -42846 -CANNOT COERCE -cannot_coerce - - - -42803 -GROUPING ERROR -grouping_error - - - -42P20 -WINDOWING ERROR -windowing_error - - - -42P19 -INVALID RECURSION -invalid_recursion - - - -42830 -INVALID FOREIGN KEY -invalid_foreign_key - - - -42602 -INVALID NAME -invalid_name - - - -42622 -NAME TOO LONG -name_too_long - - - -42939 -RESERVED NAME -reserved_name - - - -42804 -DATATYPE MISMATCH -datatype_mismatch - - - -42P18 -INDETERMINATE DATATYPE -indeterminate_datatype - - - -42809 -WRONG OBJECT TYPE -wrong_object_type - - - -42703 -UNDEFINED COLUMN -undefined_column - - - -42883 -UNDEFINED FUNCTION -undefined_function - - - -42P01 -UNDEFINED TABLE -undefined_table - - - -42P02 -UNDEFINED PARAMETER -undefined_parameter - - - -42704 -UNDEFINED OBJECT -undefined_object - - - -42701 -DUPLICATE COLUMN -duplicate_column - - - -42P03 -DUPLICATE CURSOR -duplicate_cursor - - - -42P04 -DUPLICATE DATABASE -duplicate_database - - - -42723 -DUPLICATE FUNCTION -duplicate_function - - - -42P05 -DUPLICATE PREPARED STATEMENT -duplicate_prepared_statement - - - -42P06 -DUPLICATE SCHEMA -duplicate_schema - - - -42P07 -DUPLICATE TABLE -duplicate_table - - - -42712 -DUPLICATE ALIAS -duplicate_alias - - - -42710 -DUPLICATE OBJECT -duplicate_object - - - -42702 -AMBIGUOUS COLUMN -ambiguous_column - - - -42725 -AMBIGUOUS FUNCTION -ambiguous_function - - - -42P08 -AMBIGUOUS PARAMETER -ambiguous_parameter - - - -42P09 -AMBIGUOUS ALIAS -ambiguous_alias - - - -42P10 -INVALID COLUMN REFERENCE -invalid_column_reference - - - -42611 -INVALID COLUMN DEFINITION -invalid_column_definition - - - -42P11 -INVALID CURSOR DEFINITION -invalid_cursor_definition - - - -42P12 -INVALID DATABASE DEFINITION -invalid_database_definition - - - -42P13 -INVALID FUNCTION DEFINITION -invalid_function_definition - - - -42P14 -INVALID PREPARED STATEMENT DEFINITION -invalid_prepared_statement_definition - - - -42P15 -INVALID SCHEMA DEFINITION -invalid_schema_definition - - - -42P16 -INVALID TABLE DEFINITION -invalid_table_definition - - - -42P17 -INVALID OBJECT DEFINITION -invalid_object_definition - - - - -Class 44 — WITH CHECK OPTION Violation - - - -44000 -WITH CHECK OPTION VIOLATION -with_check_option_violation - - - - -Class 53 — Insufficient Resources - - - -53000 -INSUFFICIENT RESOURCES -insufficient_resources - - - -53100 -DISK FULL -disk_full - - - -53200 -OUT OF MEMORY -out_of_memory - - - -53300 -TOO MANY CONNECTIONS -too_many_connections - - - - -Class 54 — Program Limit Exceeded - - - -54000 -PROGRAM LIMIT EXCEEDED -program_limit_exceeded - - - -54001 -STATEMENT TOO COMPLEX -statement_too_complex - - - -54011 -TOO MANY COLUMNS -too_many_columns - - - -54023 -TOO MANY ARGUMENTS -too_many_arguments - - - - -Class 55 — Object Not In Prerequisite State - - - -55000 -OBJECT NOT IN PREREQUISITE STATE -object_not_in_prerequisite_state - - - -55006 -OBJECT IN USE -object_in_use - - - -55P02 -CANT CHANGE RUNTIME PARAM -cant_change_runtime_param - - - -55P03 -LOCK NOT AVAILABLE -lock_not_available - - - - -Class 57 — Operator Intervention - - - -57000 -OPERATOR INTERVENTION -operator_intervention - - - -57014 -QUERY CANCELED -query_canceled - - - -57P01 -ADMIN SHUTDOWN -admin_shutdown - - - -57P02 -CRASH SHUTDOWN -crash_shutdown - - - -57P03 -CANNOT CONNECT NOW -cannot_connect_now - - - -57P04 -DATABASE DROPPED -database_dropped - - - - -Class 58 — System Error (errors external to PostgreSQL itself) - - - -58030 -IO ERROR -io_error - - - -58P01 -UNDEFINED FILE -undefined_file - - - -58P02 -DUPLICATE FILE -duplicate_file - - - - -Class F0 — Configuration File Error - - - -F0000 -CONFIG FILE ERROR -config_file_error - - - -F0001 -LOCK FILE EXISTS -lock_file_exists - - - - -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 - - - -P0000 -PLPGSQL ERROR -plpgsql_error - - - -P0001 -RAISE EXCEPTION -raise_exception - - - -P0002 -NO DATA FOUND -no_data_found - - - -P0003 -TOO MANY ROWS -too_many_rows - - - - -Class XX — Internal Error - - - -XX000 -INTERNAL ERROR -internal_error - - - -XX001 -DATA CORRUPTED -data_corrupted - - - -XX002 -INDEX CORRUPTED -index_corrupted - + &errcodes-table; diff --git a/doc/src/sgml/filelist.sgml b/doc/src/sgml/filelist.sgml index 99437ac3789..b9d4ea59b1a 100644 --- a/doc/src/sgml/filelist.sgml +++ b/doc/src/sgml/filelist.sgml @@ -164,6 +164,8 @@ + + diff --git a/doc/src/sgml/generate-errcodes-table.pl b/doc/src/sgml/generate-errcodes-table.pl new file mode 100644 index 00000000000..5d0ccffadd9 --- /dev/null +++ b/doc/src/sgml/generate-errcodes-table.pl @@ -0,0 +1,63 @@ +#!/usr/bin/perl +# +# Generate the errcodes-table.sgml file from errcodes.txt +# Copyright (c) 2000-2011, PostgreSQL Global Development Group + +use warnings; +use strict; + +print "\n"; + +open my $errcodes, $ARGV[0] or die; + +while (<$errcodes>) { + chomp; + + # Skip comments + next if /^#/; + next if /^\s*$/; + + # Emit section headers + if (/^Section:/) { + + # Remove the Section: string + s/^Section: //; + # Escape dashes for SGML + s/-/—/; + # Wrap PostgreSQL in + s/PostgreSQL/PostgreSQL<\/>/g; + + print "\n\n"; + print "\n"; + print ""; + print "$_\n"; + print "\n"; + + next; + } + + die unless /^([^\s]{5})\s+([EWS])\s+([^\s]+)(?:\s+)?([^\s]+)?/; + + (my $sqlstate, + my $type, + my $errcode_macro, + my $condition_name) = ($1, $2, $3, $4); + + # Skip lines without PL/pgSQL condition names + next unless defined($condition_name); + + my $meaning = $condition_name; + # Remove underscores + $meaning =~ s/_/ /g; + # And capitalize + $meaning =~ tr/[a-z]/[A-Z]/; + + print "\n"; + print "\n"; + print "$sqlstate\n"; + print "$meaning\n"; + print "$condition_name\n"; + print "\n"; +} + +close $errcodes; -- cgit v1.2.3