All Products
Search
Document Center

AnalyticDB for PostgreSQL:Error Codes

Last Updated:Apr 13, 2022

Each message that is sent by the AnalyticDB for PostgreSQL server is assigned a five-character error code that follows the conventions of the SQL standard for SQLSTATE codes. This topic describes all the error codes that are defined in PostgreSQL 8.1.

Error code

Description

Class 00: successful operation.

00000

The error code returned because the operation is successful.

Class 01: warning.

01000

The error code returned to indicate a warning.

0100C

The error code returned because dynamic result sets are returned.

01008

The error code returned because the value is padded with 0-bits.

01003

The error code returned because the NULL value is eliminated in the set function.

01007

The error code returned because the required permissions are not granted.

01006

The error code returned because the specified permissions are not revoked.

01004

The error code returned because the string is truncated on the right.

01P01

The error code returned because the feature is deprecated.

Class 02: no data. This is also a warning class as per the SQL standard.

02000

The error code returned because no data is returned.

02001

The error code returned because no additional dynamic result sets are returned.

Class 03: The execution of the SQL statement is not complete.

03000

The error code returned because the execution of the SQL statement is not complete.

Class 08: connection exception.

08000

The error code returned because a connection exception occurs.

08003

The error code returned because a connection does not exist.

08006

The error code returned because a connection failure occurs.

08001

The error code returned because the SQL client fails to establish a connection.

08004

The error code returned because the SQL server rejects the request from the SQL client to establish a connection.

08007

The error code returned because the resolution for the transaction is unknown.

08P01

The error code returned because the protocol is violated.

Class 09: trigger action exception.

09000

The error code returned because an exception is thrown when an action is triggered.

Class 0A: feature not supported.

0A000

The error code returned because the feature is not supported.

Class 0B: invalid initialization of transactions.

0B000

The error code returned because the transaction initialization is invalid.

Class 0F: locator exception.

0F000

The error code returned because a locator exception occurs.

0F001

The error code returned because the locator specification is invalid.

Class 0L: invalid grantor.

0L000

The error code returned because the grantor is invalid.

0LP01

The error code returned because the grant operation is invalid.

Class 0P: invalid role specification.

0P000

The error code returned because the role specification is invalid.

Class 21: cardinality violation.

21000

The error code returned because cardinality violations occur.

Class 22: data exception.

22000

The error code returned because a data exception occurs.

2202E

The error code returned because the array subscript is invalid.

22021

The error code returned because characters are not in repertoire.

22008

The error code returned because the datetime field overflows.

22012

The error code returned because a number is divided by zero.

22005

The error code returned because an error occurs in assignment.

2200B

The error code returned because an escape character conflict occurs.

22022

The error code returned because the indicator overflows.

22015

The error code returned because an internal field overflows.

2201E

The error code returned because the logarithm operation has invalid arguments.

2201F

The error code returned because the power function has invalid arguments.

2201G

The error code returned because the WIDTH_BUCKET function has invalid arguments.

22018

The error code returned because the cast specification has invalid character values.

22007

The error code returned because the datetime format is invalid.

22019

The error code returned because the escape character is invalid.

2200D

The error code returned because the escape octet is invalid.

22025

The error code returned because the escape sequence is invalid.

22P06

The error code returned because a non-standard escape character is used.

22010

The error code returned because the indicator parameter value is invalid.

22020

The error code returned because the limit value is invalid.

22023

The error code returned because the parameter value is invalid.

2201B

The error code returned because the regular expression is invalid.

22009

The error code returned because the time zone displacement value is invalid.

2200C

The error code returned because an invalid escape character is used.

2200G

The error code returned because the most relevant types do not match.

22004

The error code returned because NULL values are not allowed.

22002

The error code returned because NULL values cannot be used for indicator parameters.

22003

The error code returned because the numeric value is out of range.

22026

The error code returned because lengths of strings do not match.

22001

The error code returned because the string is truncated on the right.

22011

The error code returned because a substring error occurs.

22027

The error code returned because a truncation error occurs.

22024

The error code returned because the C string is not terminated.

2200F

The error code returned because a zero-length character string is returned.

22P01

The error code returned because a floating point exception occurs.

22P02

The error code returned because the text representation is invalid.

22P03

The error code returned because the binary representation is invalid.

22P04

The error code returned because the copy file format is invalid.

22P05

The error code returned because untranslatable characters are found.

Class 23: integrity constraint violation.

23000

The error code returned because the integrity constraint is violated.

23001

The error code returned because the limit is violated.

23502

The error code returned because the NOT NULL rule is violated.

23503

The error code returned because the foreign key constraint is violated.

23505

The error code returned because the constraint on uniqueness is violated.

23514

The error code returned because the check constraint is violated.

Class 24: invalid cursor state.

24000

The error code returned because the cursor state is invalid.

Class 25: invalid transaction state.

25000

The error code returned because the transaction state is invalid.

25001

The error code returned because the SQL transaction is active.

25002

The error code returned because the branch transaction is active.

25008

The error code returned because the held cursors require the same isolation level.

25003

The error code returned because the access mode for the branch transaction is inappropriate.

25004

The error code returned because the isolation level for the branch transaction is inappropriate.

25005

The error code returned because the branch transaction does not have an active SQL transaction.

25006

The error code returned because the SQL transaction is read-only.

25007

The error code returned because the schema and data statement cannot be mixed.

25P01

The error code returned because no active SQL transactions exist.

25P02

The error code returned because the SQL transaction is in the failed state.

Class 26: invalid SQL statement name.

26000

The error code returned because the SQL statement name is invalid.

Class 27: triggered data change violation.

27000

The error code returned because the triggered data change violates constraints.

Class 28: invalid authorization specification.

