Table of Contents

Class PostgresErrorCodes

Namespace
Npgsql
Assembly
Npgsql.dll

Provides constants for PostgreSQL error codes.

public static class PostgresErrorCodes
Inheritance
PostgresErrorCodes
Inherited Members

Remarks

Fields

ActiveSqlTransaction

public const string ActiveSqlTransaction = "25001"

Field Value

string

AdminShutdown

public const string AdminShutdown = "57P01"

Field Value

string

AmbiguousAlias

public const string AmbiguousAlias = "42P09"

Field Value

string

AmbiguousColumn

public const string AmbiguousColumn = "42702"

Field Value

string

AmbiguousFunction

public const string AmbiguousFunction = "42725"

Field Value

string

AmbiguousParameter

public const string AmbiguousParameter = "42P08"

Field Value

string

ArraySubscriptError

public const string ArraySubscriptError = "2202E"

Field Value

string

AssertFailure

public const string AssertFailure = "P0004"

Field Value

string

BadCopyFileFormat

public const string BadCopyFileFormat = "22P04"

Field Value

string

BranchTransactionAlreadyActive

public const string BranchTransactionAlreadyActive = "25002"

Field Value

string

CannotCoerce

public const string CannotCoerce = "42846"

Field Value

string

CannotConnectNow

public const string CannotConnectNow = "57P03"

Field Value

string

CantChangeRuntimeParam

public const string CantChangeRuntimeParam = "55P02"

Field Value

string

CardinalityViolation

public const string CardinalityViolation = "21000"

Field Value

string

CaseNotFound

public const string CaseNotFound = "20000"

Field Value

string

CharacterNotInRepertoire

public const string CharacterNotInRepertoire = "22021"

Field Value

string

CheckViolation

public const string CheckViolation = "23514"

Field Value

string

CollationMismatch

public const string CollationMismatch = "42P21"

Field Value

string

ConfigFileError

public const string ConfigFileError = "F0000"

Field Value

string

ConfigurationLimitExceeded

public const string ConfigurationLimitExceeded = "53400"

Field Value

string

ConnectionDoesNotExist

public const string ConnectionDoesNotExist = "08003"

Field Value

string

ConnectionException

public const string ConnectionException = "08000"

Field Value

string

ConnectionFailure

public const string ConnectionFailure = "08006"

Field Value

string

ContainingSqlNotPermittedExternalRoutineException

public const string ContainingSqlNotPermittedExternalRoutineException = "38001"

Field Value

string

CrashShutdown

public const string CrashShutdown = "57P02"

Field Value

string

DataCorrupted

public const string DataCorrupted = "XX001"

Field Value

string

DataException

public const string DataException = "22000"

Field Value

string

DatabaseDropped

public const string DatabaseDropped = "57P04"

Field Value

string

DatatypeMismatch

public const string DatatypeMismatch = "42804"

Field Value

string

DatetimeFieldOverflow

public const string DatetimeFieldOverflow = "22008"

Field Value

string

DeadlockDetected

public const string DeadlockDetected = "40P01"

Field Value

string

DependentObjectsStillExist

public const string DependentObjectsStillExist = "2BP01"

Field Value

string

DependentPrivilegeDescriptorsStillExist

public const string DependentPrivilegeDescriptorsStillExist = "2B000"

Field Value

string

DeprecatedFeatureWarning

public const string DeprecatedFeatureWarning = "01P01"

Field Value

string

DiagnosticsException

public const string DiagnosticsException = "0Z000"

Field Value

string

DiskFull

public const string DiskFull = "53100"

Field Value

string

DivisionByZero

public const string DivisionByZero = "22012"

Field Value

string

DuplicateAlias

public const string DuplicateAlias = "42712"

Field Value

string

DuplicateColumn

public const string DuplicateColumn = "42701"

Field Value

string

DuplicateCursor

public const string DuplicateCursor = "42P03"

Field Value

string

DuplicateDatabase

public const string DuplicateDatabase = "42P04"

Field Value

string

DuplicateFile

public const string DuplicateFile = "58P02"

