PostgreSQL Response Codes
Utility to interact with PostgreSQL response codes.
Usage
Once you require this module, you may call it with either a PostgreSQL response code or a response name. With a code, you will get the code name while with a code name you will get a PostgreSQL response code. It's that simple!!!
Resources
API
API Sample
const PostgresResponseCodes = require('postgres-response-codes');
// Print "Unique Violation"
console.log(PostgresResponseCodes['23505']);
// Print "23505"
console.log(PostgresResponseCodes.UNIQUE_VIOLATION);
PostgreSQL Error Codes
Class 00 — Successful Completion
'00000': 'Successful Completion',
'SUCCESSFUL_COMPLETION': '00000',
Class 01 — Warning
'01000': 'Warning',
'WARNING': '01000',
'0100C': 'Dynamic Result Sets Returned',
'DYNAMIC_RESULT_SETS_RETURNED': '0100C',
'01008': 'Implicit Zero Bit Padding',
'IMPLICIT_ZERO_BIT_PADDING': '01008',
'01003': 'Null Value Eliminated In Set Function',
'NULL_VALUE_ELIMINATED_IN_SET_FUNCTION': '01003',
'01007': 'Privilege Not Granted',
'PRIVILEGE_NOT_GRANTED': '01007',
'01006': 'Privilege Not Revoked',
'PRIVILEGE_NOT_REVOKED': '01006',
'01004': 'String Data Right Truncation',
'STRING_DATA_RIGHT_TRUNCATION_WARNING': '01004',
'01P01': 'Deprecated Feature',
'DEPRECATED_FEATURE': '01P01',
Class 02 — No Data (this is also a warning class per the SQL standard)
'02000': 'No Data',
'NO_DATA': '02000',
'02001': 'No Additional Dynamic Result Sets Returned',
'NO_ADDITIONAL_DYNAMIC_RESULT_SETS_RETURNED': '02001',
Class 03 — SQL Statement Not Yet Complete
'03000': 'SQL Statement Not Yet Complete',
'SQL_STATEMENT_NOT_YET_COMPLETE': '03000',
Class 08 — Connection Exception
'08000': 'Connection Exception',
'CONNECTION_EXCEPTION': '08000',
'08003': 'Connection Does Not Exist',
'CONNECTION_DOES_NOT_EXIST': '08003',
'08006': 'Connection Failure',
'CONNECTION_FAILURE': '08006',
'08001': 'Sqlclient Unable To Establish Sqlconnection',
'SQLCLIENT_UNABLE_TO_ESTABLISH_SQLCONNECTION': '08001',
'08004': 'Sqlserver Rejected Establishment Of Sqlconnection',
'SQLSERVER_REJECTED_ESTABLISHMENT_OF_SQLCONNECTION': '08004',
'08007': 'Transaction Resolution Unknown',
'TRANSACTION_RESOLUTION_UNKNOWN': '08007',
'08P01': 'Protocol Violation',
'PROTOCOL_VIOLATION': '08P01',
Class 09 — Triggered Action Exception
'09000': 'Triggered Action Exception',
'TRIGGERED_ACTION_EXCEPTION': '09000',
Class 0A — Feature Not Supported
'0A000': 'Feature Not Supported',
'FEATURE_NOT_SUPPORTED': '0A000',
Class 0B — Invalid Transaction Initiation
'0B000': 'Invalid Transaction Initiation',
'INVALID_TRANSACTION_INITIATION': '0B000',
Class 0F — Locator Exception
'0F000': 'Locator Exception',
'LOCATOR_EXCEPTION': '0F000',
'0F001': 'Invalid Locator Specification',
'INVALID_LOCATOR_SPECIFICATION': '0F001',
Class 0L — Invalid Grantor
'0L000': 'Invalid Grantor',
'INVALID_GRANTOR': '0L000',
'0LP01': 'Invalid Grant Operation',
'INVALID_GRANT_OPERATION': '0LP01',
Class 0P — Invalid Role Specification
'0P000': 'Invalid Role Specification',
'INVALID_ROLE_SPECIFICATION': '0P000',
Class 0Z — Diagnostics Exception
'0Z000': 'Diagnostics Exception',
'DIAGNOSTICS_EXCEPTION': '0Z000',
'0Z002': 'Stacked Diagnostics Accessed Without Active Handler',
'STACKED_DIAGNOSTICS_ACCESSED_WITHOUT_ACTIVE_HANDLER': '0Z002',
Class 20 — Case Not Found
'20000': 'Case Not Found',
'CASE_NOT_FOUND': '20000',
Class 21 — Cardinality Violation
'21000': 'Cardinality Violation',
'CARDINALITY_VIOLATION': '21000',
Class 22 — Data Exception
'22000': 'Data Exception',
'DATA_EXCEPTION': '22000',
'2202E': 'Array Subscript Error',
'ARRAY_SUBSCRIPT_ERROR': '2202E',
'22021': 'Character Not In Repertoire',
'CHARACTER_NOT_IN_REPERTOIRE': '22021',
'22008': 'Datetime Field Overflow',
'DATETIME_FIELD_OVERFLOW': '22008',
'22012': 'Division By Zero',
'DIVISION_BY_ZERO': '22012',
'22005': 'Error In Assignment',
'ERROR_IN_ASSIGNMENT': '22005',
'2200B': 'Escape Character Conflict',
'ESCAPE_CHARACTER_CONFLICT': '2200B',
'22022': 'Indicator Overflow',
'INDICATOR_OVERFLOW': '22022',
'22015': 'Interval Field Overflow',
'INTERVAL_FIELD_OVERFLOW': '22015',
'2201E': 'Invalid Argument For Logarithm',
'INVALID_ARGUMENT_FOR_LOGARITHM': '2201E',
'22014': 'Invalid Argument For Ntile Function',
'INVALID_ARGUMENT_FOR_NTILE_FUNCTION': '22014',
'22016': 'Invalid Argument For Nth Value Function',
'INVALID_ARGUMENT_FOR_NTH_VALUE_FUNCTION': '22016',
'2201F': 'Invalid Argument For Power Function',
'INVALID_ARGUMENT_FOR_POWER_FUNCTION': '2201F',
'2201G': 'Invalid Argument For Width Bucket Function',
'INVALID_ARGUMENT_FOR_WIDTH_BUCKET_FUNCTION': '2201G',
'22018': 'Invalid Character Value For Cast',
'INVALID_CHARACTER_VALUE_FOR_CAST': '22018',
'22007': 'Invalid Datetime Format',
'INVALID_DATETIME_FORMAT': '22007',
'22019': 'Invalid Escape Character',
'INVALID_ESCAPE_CHARACTER': '22019',
'2200D': 'Invalid Escape Octet',
'INVALID_ESCAPE_OCTET': '2200D',
'22025': 'Invalid Escape Sequence',
'INVALID_ESCAPE_SEQUENCE': '22025',
'22P06': 'Nonstandard Use Of Escape Character',
'NONSTANDARD_USE_OF_ESCAPE_CHARACTER': '22P06',
'22010': 'Invalid Indicator Parameter Value',
'INVALID_INDICATOR_PARAMETER_VALUE': '22010',
'22023': 'Invalid Parameter Value',
'INVALID_PARAMETER_VALUE': '22023',
'2201B': 'Invalid Regular Expression',
'INVALID_REGULAR_EXPRESSION': '2201B',
'2201W': 'Invalid Row Count In Limit Clause',
'INVALID_ROW_COUNT_IN_LIMIT_CLAUSE': '2201W',
'2201X': 'Invalid Row Count In Result Offset Clause',
'INVALID_ROW_COUNT_IN_RESULT_OFFSET_CLAUSE': '2201X',
'22009': 'Invalid Time Zone Displacement Value',
'INVALID_TIME_ZONE_DISPLACEMENT_VALUE': '22009',
'2200C': 'Invalid Use Of Escape Character',
'INVALID_USE_OF_ESCAPE_CHARACTER': '2200C',
'2200G': 'Most Specific Type Mismatch',
'MOST_SPECIFIC_TYPE_MISMATCH': '2200G',
'22004': 'Null Value Not Allowed',
'NULL_VALUE_NOT_ALLOWED': '22004',
'22002': 'Null Value No Indicator Parameter',
'NULL_VALUE_NO_INDICATOR_PARAMETER': '22002',
'22003': 'Numeric Value Out Of Range',
'NUMERIC_VALUE_OUT_OF_RANGE': '22003',
'22026': 'String Data Length Mismatch',
'STRING_DATA_LENGTH_MISMATCH': '22026',
'22001': 'String Data Right Truncation',
'STRING_DATA_RIGHT_TRUNCATION_EXCEPTION': '22001',
'22011': 'Substring Error',
'SUBSTRING_ERROR': '22011',
'22027': 'Trim Error',
'TRIM_ERROR': '22027',
'22024': 'Unterminated C String',
'UNTERMINATED_C_STRING': '22024',
'2200F': 'Zero Length Character String',
'ZERO_LENGTH_CHARACTER_STRING': '2200F',
'22P01': 'Floating Point Exception',
'FLOATING_POINT_EXCEPTION': '22P01',
'22P02': 'Invalid Text Representation',
'INVALID_TEXT_REPRESENTATION': '22P02',
'22P03': 'Invalid Binary Representation',
'INVALID_BINARY_REPRESENTATION': '22P03',
'22P04': 'Bad Copy File Format',
'BAD_COPY_FILE_FORMAT': '22P04',
'22P05': 'Untranslatable Character',
'UNTRANSLATABLE_CHARACTER': '22P05',
'2200L': 'Not An XML Document',
'NOT_AN_XML_DOCUMENT': '2200L',
'2200M': 'Invalid XML Document',
'INVALID_XML_DOCUMENT': '2200M',
'2200N': 'Invalid XML Content',
'INVALID_XML_CONTENT': '2200N',
'2200S': 'Invalid XML Comment',
'INVALID_XML_COMMENT': '2200S',
'2200T': 'Invalid XML Processing Instruction',
'INVALID_XML_PROCESSING_INSTRUCTION': '2200T',
Class 23 — Integrity Constraint Violation
'23000': 'Integrity Constraint Violation',
'INTEGRITY_CONSTRAINT_VIOLATION': '23000',
'23001': 'Restrict Violation',
'RESTRICT_VIOLATION': '23001',
'23502': 'Not Null Violation',
'NOT_NULL_VIOLATION': '23502',
'23503': 'Foreign Key Violation',
'FOREIGN_KEY_VIOLATION': '23503',
'23505': 'Unique Violation',
'UNIQUE_VIOLATION': '23505',
'23514': 'Check Violation',
'CHECK_VIOLATION': '23514',
'23P01': 'Exclusion Violation',
'EXCLUSION_VIOLATION': '23P01',
Class 24 — Invalid Cursor State
'24000': 'Invalid Cursor State',
'INVALID_CURSOR_STATE': '24000',
Class 25 — Invalid Transaction State
'25000': 'Invalid Transaction State',
'INVALID_TRANSACTION_STATE': '25000',
'25001': 'Active SQL Transaction',
'ACTIVE_SQL_TRANSACTION': '25001',
'25002': 'Branch Transaction Already Active',
'BRANCH_TRANSACTION_ALREADY_ACTIVE': '25002',
'25008': 'Held Cursor Requires Same Isolation Level',
'HELD_CURSOR_REQUIRES_SAME_ISOLATION_LEVEL': '25008',
'25003': 'Inappropriate Access Mode For Branch Transaction',
'INAPPROPRIATE_ACCESS_MODE_FOR_BRANCH_TRANSACTION': '25003',
'25004': 'Inappropriate Isolation Level For Branch Transaction',
'INAPPROPRIATE_ISOLATION_LEVEL_FOR_BRANCH_TRANSACTION': '25004',
'25005': 'No Active SQL Transaction For Branch Transaction',
'NO_ACTIVE_SQL_TRANSACTION_FOR_BRANCH_TRANSACTION': '25005',
'25006': 'Read Only SQL Transaction',
'READ_ONLY_SQL_TRANSACTION': '25006',
'25007': 'Schema And Data Statement Mixing Not Supported',
'SCHEMA_AND_DATA_STATEMENT_MIXING_NOT_SUPPORTED': '25007',
'25P01': 'No Active SQL Transaction',
'NO_ACTIVE_SQL_TRANSACTION': '25P01',
'25P02': 'In Failed SQL Transaction',
'IN_FAILED_SQL_TRANSACTION': '25P02',
Class 26 — Invalid SQL Statement Name
'26000': 'Invalid SQL Statement Name',
'INVALID_SQL_STATEMENT_NAME': '26000',
Class 27 — Triggered Data Change Violation
'27000': 'Triggered Data Change Violation',
'TRIGGERED_DATA_CHANGE_VIOLATION': '27000',
Class 28 — Invalid Authorization Specification
'28000': 'Invalid Authorization Specification',
'INVALID_AUTHORIZATION_SPECIFICATION': '28000',
'28P01': 'Invalid Password',
'INVALID_PASSWORD': '28P01',
Class 2B — Dependent Privilege Descriptors Still Exist
'2B000': 'Dependent Privilege Descriptors Still Exist',
'DEPENDENT_PRIVILEGE_DESCRIPTORS_STILL_EXIST': '2B000',
'2BP01': 'Dependent Objects Still Exist',
'DEPENDENT_OBJECTS_STILL_EXIST': '2BP01',
Class 2D — Invalid Transaction Termination
'2D000': 'Invalid Transaction Termination',
'INVALID_TRANSACTION_TERMINATION': '2D000',
Class 2F — SQL Routine Exception
'2F000': 'SQL Routine Exception',
'SQL_ROUTINE_EXCEPTION': '2F000',
'2F005': 'Function Executed No Return Statement',
'FUNCTION_EXECUTED_NO_RETURN_STATEMENT': '2F005',
'2F002': 'Modifying SQL Data Not Permitted',
'SQL_MODIFYING_SQL_DATA_NOT_PERMITTED': '2F002',
'2F003': 'Prohibited SQL Statement Attempted',
'SQL_PROHIBITED_SQL_STATEMENT_ATTEMPTED': '2F003',
'2F004': 'Reading SQL Data Not Permitted',
'SQL_READING_SQL_DATA_NOT_PERMITTED': '2F004',
Class 34 — Invalid Cursor Name
'34000': 'Invalid Cursor Name',
'INVALID_CURSOR_NAME': '34000',
Class 38 — External Routine Exception
'38000': 'External Routine Exception',
'EXTERNAL_ROUTINE_EXCEPTION': '38000',
'38001': 'Containing SQL Not Permitted',
'CONTAINING_SQL_NOT_PERMITTED': '38001',
'38002': 'Modifying SQL Data Not Permitted',
'EXTERNAL_MODIFYING_SQL_DATA_NOT_PERMITTED': '38002',
'38003': 'Prohibited SQL Statement Attempted',
'EXTERNAL_PROHIBITED_SQL_STATEMENT_ATTEMPTED': '38003',
'38004': 'Reading SQL Data Not Permitted',
'EXTERNAL_READING_SQL_DATA_NOT_PERMITTED': '38004',
Class 39 — External Routine Invocation Exception
'39000': 'External Routine Invocation Exception',
'EXTERNAL_ROUTINE_INVOCATION_EXCEPTION': '39000',
'39001': 'Invalid SQLstate Returned',
'INVALID_SQLSTATE_RETURNED': '39001',
'39004': 'Null Value Not Allowed',
'EXTERNAL_NULL_VALUE_NOT_ALLOWED': '39004',
'39P01': 'Trigger Protocol Violated',
'TRIGGER_PROTOCOL_VIOLATED': '39P01',
'39P02': 'SRF Protocol Violated',
'SRF_PROTOCOL_VIOLATED': '39P02',
Class 3B — Savepoint Exception
'3B000': 'Savepoint Exception',
'SAVEPOINT_EXCEPTION': '3B000',
'3B001': 'Invalid Savepoint Specification',
'INVALID_SAVEPOINT_SPECIFICATION': '3B001',
Class 3D — Invalid Catalog Name
'3D000': 'Invalid Catalog Name',
'INVALID_CATALOG_NAME': '3D000',
Class 3F — Invalid Schema Name
'3F000': 'Invalid Schema Name',
'INVALID_SCHEMA_NAME': '3F000',
Class 40 — Transaction Rollback
'40000': 'Transaction Rollback',
'TRANSACTION_ROLLBACK': '40000',
'40002': 'Transaction Integrity Constraint Violation',
'TRANSACTION_INTEGRITY_CONSTRAINT_VIOLATION': '40002',
'40001': 'Serialization Failure',
'SERIALIZATION_FAILURE': '40001',
'40003': 'Statement Completion Unknown',
'STATEMENT_COMPLETION_UNKNOWN': '40003',
'40P01': 'Deadlock Detected',
'DEADLOCK_DETECTED': '40P01',
Class 42 — Syntax Error or Access Rule Violation
'42000': 'Syntax Error Or Access Rule Violation',
'SYNTAX_ERROR_OR_ACCESS_RULE_VIOLATION': '42000',
'42601': 'Syntax Error',
'SYNTAX_ERROR': '42601',
'42501': 'Insufficient Privilege',
'INSUFFICIENT_PRIVILEGE': '42501',
'42846': 'Cannot Coerce',
'CANNOT_COERCE': '42846',
'42803': 'Grouping Error',
'GROUPING_ERROR': '42803',
'42P20': 'Windowing Error',
'WINDOWING_ERROR': '42P20',
'42P19': 'Invalid Recursion',
'INVALID_RECURSION': '42P19',
'42830': 'Invalid Foreign Key',
'INVALID_FOREIGN_KEY': '42830',
'42602': 'Invalid Name',
'INVALID_NAME': '42602',
'42622': 'Name Too Long',
'NAME_TOO_LONG': '42622',
'42939': 'Reserved Name',
'RESERVED_NAME': '42939',
'42804': 'Datatype Mismatch',
'DATATYPE_MISMATCH': '42804',
'42P18': 'Indeterminate Datatype',
'INDETERMINATE_DATATYPE': '42P18',
'42P21': 'Collation Mismatch',
'COLLATION_MISMATCH': '42P21',
'42P22': 'Indeterminate Collation',
'INDETERMINATE_COLLATION': '42P22',
'42809': 'Wrong Object Type',
'WRONG_OBJECT_TYPE': '42809',
'42703': 'Undefined Column',
'UNDEFINED_COLUMN': '42703',
'42883': 'Undefined Function',
'UNDEFINED_FUNCTION': '42883',
'42P01': 'Undefined Table',
'UNDEFINED_TABLE': '42P01',
'42P02': 'Undefined Parameter',
'UNDEFINED_PARAMETER': '42P02',
'42704': 'Undefined Object',
'UNDEFINED_OBJECT': '42704',
'42701': 'Duplicate Column',
'DUPLICATE_COLUMN': '42701',
'42P03': 'Duplicate Cursor',
'DUPLICATE_CURSOR': '42P03',
'42P04': 'Duplicate Database',
'DUPLICATE_DATABASE': '42P04',
'42723': 'Duplicate Function',
'DUPLICATE_FUNCTION': '42723',
'42P05': 'Duplicate Prepared Statement',
'DUPLICATE_PREPARED_STATEMENT': '42P05',
'42P06': 'Duplicate Schema',
'DUPLICATE_SCHEMA': '42P06',
'42P07': 'Duplicate Table',
'DUPLICATE_TABLE': '42P07',
'42712': 'Duplicate Alias',
'DUPLICATE_ALIAS': '42712',
'42710': 'Duplicate Object',
'DUPLICATE_OBJECT': '42710',
'42702': 'Ambiguous Column',
'AMBIGUOUS_COLUMN': '42702',
'42725': 'Ambiguous Function',
'AMBIGUOUS_FUNCTION': '42725',
'42P08': 'Ambiguous Parameter',
'AMBIGUOUS_PARAMETER': '42P08',
'42P09': 'Ambiguous Alias',
'AMBIGUOUS_ALIAS': '42P09',
'42P10': 'Invalid Column Reference',
'INVALID_COLUMN_REFERENCE': '42P10',
'42611': 'Invalid Column Definition',
'INVALID_COLUMN_DEFINITION': '42611',
'42P11': 'Invalid Cursor Definition',
'INVALID_CURSOR_DEFINITION': '42P11',
'42P12': 'Invalid Database Definition',
'INVALID_DATABASE_DEFINITION': '42P12',
'42P13': 'Invalid Function Definition',
'INVALID_FUNCTION_DEFINITION': '42P13',
'42P14': 'Invalid Prepared Statement Definition',
'INVALID_PREPARED_STATEMENT_DEFINITION': '42P14',
'42P15': 'Invalid Schema Definition',
'INVALID_SCHEMA_DEFINITION': '42P15',
'42P16': 'Invalid Table Definition',
'INVALID_TABLE_DEFINITION': '42P16',
'42P17': 'Invalid Object Definition',
'INVALID_OBJECT_DEFINITION': '42P17',
Class 44 — WITH CHECK OPTION Violation
'44000': 'With Check Option Violation',
'WITH_CHECK_OPTION_VIOLATION': '44000',
Class 53 — Insufficient Resources
'53000': 'Insufficient Resources',
'INSUFFICIENT_RESOURCES': '53000',
'53100': 'Disk Full',
'DISK_FULL': '53100',
'53200': 'Out Of Memory',
'OUT_OF_MEMORY': '53200',
'53300': 'Too Many Connections',
'TOO_MANY_CONNECTIONS': '53300',
'53400': 'Configuration Limit Exceeded',
'CONFIGURATION_LIMIT_EXCEEDED': '53400',
Class 54 — Program Limit Exceeded
'54000': 'Program Limit Exceeded',
'PROGRAM_LIMIT_EXCEEDED': '54000',
'54001': 'Statement Too Complex',
'STATEMENT_TOO_COMPLEX': '54001',
'54011': 'Too Many Columns',
'TOO_MANY_COLUMNS': '54011',
'54023': 'Too Many Arguments',
'TOO_MANY_ARGUMENTS': '54023',
Class 55 — Object Not In Prerequisite State
'55000': 'Object Not In Prerequisite State',
'OBJECT_NOT_IN_PREREQUISITE_STATE': '55000',
'55006': 'Object In Use',
'OBJECT_IN_USE': '55006',
'55P02': 'Cant Change Runtime Param',
'CANT_CHANGE_RUNTIME_PARAM': '55P02',
'55P03': 'Lock Not Available',
'LOCK_NOT_AVAILABLE': '55P03',
Class 57 — Operator Intervention
'57000': 'Operator Intervention',
'OPERATOR_INTERVENTION': '57000',
'57014': 'Query Canceled',
'QUERY_CANCELED': '57014',
'57P01': 'Admin Shutdown',
'ADMIN_SHUTDOWN': '57P01',
'57P02': 'Crash Shutdown',
'CRASH_SHUTDOWN': '57P02',
'57P03': 'Cannot Connect Now',
'CANNOT_CONNECT_NOW': '57P03',
'57P04': 'Database Dropped',
'DATABASE_DROPPED': '57P04',
Class 58 — System Error (errors external to PostgreSQL itself)
'58000': 'System Error',
'SYSTEM_ERROR': '58000',
'58030': 'IO Error',
'IO_ERROR': '58030',
'58P01': 'Undefined File',
'UNDEFINED_FILE': '58P01',
'58P02': 'Duplicate File',
'DUPLICATE_FILE': '58P02',
Class F0 — Configuration File Error
'F0000': 'Config File Error',
'CONFIG_FILE_ERROR': 'F0000',
'F0001': 'Lock File Exists',
'LOCK_FILE_EXISTS': 'F0001',
Class HV — Foreign Data Wrapper Error (SQL/MED)
'HV000': 'FDW Error',
'FDW_ERROR': 'HV000',
'HV005': 'FDW Column Name Not Found',
'FDW_COLUMN_NAME_NOT_FOUND': 'HV005',
'HV002': 'FDW Dynamic Parameter Value Needed',
'FDW_DYNAMIC_PARAMETER_VALUE_NEEDED': 'HV002',
'HV010': 'FDW Function Sequence Error',
'FDW_FUNCTION_SEQUENCE_ERROR': 'HV010',
'HV021': 'FDW Inconsistent Descriptor Information',
'FDW_INCONSISTENT_DESCRIPTOR_INFORMATION': 'HV021',
'HV024': 'FDW Invalid Attribute Value',
'FDW_INVALID_ATTRIBUTE_VALUE': 'HV024',
'HV007': 'FDW Invalid Column Name',
'FDW_INVALID_COLUMN_NAME': 'HV007',
'HV008': 'FDW Invalid Column Number',
'FDW_INVALID_COLUMN_NUMBER': 'HV008',
'HV004': 'FDW Invalid Data Type',
'FDW_INVALID_DATA_TYPE': 'HV004',
'HV006': 'FDW Invalid Data Type Descriptors',
'FDW_INVALID_DATA_TYPE_DESCRIPTORS': 'HV006',
'HV091': 'FDW Invalid Descriptor Field Identifier',
'FDW_INVALID_DESCRIPTOR_FIELD_IDENTIFIER': 'HV091',
'HV00B': 'FDW Invalid Handle',
'FDW_INVALID_HANDLE': 'HV00B',
'HV00C': 'FDW Invalid Option Index',
'FDW_INVALID_OPTION_INDEX': 'HV00C',
'HV00D': 'FDW Invalid Option Name',
'FDW_INVALID_OPTION_NAME': 'HV00D',
'HV090': 'FDW Invalid String Length Or Buffer Length',
'FDW_INVALID_STRING_LENGTH_OR_BUFFER_LENGTH': 'HV090',
'HV00A': 'FDW Invalid String Format',
'FDW_INVALID_STRING_FORMAT': 'HV00A',
'HV009': 'FDW Invalid Use Of Null Pointer',
'FDW_INVALID_USE_OF_NULL_POINTER': 'HV009',
'HV014': 'FDW Too Many Handles',
'FDW_TOO_MANY_HANDLES': 'HV014',
'HV001': 'FDW Out Of Memory',
'FDW_OUT_OF_MEMORY': 'HV001',
'HV00P': 'FDW No Schemas',
'FDW_NO_SCHEMAS': 'HV00P',
'HV00J': 'FDW Option Name Not Found',
'FDW_OPTION_NAME_NOT_FOUND': 'HV00J',
'HV00K': 'FDW Reply Handle',
'FDW_REPLY_HANDLE': 'HV00K',
'HV00Q': 'FDW Schema Not Found',
'FDW_SCHEMA_NOT_FOUND': 'HV00Q',
'HV00R': 'FDW Table Not Found',
'FDW_TABLE_NOT_FOUND': 'HV00R',
'HV00L': 'FDW Unable To Create Execution',
'FDW_UNABLE_TO_CREATE_EXECUTION': 'HV00L',
'HV00M': 'FDW Unable To Create Reply',
'FDW_UNABLE_TO_CREATE_REPLY': 'HV00M',
'HV00N': 'FDW Unable To Establish Connection',
'FDW_UNABLE_TO_ESTABLISH_CONNECTION': 'HV00N',
Class P0 — PL/pgSQL Error
'P0000': 'PLpgSQL Error',
'PLPGSQL_ERROR': 'P0000',
'P0001': 'Raise Exception',
'RAISE_EXCEPTION': 'P0001',
'P0002': 'No Data Found',
'NO_DATA_FOUND': 'P0002',
'P0003': 'Too Many Rows',
'TOO_MANY_ROWS': 'P0003',
Class XX — Internal Error
'XX000': 'Internal Error',
'INTERNAL_ERROR': 'XX000',
'XX001': 'Data Corrupted',
'DATA_CORRUPTED': 'XX001',
'XX002': 'Index Corrupted',
'INDEX_CORRUPTED': 'XX002',
Contributors
- Holly Springsteen - https://github.com/hollyos