28000

The error code returned because the authorization specification is invalid.

Class 2B: Dependent privilege descriptors still exist.

2B000

The error code returned because dependent privilege descriptors still exist.

2BP01

The error code returned because dependent objects still exist.

Class 2D: invalid transaction termination.

2D000

The error code returned because the transaction termination is invalid.

Class 2F: SQL routine exception.

2F000

The error code returned because an SQL routine exception occurs.

2F005

The error code returned because the executed function does not return statements.

2F002

The error code returned because the SQL data cannot be modified.

2F003

The error code returned because the SQL statements to be used are prohibited.

2F004

The error code returned because the SQL data cannot be read.

Class 34: invalid cursor name.

34000

The error code returned because the cursor name is invalid.

Class 38: external routine exception.

38000

The error code returned because an external routine exception occurs.

38001

The error code returned because prohibited SQL statements are contained.

38002

The error code returned because the SQL data cannot be modified.

38003

The error code returned because the SQL statements to be used are prohibited.

38004

The error code returned because the SQL data cannot be read.

Class 39: exception in external routine invocation.

39000

The error code returned because an exception occurs during external routine invocation.

39001

The error code returned because the returned SQL statement is invalid.

39004

The error code returned because NULL values are not allowed.

39P01

The error code returned because the trigger protocol is violated.

39P02

The error code returned because the SRF protocol is violated.

Class 3B: savepoint exception.

3B000

The error code returned because a savepoint exception occurs.

3B001

The error code returned because the savepoint specification is invalid.

Class 3D: invalid database name.

3D000

The error code returned because the database name is invalid.

Class 3F: invalid schema name.

3F000

The error code returned because the schema name is invalid.

Class 40: transaction rollback.

40000

The error code returned because the transaction is rolled back.

40002

The error code returned because the constraint on transaction integrity is violated.

40001

The error code returned because the serialization fails.

40003

The error code returned because whether the statement execution is complete is unknown.

40P01

The error code returned because a deadlock is detected.

Class 42: syntax error or access rule violation

42000

The error code returned because a syntax error occurs or the access rule is violated.

42601

The error code returned because a syntax error occurs.

42501

The error code returned because the required permissions are not granted.

42846

The error code returned because the data type cannot be converted.

42803

The error code returned because a grouping error occurs.

42830

The error code returned because the foreign key is invalid.

42602

The error code returned because the name is invalid.

42622

The error code returned because the length of the name exceeds the limit.

42939

The error code returned because the name is reserved.

42804

The error code returned because data types do not match.

42P18

The error code returned because the data type is indeterminate.

42809

The error code returned because the object type is invalid.

42703

The error code returned because the column is undefined.

42883

The error code returned because the function is undefined.

42P01

The error code returned because the table is undefined.

42P02

The error code returned because the parameter is undefined.

42704

The error code returned because the object is undefined.

42701

The error code returned because the column is duplicate.

42P03

The error code returned because the cursor is duplicate.

42P04

The error code returned because the database is duplicate.

42723

The error code returned because the function is duplicate.

42P05

The error code returned because the prepared statement is duplicate.

42P06

The error code returned because the schema is duplicate.

42P07

The error code returned because the table is duplicate.

42712

The error code returned because the alias is duplicate.

42710

The error code returned because the object is duplicate.

42702

The error code returned because no specific column is specified.

42725

The error code returned because no specific function is specified.

42P08

The error code returned because no specific parameter is specified.

42P09

The error code returned because no specific alias is specified.

42P10

The error code returned because the referenced column is invalid.

42611

The error code returned because the column definition is invalid.

42P11

The error code returned because the cursor definition is invalid.

42P12

The error code returned because the database definition is invalid.

42P13

The error code returned because the function definition is invalid.

42P14

The error code returned because the definition of a prepared statement is invalid.

42P15

The error code returned because the schema definition is invalid.

42P16

The error code returned because the table definition is invalid.

42P17

The error code returned because the object definition is invalid.

Class 44: WITH CHECK option violation.

44000

The error code returned because the WITH CHECK option is violated.

Class 53: insufficient resources.

53000

The error code returned because the resources are insufficient.

53100

The error code returned because the disk is full.

53200

The error code returned because the memory is exhausted.

53300

The error code returned because the number of connections exceeds the limit.

Class 54: program limit exceeded.

54000

The error code returned because the program limit is exceeded.

54001

The error code returned because the statement is complex.

54011

The error code returned because the number of columns exceeds the limit.

54023

The error code returned because the number of arguments exceeds the limit.

Class 55: object not in the required state.

55000

The error code returned because the object is not in the required state.

55006

The error code returned because the object is in use.

55P02

The error code returned because the runtime parameters cannot be modified.

55P03

The error code returned because the lock is unavailable.

Class 57: operator intervention.

57000

The error code returned because operator intervention occurs.

57014

The error code returned because the query is canceled.

57P01

The error code returned because the system is shut down by an administrator.

57P02

The error code returned because the system is shut down when a crash occurs.

57P03

The error code returned because the system cannot be connected.

Class 58: system error.

58030

The error code returned because an I/O error occurs.

58P01

The error code returned because the file is undefined.

58P02

The error code returned because the file is duplicate.

Class F0: configuration file error.

F0000

The error code returned because an error occurs in the configuration file.

F0001

The error code returned because a lock file exists.

Class P0: Procedural Language/PostgreSQL (PL/pgSQL) error.

P0000

The error code returned because a PL/pgSQL error occurs.

P0001

The error code returned because an exception is thrown.

Class XX: internal error.

XX000

The error code returned because an internal error occurs.

XX001

The error code returned because the data is corrupted.

XX002

The error code returned because the index is corrupted.