Field Value

string

DuplicateFunction

public const string DuplicateFunction = "42723"

Field Value

string

DuplicateObject

public const string DuplicateObject = "42710"

Field Value

string

DuplicatePreparedStatement

public const string DuplicatePreparedStatement = "42P05"

Field Value

string

DuplicateSchema

public const string DuplicateSchema = "42P06"

Field Value

string

DuplicateTable

public const string DuplicateTable = "42P07"

Field Value

string

DynamicResultSetsReturnedWarning

public const string DynamicResultSetsReturnedWarning = "0100C"

Field Value

string

ErrorInAssignment

public const string ErrorInAssignment = "22005"

Field Value

string

EscapeCharacterConflict

public const string EscapeCharacterConflict = "2200B"

Field Value

string

EventTriggerProtocolViolatedExternalRoutineInvocationException

public const string EventTriggerProtocolViolatedExternalRoutineInvocationException = "39P03"

Field Value

string

ExclusionViolation

public const string ExclusionViolation = "23P01"

Field Value

string

ExternalRoutineException

public const string ExternalRoutineException = "38000"

Field Value

string

ExternalRoutineInvocationException

public const string ExternalRoutineInvocationException = "39000"

Field Value

string

FdwColumnNameNotFound

public const string FdwColumnNameNotFound = "HV005"

Field Value

string

FdwDynamicParameterValueNeeded

public const string FdwDynamicParameterValueNeeded = "HV002"

Field Value

string

FdwError

public const string FdwError = "HV000"

Field Value

string

FdwFunctionSequenceError

public const string FdwFunctionSequenceError = "HV010"

Field Value

string

FdwInconsistentDescriptorInformation

public const string FdwInconsistentDescriptorInformation = "HV021"

Field Value

string

FdwInvalidAttributeValue

public const string FdwInvalidAttributeValue = "HV024"

Field Value

string

FdwInvalidColumnName

public const string FdwInvalidColumnName = "HV007"

Field Value

string

FdwInvalidColumnNumber

public const string FdwInvalidColumnNumber = "HV008"

Field Value

string

FdwInvalidDataType

public const string FdwInvalidDataType = "HV004"

Field Value

string

FdwInvalidDataTypeDescriptors

public const string FdwInvalidDataTypeDescriptors = "HV006"

Field Value

string

FdwInvalidDescriptorFieldIdentifier

public const string FdwInvalidDescriptorFieldIdentifier = "HV091"

Field Value

string

FdwInvalidHandle

public const string FdwInvalidHandle = "HV00B"

Field Value

string

FdwInvalidOptionIndex

public const string FdwInvalidOptionIndex = "HV00C"

Field Value

string

FdwInvalidOptionName

public const string FdwInvalidOptionName = "HV00D"

Field Value

string

FdwInvalidStringFormat

public const string FdwInvalidStringFormat = "HV00A"

Field Value

string

FdwInvalidStringLengthOrBufferLength

public const string FdwInvalidStringLengthOrBufferLength = "HV090"

Field Value

string

FdwInvalidUseOfNullPointer

public const string FdwInvalidUseOfNullPointer = "HV009"

Field Value

string

FdwNoSchemas

public const string FdwNoSchemas = "HV00P"

Field Value

string

FdwOptionNameNotFound

public const string FdwOptionNameNotFound = "HV00J"

Field Value

string

FdwOutOfMemory

public const string FdwOutOfMemory = "HV001"

Field Value

string

FdwReplyHandle

public const string FdwReplyHandle = "HV00K"

Field Value

string

FdwSchemaNotFound

public const string FdwSchemaNotFound = "HV00Q"

Field Value

string

FdwTableNotFound

public const string FdwTableNotFound = "HV00R"

Field Value

string

FdwTooManyHandles

public const string FdwTooManyHandles = "HV014"

Field Value

string

FdwUnableToCreateExecution

public const string FdwUnableToCreateExecution = "HV00L"

Field Value

string

FdwUnableToCreateReply

public const string FdwUnableToCreateReply = "HV00M"

