🐘

PostgreSQL SQLSTATE Errors

PostgreSQL 17256 codes

SQLSTATE error codes with SQL fix examples

Showing 256 of 256 errors

Code	Message	Severity	Tier
23505	duplicate key value violates unique constraint	ERROR	Common	→
23503	insert or update on table violates foreign key constraint	ERROR	Common	→
42P01	relation does not exist	ERROR	Common	→
42703	column does not exist	ERROR	Common	→
08006	connection failure	ERROR	Notable	→
28000	invalid authorization specification	FATAL	Common	→
40001	could not serialize access due to concurrent update	ERROR	Notable	→
40P01	deadlock detected	ERROR	Notable	→
22001	value too long for type character varying	ERROR	Common	→
53100	disk full	ERROR	Critical	→
42601	syntax error at or near "..."	ERROR	Common	→
55P03	lock not available	ERROR	Notable	→
22P02	invalid input syntax for type integer	ERROR	Common	→
42501	permission denied for table	ERROR	Common	→
57014	canceling statement due to statement timeout	ERROR	Notable	→
23514	new row for relation violates check constraint	ERROR	Common	→
42710	duplicate object	ERROR	Common	→
42P07	relation already exists	ERROR	Common	→
0A000	feature not supported	ERROR	Common	→
25P02	current transaction is aborted, commands ignored until end of transaction block	ERROR	Common	→
55000	object not in prerequisite state	ERROR	Notable	→
08001	could not connect to server	FATAL	Notable	→
22003	numeric value out of range	ERROR	Common	→
42883	function does not exist	ERROR	Common	→
53200	out of memory	ERROR	Critical	→
42846	cannot cast type	ERROR	Common	→
22007	invalid input syntax for type date	ERROR	Common	→
23502	null value in column violates not-null constraint	ERROR	Common	→
42P18	could not determine data type of parameter $N	ERROR	Common	→
XX000	internal error	ERROR	Critical	→
57P03	the database system is starting up	FATAL	Critical	→
57P01	terminating connection due to administrator command	FATAL	Notable	→
58000	could not open file	ERROR	Critical	→
53300	remaining connection slots are reserved for non-replication superuser connections	FATAL	Notable	→
3D000	database does not exist	FATAL	Common	→
3F000	invalid schema name	ERROR	Common	→
42P16	invalid table definition	ERROR	Common	→
2BP01	cannot drop table because other objects depend on it	ERROR	Common	→
25001	active SQL transaction	ERROR	Common	→
2D000	invalid transaction termination	ERROR	Common	→
00000	successful completion	NONE		→
01000	warning	WARNING	Critical	→
0100C	dynamic result sets returned	WARNING	Critical	→
01008	implicit zero bit padding	WARNING	Critical	→
01003	null value eliminated in set function	WARNING	Critical	→
01007	privilege not granted	WARNING	Critical	→
01006	privilege not revoked	WARNING	Critical	→
01004	string data right truncation	WARNING	Notable	→
01P01	deprecated feature	WARNING	Notable	→
02000	no data	WARNING	Critical	→
02001	no additional dynamic result sets returned	WARNING		→
03000	sql statement not yet complete	WARNING	Critical	→
08000	connection exception	ERROR	Notable	→
08003	connection does not exist	ERROR	Notable	→
08004	sqlserver rejected establishment of sqlconnection	ERROR	Notable	→
08007	transaction resolution unknown	ERROR	Common	→
08P01	protocol violation	ERROR	Notable	→
09000	triggered action exception	ERROR	Notable	→
0B000	invalid transaction initiation	ERROR	Notable	→
0F000	locator exception	ERROR	Critical	→
0F001	invalid locator specification	ERROR	Critical	→
0L000	invalid grantor	ERROR	Notable	→
0LP01	invalid grant operation	ERROR	Notable	→
0P000	invalid role specification	ERROR	Notable	→
0Z000	diagnostics exception	ERROR	Critical	→
0Z002	stacked diagnostics accessed without active handler	ERROR	Critical	→
20000	case not found	ERROR	Notable	→
21000	cardinality violation	ERROR	Notable	→
22000	data exception	ERROR	Notable	→
2202E	array subscript error	ERROR	Notable	→
22021	character not in repertoire	ERROR	Notable	→
22008	datetime field overflow	ERROR	Notable	→
22012	division by zero	ERROR	Notable	→
22005	error in assignment	ERROR	Notable	→
2200B	escape character conflict	ERROR	Notable	→
22022	indicator overflow	ERROR	Critical	→
22015	interval field overflow	ERROR	Notable	→
2201E	invalid argument for logarithm	ERROR	Notable	→
22014	invalid argument for ntile function	ERROR	Notable	→
22016	invalid argument for nth_value function	ERROR	Notable	→
2201F	invalid argument for power function	ERROR	Notable	→
2201G	invalid argument for width_bucket function	ERROR	Notable	→
22018	invalid character value for cast	ERROR	Notable	→
22019	invalid escape character	ERROR	Notable	→
2200D	invalid escape octet	ERROR	Notable	→
22025	invalid escape sequence	ERROR	Notable	→
22P06	nonstandard use of escape character	WARNING	Critical	→
22010	invalid indicator parameter value	ERROR	Critical	→
22023	invalid parameter value	ERROR	Notable	→
22013	invalid preceding or following size in window function	ERROR	Notable	→
2201B	invalid regular expression	ERROR	Notable	→
2201W	invalid row count in LIMIT clause	ERROR	Notable	→
2201X	invalid row count in result offset clause	ERROR	Notable	→
2202H	invalid tablesample argument	ERROR	Notable	→
2202G	invalid tablesample repeat	ERROR	Notable	→
22009	invalid time zone displacement value	ERROR	Notable	→
2200C	invalid use of escape character	ERROR	Notable	→
2200G	most specific type mismatch	ERROR	Notable	→
22004	null value not allowed	ERROR	Notable	→
22002	null value, no indicator parameter	ERROR	Critical	→
2200H	sequence generator limit exceeded	ERROR	Common	→
22026	string data length mismatch	ERROR	Notable	→
22011	substring error	ERROR	Notable	→
22027	trim error	ERROR	Critical	→
22024	unterminated C string	ERROR	Notable	→
2200F	zero length character string	ERROR	Critical	→
22P01	floating point exception	ERROR	Notable	→
22P03	invalid binary representation	ERROR	Notable	→
22P04	bad copy file format	ERROR	Notable	→
22P05	untranslatable character	ERROR	Notable	→
2200L	not an XML document	ERROR	Notable	→
2200M	invalid XML document	ERROR	Notable	→
2200N	invalid XML content	ERROR	Notable	→
2200S	invalid XML comment	ERROR	Critical	→
2200T	invalid XML processing instruction	ERROR	Critical	→
22030	invalid argument for SQL/JSON datetime function	ERROR	Notable	→
22031	invalid argument for SQL/JSON datetime function	ERROR	Notable	→
22032	invalid JSON text	ERROR	Notable	→
22033	invalid SQL/JSON subscript	ERROR	Notable	→
22034	more than one SQL/JSON item	ERROR	Notable	→
22035	no SQL/JSON item	ERROR	Notable	→
22036	non-numeric SQL/JSON item	ERROR	Notable	→
22037	non-unique keys in a JSON object	ERROR	Notable	→
22038	singleton SQL/JSON item required	ERROR	Notable	→
22039	SQL/JSON array not found	ERROR	Notable	→
2203A	SQL/JSON member not found	ERROR	Notable	→
2203B	SQL/JSON number not found	ERROR	Notable	→
2203C	SQL/JSON object not found	ERROR	Notable	→
2203D	too many JSON array elements	ERROR	Notable	→
2203E	too many JSON object members	ERROR	Notable	→
2203F	SQL/JSON scalar required	ERROR	Notable	→
2203G	SQL/JSON item cannot be cast to target type	ERROR	Notable	→
23000	integrity constraint violation	ERROR	Notable	→
23001	restrict violation	ERROR	Notable	→
23P01	exclusion constraint violation	ERROR	Notable	→
24000	invalid cursor state	ERROR	Notable	→
25000	invalid transaction state	ERROR	Notable	→
25002	active SQL transaction	ERROR	Notable	→
25008	held cursor requires same isolation level	ERROR	Notable	→
25003	inappropriate access mode for branch transaction	ERROR	Notable	→
25004	inappropriate isolation level for branch transaction	ERROR	Notable	→
25005	no active SQL transaction for branch transaction	ERROR	Notable	→
25006	read only SQL transaction	ERROR	Notable	→
25007	schema and data statement mixing not supported	ERROR	Notable	→
25P01	no active SQL transaction	ERROR	Notable	→
25P03	idle in transaction session timeout	ERROR	Notable	→
25P04	transaction timeout	ERROR	Notable	→
26000	invalid SQL statement name	ERROR	Notable	→
27000	triggered data change violation	ERROR	Notable	→
28P01	invalid password	FATAL	Notable	→
2B000	dependent privilege descriptors still exist	ERROR	Notable	→
2F000	SQL routine exception	ERROR	Notable	→
2F002	modifying SQL data not permitted	ERROR	Notable	→
2F003	prohibited SQL statement attempted	ERROR	Notable	→
2F004	reading SQL data not permitted	ERROR	Notable	→
2F005	function executed in wrong section of rule	ERROR	Notable	→
34000	invalid cursor name	ERROR	Notable	→
38000	external routine exception	ERROR	Notable	→
38001	containing SQL not permitted	ERROR	Notable	→
38002	modifying SQL data not permitted	ERROR	Notable	→
38003	prohibited SQL statement attempted	ERROR	Notable	→
38004	reading SQL data not permitted	ERROR	Notable	→
39000	external routine invocation exception	ERROR	Notable	→
39001	invalid SQLSTATE returned	ERROR	Notable	→
39004	null value not allowed	ERROR	Notable	→
39P01	trigger protocol violated	ERROR	Notable	→
39P02	SRF protocol violated	ERROR	Notable	→
39P03	event trigger protocol violated	ERROR	Notable	→
3B000	savepoint exception	ERROR	Notable	→
3B001	invalid savepoint specification	ERROR	Notable	→
40000	transaction rollback	ERROR	Notable	→
40002	transaction integrity constraint violation	ERROR	Notable	→
40003	statement completion unknown	ERROR	Common	→
42000	syntax error or access rule violation	ERROR	Notable	→
42803	grouping error	ERROR	Notable	→
42P20	windowing error	ERROR	Notable	→
42P19	invalid recursion	ERROR	Notable	→
42830	invalid foreign key	ERROR	Notable	→
42602	invalid name	ERROR	Notable	→
42622	name too long	ERROR	Notable	→
42939	reserved name	ERROR	Notable	→
42804	datatype mismatch	ERROR	Notable	→
42P21	indeterminate collation	ERROR	Notable	→
42P22	indeterminate datatype	ERROR	Notable	→
42809	wrong object type	ERROR	Notable	→
428C9	generated always	ERROR	Notable	→
42P02	undefined parameter	ERROR	Notable	→
42704	undefined object	ERROR	Notable	→
42701	duplicate column	ERROR	Notable	→
42P03	duplicate cursor	ERROR	Notable	→
42P04	duplicate database	ERROR	Notable	→
42P05	duplicate prepared statement	ERROR	Notable	→
42P06	duplicate schema	ERROR	Notable	→
42P08	ambiguous parameter	ERROR	Notable	→
42P09	ambiguous alias	ERROR	Notable	→
42P10	invalid column reference	ERROR	Notable	→
42P11	invalid cursor definition	ERROR	Notable	→
42P12	invalid database definition	ERROR	Notable	→
42P13	invalid function definition	ERROR	Notable	→
42P14	invalid prepared statement definition	ERROR	Notable	→
42P15	invalid schema definition	ERROR	Notable	→
42P17	invalid object definition	ERROR	Notable	→
44000	WITH CHECK OPTION violation	ERROR	Notable	→
53000	insufficient resources	ERROR	Common	→
53400	configuration limit exceeded	ERROR	Notable	→
54000	program limit exceeded	ERROR	Notable	→
54001	statement too complex	ERROR	Notable	→
54011	too many columns	ERROR	Notable	→
54023	too many arguments	ERROR	Notable	→
55006	object in use	ERROR	Notable	→
55P02	cannot change runtime parameter	ERROR	Notable	→
55P04	unsafe use of new enum value	ERROR	Notable	→
57000	operator intervention	ERROR	Notable	→
57P02	crash shutdown	FATAL	Common	→
57P04	database dropped	FATAL	Common	→
57P05	idle session timeout	FATAL	Notable	→
58030	I/O error	ERROR	Common	→
58P01	undefined file	ERROR	Notable	→
58P02	duplicate file	ERROR	Notable	→
F0000	config file error	FATAL	Common	→
F0001	lock file exists	FATAL	Notable	→
HV000	FDW error	ERROR	Notable	→
HV001	FDW out of memory	ERROR	Notable	→
HV002	FDW dynamic parameter value needed	ERROR	Notable	→
HV004	FDW invalid data type	ERROR	Notable	→
HV005	FDW column name not found	ERROR	Notable	→
HV006	FDW invalid data type descriptors	ERROR	Notable	→
HV007	FDW invalid column name	ERROR	Notable	→
HV008	FDW invalid column number	ERROR	Notable	→
HV009	FDW invalid use of null pointer	ERROR	Notable	→
HV00A	fdw_invalid_string_format	ERROR	Notable	→
HV00B	fdw_invalid_handle	ERROR	Notable	→
HV00C	fdw_invalid_option_index	ERROR	Notable	→
HV00D	fdw_invalid_option_name	ERROR	Notable	→
HV00J	fdw_option_name_not_found	ERROR	Notable	→
HV00K	fdw_reply_handle	ERROR	Notable	→
HV00L	fdw_unable_to_create_execution	ERROR	Notable	→
HV00M	fdw_unable_to_create_reply	ERROR	Notable	→
HV00N	fdw_unable_to_establish_connection	ERROR	Notable	→
HV010	fdw_function_sequence_error	ERROR	Notable	→
HV021	fdw_inconsistent_descriptor_information	ERROR	Notable	→
HV024	fdw_invalid_attribute_value	ERROR	Notable	→
HV090	fdw_invalid_string_length_or_buffer_length	ERROR	Notable	→
HV091	fdw_invalid_descriptor_field_identifier	ERROR	Notable	→
P0000	plpgsql_error	ERROR	Notable	→
P0001	raise_exception	ERROR	Notable	→
P0002	no_data_found	ERROR	Notable	→
P0003	too_many_rows	ERROR	Notable	→
P0004	assert_failure	ERROR	Notable	→
XX001	data_corrupted	ERROR	Common	→
XX002	index_corrupted	ERROR	Common	→
72000	Snapshot too old — query snapshot has expired	ERROR	Notable	→
HV00P	fdw_no_schemas	ERROR	Notable	→
HV00Q	fdw_option_name_not_found	ERROR	Notable	→
HV00R	fdw_unable_to_create_reply	ERROR	Notable	→
LW000	fdw_error (logical replication / LW class)	ERROR	Notable	→