PostgreSQL SQLSTATE

189 entrées vérifiées et sourcées. Les codes sont interprétés uniquement dans cet espace de noms.

00000successful_completionsuccessful completion 01000warningwarning 01003null_value_eliminated_in_set_functionnull value eliminated in set function 01004string_data_right_truncationstring data right truncation 01006privilege_not_revokedprivilege not revoked 01007privilege_not_grantedprivilege not granted 01008implicit_zero_bit_paddingimplicit zero bit padding 0100Cdynamic_result_sets_returneddynamic result sets returned 01P01deprecated_featuredeprecated feature 02000no_datano data 02001no_additional_dynamic_result_sets_returnedno additional dynamic result sets returned 03000sql_statement_not_yet_completesql statement not yet complete 08000connection_exceptionconnection exception 08001sqlclient_unable_to_establish_sqlconnectionsqlclient unable to establish sqlconnection 08003connection_does_not_existconnection does not exist 08004sqlserver_rejected_establishment_of_sqlconnectionsqlserver rejected establishment of sqlconnection 08006connection_failureconnection failure 08007transaction_resolution_unknowntransaction resolution unknown 08P01protocol_violationprotocol violation 09000triggered_action_exceptiontriggered action exception 0A000feature_not_supportedfeature not supported 0B000invalid_transaction_initiationinvalid transaction initiation 0F000locator_exceptionlocator exception 0F001invalid_locator_specificationinvalid locator specification 0L000invalid_grantorinvalid grantor 0LP01invalid_grant_operationinvalid grant operation 0P000invalid_role_specificationinvalid role specification 0Z000diagnostics_exceptiondiagnostics exception 0Z002stacked_diagnostics_accessed_without_active_handlerstacked diagnostics accessed without active handler 20000case_not_foundcase not found 21000cardinality_violationcardinality violation 22000data_exceptiondata exception 22001string_data_right_truncationstring data right truncation 22003numeric_value_out_of_rangenumeric value out of range 22004null_value_not_allowednull value not allowed 22005error_in_assignmenterror in assignment 22007invalid_datetime_formatinvalid datetime format 22008datetime_field_overflowdatetime field overflow 22009invalid_time_zone_displacement_valueinvalid time zone displacement value 2200Bescape_character_conflictescape character conflict 2200Lnot_an_xml_documentnot an xml document 2200Minvalid_xml_documentinvalid xml document 2200Ninvalid_xml_contentinvalid xml content 22011substring_errorsubstring error 22012division_by_zerodivision by zero 22014invalid_argument_for_ntile_functioninvalid argument for ntile function 22015interval_field_overflowinterval field overflow 22016invalid_argument_for_nth_value_functioninvalid argument for nth value function 22018invalid_character_value_for_castinvalid character value for cast 22019invalid_escape_characterinvalid escape character 2201Binvalid_regular_expressioninvalid regular expression 2201Einvalid_argument_for_logarithminvalid argument for logarithm 2201Finvalid_argument_for_power_functioninvalid argument for power function 2201Ginvalid_argument_for_width_bucket_functioninvalid argument for width bucket function 22021character_not_in_repertoirecharacter not in repertoire 22023invalid_parameter_valueinvalid parameter value 22024unterminated_c_stringunterminated c string 22025invalid_escape_sequenceinvalid escape sequence 2202Earray_subscript_errorarray subscript error 22030duplicate_json_object_key_valueduplicate json object key value 22032invalid_json_textinvalid json text 22033invalid_sql_json_subscriptinvalid sql json subscript 22034more_than_one_sql_json_itemmore than one sql json item 22035no_sql_json_itemno sql json item 22036non_numeric_sql_json_itemnon numeric sql json item 22037non_unique_keys_in_a_json_objectnon unique keys in a json object 22038singleton_sql_json_item_requiredsingleton sql json item required 22P01floating_point_exceptionfloating point exception 22P02invalid_text_representationinvalid text representation 22P03invalid_binary_representationinvalid binary representation 22P04bad_copy_file_formatbad copy file format 22P05untranslatable_characteruntranslatable character 22P06nonstandard_use_of_escape_characternonstandard use of escape character 23000integrity_constraint_violationintegrity constraint violation 23001restrict_violationrestrict violation 23502not_null_violationnot null violation 23503foreign_key_violationforeign key violation 23505unique_violationunique violation 23514check_violationcheck violation 23P01exclusion_violationexclusion violation 24000invalid_cursor_stateinvalid cursor state 25000invalid_transaction_stateinvalid transaction state 25001active_sql_transactionactive sql transaction 25006read_only_sql_transactionread only sql transaction 25P01no_active_sql_transactionno active sql transaction 25P02in_failed_sql_transactionin failed sql transaction 25P03idle_in_transaction_session_timeoutidle in transaction session timeout 26000invalid_sql_statement_nameinvalid sql statement name 27000triggered_data_change_violationtriggered data change violation 28000invalid_authorization_specificationinvalid authorization specification 28P01invalid_passwordinvalid password 2B000dependent_privilege_descriptors_still_existdependent privilege descriptors still exist 2BP01dependent_objects_still_existdependent objects still exist 2D000invalid_transaction_terminationinvalid transaction termination 2F000sql_routine_exceptionsql routine exception 34000invalid_cursor_nameinvalid cursor name 38000external_routine_exceptionexternal routine exception 39000external_routine_invocation_exceptionexternal routine invocation exception 39001invalid_sqlstate_returnedinvalid sqlstate returned 39004null_value_not_allowednull value not allowed 39P01trigger_protocol_violatedtrigger protocol violated 39P02srf_protocol_violatedsrf protocol violated 39P03event_trigger_protocol_violatedevent trigger protocol violated 3B000savepoint_exceptionsavepoint exception 3B001invalid_savepoint_specificationinvalid savepoint specification 3D000invalid_catalog_nameinvalid catalog name 3F000invalid_schema_nameinvalid schema name 40000transaction_rollbacktransaction rollback 40001serialization_failureserialization failure 40002transaction_integrity_constraint_violationtransaction integrity constraint violation 40003statement_completion_unknownstatement completion unknown 40P01deadlock_detecteddeadlock detected 42000syntax_error_or_access_rule_violationsyntax error or access rule violation 42501insufficient_privilegeinsufficient privilege 42601syntax_errorsyntax error 42602invalid_nameinvalid name 42611invalid_column_definitioninvalid column definition 42622name_too_longname too long 42701duplicate_columnduplicate column 42702ambiguous_columnambiguous column 42703undefined_columnundefined column 42704undefined_objectundefined object 42710duplicate_objectduplicate object 42712duplicate_aliasduplicate alias 42723duplicate_functionduplicate function 42725ambiguous_functionambiguous function 42803grouping_errorgrouping error 42804datatype_mismatchdatatype mismatch 42809wrong_object_typewrong object type 42830invalid_foreign_keyinvalid foreign key 42846cannot_coercecannot coerce 42883undefined_functionundefined function 42939reserved_namereserved name 42P01undefined_tableundefined table 42P02undefined_parameterundefined parameter 42P03duplicate_cursorduplicate cursor 42P04duplicate_databaseduplicate database 42P05duplicate_prepared_statementduplicate prepared statement 42P06duplicate_schemaduplicate schema 42P07duplicate_tableduplicate table 42P08ambiguous_parameterambiguous parameter 42P09ambiguous_aliasambiguous alias 42P10invalid_column_referenceinvalid column reference 42P11invalid_cursor_definitioninvalid cursor definition 42P12invalid_database_definitioninvalid database definition 42P13invalid_function_definitioninvalid function definition 42P14invalid_prepared_statement_definitioninvalid prepared statement definition 42P15invalid_schema_definitioninvalid schema definition 42P16invalid_table_definitioninvalid table definition 42P17invalid_object_definitioninvalid object definition 42P18indeterminate_datatypeindeterminate datatype 42P19invalid_recursioninvalid recursion 42P20windowing_errorwindowing error 42P21collation_mismatchcollation mismatch 42P22indeterminate_collationindeterminate collation 44000with_check_option_violationwith check option violation 53000insufficient_resourcesinsufficient resources 53100disk_fulldisk full 53200out_of_memoryout of memory 53300too_many_connectionstoo many connections 53400configuration_limit_exceededconfiguration limit exceeded 54000program_limit_exceededprogram limit exceeded 54001statement_too_complexstatement too complex 54011too_many_columnstoo many columns 54023too_many_argumentstoo many arguments 55000object_not_in_prerequisite_stateobject not in prerequisite state 55006object_in_useobject in use 55P02cant_change_runtime_paramcant change runtime param 55P03lock_not_availablelock not available 57000operator_interventionoperator intervention 57014query_canceledquery canceled 57P01admin_shutdownadmin shutdown 57P02crash_shutdowncrash shutdown 57P03cannot_connect_nowcannot connect now 57P04database_droppeddatabase dropped 58000system_errorsystem error 58030io_errorio error 58P01undefined_fileundefined file 58P02duplicate_fileduplicate file F0000config_file_errorconfig file error F0001lock_file_existslock file exists P0000plpgsql_errorplpgsql error P0001raise_exceptionraise exception P0002no_data_foundno data found P0003too_many_rowstoo many rows P0004assert_failureassert failure XX000internal_errorinternal error XX001data_corrupteddata corrupted XX002index_corruptedindex corrupted