Field Value

string

FdwUnableToEstablishConnection

public const string FdwUnableToEstablishConnection = "HV00N"

Field Value

string

FeatureNotSupported

public const string FeatureNotSupported = "0A000"

Field Value

string

FloatingPointException

public const string FloatingPointException = "22P01"

Field Value

string

ForeignKeyViolation

public const string ForeignKeyViolation = "23503"

Field Value

string

FunctionExecutedNoReturnStatementSqlRoutineException

public const string FunctionExecutedNoReturnStatementSqlRoutineException = "2F005"

Field Value

string

GroupingError

public const string GroupingError = "42803"

Field Value

string

HeldCursorRequiresSameIsolationLevel

public const string HeldCursorRequiresSameIsolationLevel = "25008"

Field Value

string

IdleSessionTimeout

public const string IdleSessionTimeout = "57P05"

Field Value

string

ImplicitZeroBitPaddingWarning

public const string ImplicitZeroBitPaddingWarning = "01008"

Field Value

string

InFailedSqlTransaction

public const string InFailedSqlTransaction = "25P02"

Field Value

string

InappropriateAccessModeForBranchTransaction

public const string InappropriateAccessModeForBranchTransaction = "25003"

Field Value

string

InappropriateIsolationLevelForBranchTransaction

public const string InappropriateIsolationLevelForBranchTransaction = "25004"

Field Value

string

IndeterminateCollation

public const string IndeterminateCollation = "42P22"

Field Value

string

IndeterminateDatatype

public const string IndeterminateDatatype = "42P18"

Field Value

string

IndexCorrupted

public const string IndexCorrupted = "XX002"

Field Value

string

IndicatorOverflow

public const string IndicatorOverflow = "22022"

Field Value

string

InsufficientPrivilege

public const string InsufficientPrivilege = "42501"

Field Value

string

InsufficientResources

public const string InsufficientResources = "53000"

Field Value

string

IntegrityConstraintViolation

public const string IntegrityConstraintViolation = "23000"

Field Value

string

InternalError

public const string InternalError = "XX000"

Field Value

string

IntervalFieldOverflow

public const string IntervalFieldOverflow = "22015"

Field Value

string

InvalidArgumentForLogarithm

public const string InvalidArgumentForLogarithm = "2201E"

Field Value

string

InvalidArgumentForNthValueFunction

public const string InvalidArgumentForNthValueFunction = "22016"

Field Value

string

InvalidArgumentForNtileFunction

public const string InvalidArgumentForNtileFunction = "22014"

Field Value

string

InvalidArgumentForPowerFunction

public const string InvalidArgumentForPowerFunction = "2201F"

Field Value

string

InvalidArgumentForWidthBucketFunction

public const string InvalidArgumentForWidthBucketFunction = "2201G"

Field Value

string

InvalidAuthorizationSpecification

public const string InvalidAuthorizationSpecification = "28000"

Field Value

string

InvalidBinaryRepresentation

public const string InvalidBinaryRepresentation = "22P03"

Field Value

string

InvalidCatalogName

public const string InvalidCatalogName = "3D000"

Field Value

string

InvalidCharacterValueForCast

public const string InvalidCharacterValueForCast = "22018"

Field Value

string

InvalidColumnDefinition

public const string InvalidColumnDefinition = "42611"

Field Value

string

InvalidColumnReference

public const string InvalidColumnReference = "42P10"

Field Value

string

InvalidCursorDefinition

public const string InvalidCursorDefinition = "42P11"

Field Value

string

InvalidCursorName

public const string InvalidCursorName = "34000"

Field Value

string

InvalidCursorState

public const string InvalidCursorState = "24000"

Field Value

string

InvalidDatabaseDefinition

public const string InvalidDatabaseDefinition = "42P12"

Field Value

string

InvalidDatetimeFormat

public const string InvalidDatetimeFormat = "22007"

Field Value

string

InvalidEscapeCharacter

public const string InvalidEscapeCharacter = "22019"

Field Value

string

InvalidEscapeOctet

