Skip to content

PostgreSQL 10.23 — formal

SQLSTATE definition snapshot and evidence members for PostgreSQL 10.23.

PostgreSQL 10.23 — formal

Snapshot

This is a locked formal definition snapshot containing 240 SQLSTATE values. Presence means the value appears in the release definition source; it does not by itself prove a runtime path.

Members

00000, 01000, 01003, 01004, 01006, 01007, 01008, 0100C, 01P01, 02000, 02001, 03000, 08000, 08001, 08003, 08004, 08006, 08007, 08P01, 09000, 0A000, 0B000, 0F000, 0F001, 0L000, 0LP01, 0P000, 0Z000, 0Z002, 20000, 21000, 22000, 22001, 22002, 22003, 22004, 22005, 22007, 22008, 22009, 2200B, 2200C, 2200D, 2200F, 2200G, 2200H, 2200L, 2200M, 2200N, 2200S, 2200T, 22010, 22011, 22012, 22014, 22015, 22016, 22018, 22019, 2201B, 2201E, 2201F, 2201G, 2201W, 2201X, 22021, 22022, 22023, 22024, 22025, 22026, 22027, 2202E, 2202G, 2202H, 22P01, 22P02, 22P03, 22P04, 22P05, 22P06, 23000, 23001, 23502, 23503, 23505, 23514, 23P01, 24000, 25000, 25001, 25002, 25003, 25004, 25005, 25006, 25007, 25008, 25P01, 25P02, 25P03, 26000, 27000, 28000, 28P01, 2B000, 2BP01, 2D000, 2F000, 2F002, 2F003, 2F004, 2F005, 34000, 38000, 38001, 38002, 38003, 38004, 39000, 39001, 39004, 39P01, 39P02, 39P03, 3B000, 3B001, 3D000, 3F000, 40000, 40001, 40002, 40003, 40P01, 42000, 42501, 42601, 42602, 42611, 42622, 42701, 42702, 42703, 42704, 42710, 42712, 42723, 42725, 42803, 42804, 42809, 42830, 42846, 42883, 428C9, 42939, 42P01, 42P02, 42P03, 42P04, 42P05, 42P06, 42P07, 42P08, 42P09, 42P10, 42P11, 42P12, 42P13, 42P14, 42P15, 42P16, 42P17, 42P18, 42P19, 42P20, 42P21, 42P22, 44000, 53000, 53100, 53200, 53300, 53400, 54000, 54001, 54011, 54023, 55000, 55006, 55P02, 55P03, 57000, 57014, 57P01, 57P02, 57P03, 57P04, 58000, 58030, 58P01, 58P02, 72000, F0000, F0001, HV000, HV001, HV002, HV004, HV005, HV006, HV007, HV008, HV009, HV00A, HV00B, HV00C, HV00D, HV00J, HV00K, HV00L, HV00M, HV00N, HV00P, HV00Q, HV00R, HV010, HV014, HV021, HV024, HV090, HV091, P0000, P0001, P0002, P0003, P0004, XX000, XX001, XX002

Additions and changes

Compared with the previous locked snapshot PostgreSQL 9.6.24, the current snapshot PostgreSQL 10.23 adds 2 values and removes 0. Added: 2200H, 428C9

Sources

Locked source: https://github.com/postgres/postgres/blob/02991e79f8f58bc208f05dcc8af0c62dbe0a6ea4/src/backend/utils/errcodes.txt