public const string InvalidEscapeOctet = "2200D"

Field Value

string

InvalidEscapeSequence

public const string InvalidEscapeSequence = "22025"

Field Value

string

InvalidForeignKey

public const string InvalidForeignKey = "42830"

Field Value

string

InvalidFunctionDefinition

public const string InvalidFunctionDefinition = "42P13"

Field Value

string

InvalidGrantOperation

public const string InvalidGrantOperation = "0LP01"

Field Value

string

InvalidGrantor

public const string InvalidGrantor = "0L000"

Field Value

string

InvalidIndicatorParameterValue

public const string InvalidIndicatorParameterValue = "22010"

Field Value

string

InvalidLocatorSpecification

public const string InvalidLocatorSpecification = "0F001"

Field Value

string

InvalidName

public const string InvalidName = "42602"

Field Value

string

InvalidObjectDefinition

public const string InvalidObjectDefinition = "42P17"

Field Value

string

InvalidParameterValue

public const string InvalidParameterValue = "22023"

Field Value

string

InvalidPassword

public const string InvalidPassword = "28P01"

Field Value

string

InvalidPreparedStatementDefinition

public const string InvalidPreparedStatementDefinition = "42P14"

Field Value

string

InvalidRecursion

public const string InvalidRecursion = "42P19"

Field Value

string

InvalidRegularExpression

public const string InvalidRegularExpression = "2201B"

Field Value

string

InvalidRoleSpecification

public const string InvalidRoleSpecification = "0P000"

Field Value

string

InvalidRowCountInLimitClause

public const string InvalidRowCountInLimitClause = "2201W"

Field Value

string

InvalidRowCountInResultOffsetClause

public const string InvalidRowCountInResultOffsetClause = "2201X"

Field Value

string

InvalidSavepointSpecification

public const string InvalidSavepointSpecification = "3B001"

Field Value

string

InvalidSchemaDefinition

public const string InvalidSchemaDefinition = "42P15"

Field Value

string

InvalidSchemaName

public const string InvalidSchemaName = "3F000"

Field Value

string

InvalidSqlStatementName

public const string InvalidSqlStatementName = "26000"

Field Value

string

InvalidSqlstateReturnedExternalRoutineInvocationException

public const string InvalidSqlstateReturnedExternalRoutineInvocationException = "39001"

Field Value

string

InvalidTableDefinition

public const string InvalidTableDefinition = "42P16"

Field Value

string

InvalidTablesampleArgument

public const string InvalidTablesampleArgument = "2202H"

Field Value

string

InvalidTablesampleRepeat

public const string InvalidTablesampleRepeat = "2202G"

Field Value

string

InvalidTextRepresentation

public const string InvalidTextRepresentation = "22P02"

Field Value

string

InvalidTimeZoneDisplacementValue

public const string InvalidTimeZoneDisplacementValue = "22009"

Field Value

string

InvalidTransactionInitiation

public const string InvalidTransactionInitiation = "0B000"

Field Value

string

InvalidTransactionState

public const string InvalidTransactionState = "25000"

Field Value

string

InvalidTransactionTermination

public const string InvalidTransactionTermination = "2D000"

Field Value

string

InvalidUseOfEscapeCharacter

public const string InvalidUseOfEscapeCharacter = "2200C"

Field Value

string

InvalidXmlComment

public const string InvalidXmlComment = "2200S"

Field Value

string

InvalidXmlContent

public const string InvalidXmlContent = "2200N"

Field Value

string

InvalidXmlDocument

public const string InvalidXmlDocument = "2200M"

Field Value

string

InvalidXmlProcessingInstruction

public const string InvalidXmlProcessingInstruction = "2200T"

Field Value

string

IoError

public const string IoError = "58030"

Field Value

string

LocatorException

public const string LocatorException = "0F000"

Field Value

string

LockFileExists

public const string LockFileExists = "F0001"

Field Value

string

LockNotAvailable

public const string LockNotAvailable = "55P03"

Field Value

string

ModifyingSqlDataNotPermittedExternalRoutineException

public const string ModifyingSqlDataNotPermittedExternalRoutineException = "38002"

Field Value

string

ModifyingSqlDataNotPermittedSqlRoutineException

public const string ModifyingSqlDataNotPermittedSqlRoutineException = "2F002"

Field Value

string

MostSpecificTypeMismatch

public const string MostSpecificTypeMismatch = "2200G"

Field Value

string

NameTooLong

public const string NameTooLong = "42622"

Field Value

string

NoActiveSqlTransaction

public const string NoActiveSqlTransaction = "25P01"

Field Value

string

NoActiveSqlTransactionForBranchTransaction

public const string NoActiveSqlTransactionForBranchTransaction = "25005"

Field Value

string

NoAdditionalDynamicResultSetsReturned

public const string NoAdditionalDynamicResultSetsReturned = "02001"

Field Value

string

NoData

public const string NoData = "02000"

Field Value

string

NoDataFound

public const string NoDataFound = "P0002"

Field Value

string

NonstandardUseOfEscapeCharacter

public const string NonstandardUseOfEscapeCharacter = "22P06"

Field Value

string

NotAnXmlDocument

public const string NotAnXmlDocument = "2200L"

Field Value

string

NotNullViolation

public const string NotNullViolation = "23502"

Field Value

string

NullValueEliminatedInSetFunctionWarning

public const string NullValueEliminatedInSetFunctionWarning = "01003"

Field Value

string

NullValueNoIndicatorParameter

public const string NullValueNoIndicatorParameter = "22002"

Field Value

string

NullValueNotAllowed

public const string NullValueNotAllowed = "22004"

Field Value

string

NullValueNotAllowedExternalRoutineInvocationException

public const string NullValueNotAllowedExternalRoutineInvocationException = "39004"

Field Value

string

NumericValueOutOfRange

public const string NumericValueOutOfRange = "22003"

Field Value

string

ObjectInUse

public const string ObjectInUse = "55006"

Field Value

string

ObjectNotInPrerequisiteState

public const string ObjectNotInPrerequisiteState = "55000"

Field Value

string

OperatorIntervention

public const string OperatorIntervention = "57000"

Field Value

string

OutOfMemory

public const string OutOfMemory = "53200"

Field Value

string

PlpgsqlError

public const string PlpgsqlError = "P0000"

Field Value

string

PrivilegeNotGrantedWarning

public const string PrivilegeNotGrantedWarning = "01007"

Field Value

string

PrivilegeNotRevokedWarning

public const string PrivilegeNotRevokedWarning = "01006"

Field Value

string

ProgramLimitExceeded

public const string ProgramLimitExceeded = "54000"

Field Value

string

ProhibitedSqlStatementAttemptedExternalRoutineException

public const string ProhibitedSqlStatementAttemptedExternalRoutineException = "38003"

Field Value

string

ProhibitedSqlStatementAttemptedSqlRoutineException

public const string ProhibitedSqlStatementAttemptedSqlRoutineException = "2F003"

Field Value

string

ProtocolViolation

public const string ProtocolViolation = "08P01"

Field Value

string

QueryCanceled

public const string QueryCanceled = "57014"

Field Value

string

RaiseException

public const string RaiseException = "P0001"

Field Value

string

ReadOnlySqlTransaction

public const string ReadOnlySqlTransaction = "25006"

Field Value

string

ReadingSqlDataNotPermittedExternalRoutineException

public const string ReadingSqlDataNotPermittedExternalRoutineException = "38004"

Field Value

string

ReadingSqlDataNotPermittedSqlRoutineException

public const string ReadingSqlDataNotPermittedSqlRoutineException = "2F004"

Field Value

string

ReservedName

public const string ReservedName = "42939"

Field Value

string

RestrictViolation

public const string RestrictViolation = "23001"

Field Value

string

SavepointException

public const string SavepointException = "3B000"

Field Value

string

SchemaAndDataStatementMixingNotSupported

public const string SchemaAndDataStatementMixingNotSupported = "25007"

Field Value

string

SerializationFailure

public const string SerializationFailure = "40001"

Field Value

string

SnapshotFailure

public const string SnapshotFailure = "72000"

Field Value

string

SqlClientUnableToEstablishSqlConnection

public const string SqlClientUnableToEstablishSqlConnection = "08001"

Field Value

string

SqlRoutineException

public const string SqlRoutineException = "2F000"

Field Value

string

SqlServerRejectedEstablishmentOfSqlConnection

public const string SqlServerRejectedEstablishmentOfSqlConnection = "08004"

Field Value

string

SqlStatementNotYetComplete

public const string SqlStatementNotYetComplete = "03000"

Field Value

string

SrfProtocolViolatedExternalRoutineInvocationException

public const string SrfProtocolViolatedExternalRoutineInvocationException = "39P02"

Field Value

string

StackedDiagnosticsAccessedWithoutActiveHandler

public const string StackedDiagnosticsAccessedWithoutActiveHandler = "0Z002"

Field Value

string

StatementCompletionUnknown

public const string StatementCompletionUnknown = "40003"

Field Value

string

StatementTooComplex

public const string StatementTooComplex = "54001"

Field Value

string

StringDataLengthMismatch

public const string StringDataLengthMismatch = "22026"

Field Value

string

StringDataRightTruncation

public const string StringDataRightTruncation = "22001"

Field Value

string

StringDataRightTruncationWarning

public const string StringDataRightTruncationWarning = "01004"

Field Value

string

SubstringError

public const string SubstringError = "22011"

Field Value

string

SuccessfulCompletion

public const string SuccessfulCompletion = "00000"

Field Value

string

SyntaxError

public const string SyntaxError = "42601"

Field Value

string

SyntaxErrorOrAccessRuleViolation

public const string SyntaxErrorOrAccessRuleViolation = "42000"

Field Value

string

SystemError

public const string SystemError = "58000"

Field Value

string

TooManyArguments

public const string TooManyArguments = "54023"

Field Value

string

TooManyColumns

public const string TooManyColumns = "54011"

Field Value

string

TooManyConnections

public const string TooManyConnections = "53300"

Field Value

string

TooManyRows

public const string TooManyRows = "P0003"

Field Value

string

TransactionIntegrityConstraintViolation

public const string TransactionIntegrityConstraintViolation = "40002"

Field Value

string

TransactionResolutionUnknown

public const string TransactionResolutionUnknown = "08007"

Field Value

string

TransactionRollback

public const string TransactionRollback = "40000"

Field Value

string

TriggerProtocolViolatedExternalRoutineInvocationException

public const string TriggerProtocolViolatedExternalRoutineInvocationException = "39P01"

Field Value

string

TriggeredActionException

public const string TriggeredActionException = "09000"

Field Value

string

TriggeredDataChangeViolation

public const string TriggeredDataChangeViolation = "27000"

Field Value

string

TrimError

public const string TrimError = "22027"

Field Value

string

UndefinedColumn

public const string UndefinedColumn = "42703"

Field Value

string

UndefinedFile

public const string UndefinedFile = "58P01"

Field Value

string

UndefinedFunction

public const string UndefinedFunction = "42883"

Field Value

string

UndefinedObject

public const string UndefinedObject = "42704"

Field Value

string

UndefinedParameter

public const string UndefinedParameter = "42P02"

Field Value

string

UndefinedTable

public const string UndefinedTable = "42P01"

Field Value

string

UniqueViolation

public const string UniqueViolation = "23505"

Field Value

string

UnterminatedCString

public const string UnterminatedCString = "22024"

Field Value

string

UntranslatableCharacter

public const string UntranslatableCharacter = "22P05"

Field Value

string

Warning

public const string Warning = "01000"

Field Value

string

WindowingError

public const string WindowingError = "42P20"

Field Value

string

WithCheckOptionViolation

public const string WithCheckOptionViolation = "44000"

Field Value

string

WrongObjectType

public const string WrongObjectType = "42809"

Field Value

string

ZeroLengthCharacterString

public const string ZeroLengthCharacterString = "2200F"

Field Value

string