/
sqlstate.scala
371 lines (327 loc) · 13.3 KB
/
sqlstate.scala
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
138
139
140
141
142
143
144
145
146
147
148
149
150
151
152
153
154
155
156
157
158
159
160
161
162
163
164
165
166
167
168
169
170
171
172
173
174
175
176
177
178
179
180
181
182
183
184
185
186
187
188
189
190
191
192
193
194
195
196
197
198
199
200
201
202
203
204
205
206
207
208
209
210
211
212
213
214
215
216
217
218
219
220
221
222
223
224
225
226
227
228
229
230
231
232
233
234
235
236
237
238
239
240
241
242
243
244
245
246
247
248
249
250
251
252
253
254
255
256
257
258
259
260
261
262
263
264
265
266
267
268
269
270
271
272
273
274
275
276
277
278
279
280
281
282
283
284
285
286
287
288
289
290
291
292
293
294
295
296
297
298
299
300
301
302
303
304
305
306
307
308
309
310
311
312
313
314
315
316
317
318
319
320
321
322
323
324
325
326
327
328
329
330
331
332
333
334
335
336
337
338
339
340
341
342
343
344
345
346
347
348
349
350
351
352
353
354
355
356
357
358
359
360
361
362
363
364
365
366
367
368
369
370
371
// Copyright (c) 2013-2018 Rob Norris and Contributors
// This software is licensed under the MIT License (MIT).
// For more information see LICENSE or https://opensource.org/licenses/MIT
package doobie.postgres
import doobie.enum.SqlState
/** Module of SQLSTATE constants for PostgreSQL. */
object sqlstate {
/** Class 00 — Successful Completion */
object class00 {
val SUCCESSFUL_COMPLETION = SqlState("00000")
}
/** Class 01 — Warning */
object class01 {
val WARNING = SqlState("01000")
val DYNAMIC_RESULT_SETS_RETURNED = SqlState("0100C")
val IMPLICIT_ZERO_BIT_PADDING = SqlState("01008")
val NULL_VALUE_ELIMINATED_IN_SET_FUNCTION = SqlState("01003")
val PRIVILEGE_NOT_GRANTED = SqlState("01007")
val PRIVILEGE_NOT_REVOKED = SqlState("01006")
val STRING_DATA_RIGHT_TRUNCATION = SqlState("01004")
val DEPRECATED_FEATURE = SqlState("01P01")
}
/** Class 02 — No Data (this is also a warning class per the SQL standard) */
object class02 {
val NO_DATA = SqlState("02000")
val NO_ADDITIONAL_DYNAMIC_RESULT_SETS_RETURNED = SqlState("02001")
}
/** Class 03 — SQL_Statement Not Yet Complete */
object class03 {
val SQL_STATEMENT_NOT_YET_COMPLETE = SqlState("03000")
}
/** Class 08 — Connection Exception */
object class08 {
val CONNECTION_EXCEPTION = SqlState("08000")
val CONNECTION_DOES_NOT_EXIST = SqlState("08003")
val CONNECTION_FAILURE = SqlState("08006")
val SQLCLIENT_UNABLE_TO_ESTABLISH_SQLCONNECTION = SqlState("08001")
val SQLSERVER_REJECTED_ESTABLISHMENT_OF_SQLCONNECTION = SqlState("08004")
val TRANSACTION_RESOLUTION_UNKNOWN = SqlState("08007")
val PROTOCOL_VIOLATION = SqlState("08P01")
}
/** Class 09 — Triggered Action Exception */
object class09 {
val TRIGGERED_ACTION_EXCEPTION = SqlState("09000")
}
/** Class 0A — Feature Not Supported */
object class0A {
val FEATURE_NOT_SUPPORTED = SqlState("0A000")
}
/** Class 0B — Invalid Transaction Initiation */
object class0B {
val INVALID_TRANSACTION_INITIATION = SqlState("0B000")
}
/** Class 0F — Locator Exception */
object class0F {
val LOCATOR_EXCEPTION = SqlState("0F000")
val INVALID_LOCATOR_SPECIFICATION = SqlState("0F001")
}
/** Class 0L — Invalid Grantor */
object class0L {
val INVALID_GRANTOR = SqlState("0L000")
val INVALID_GRANT_OPERATION = SqlState("0LP01")
}
/** Class 0P — Invalid Role Specification */
object class0P {
val INVALID_ROLE_SPECIFICATION = SqlState("0P000")
}
/** Class 20 — Case Not Found */
object class20 {
val CASE_NOT_FOUND = SqlState("20000")
}
/** Class 21 — Cardinality Violation */
object class21 {
val CARDINALITY_VIOLATION = SqlState("21000")
}
/** Class 22 — Data Exception */
object class22 {
val DATA_EXCEPTION = SqlState("22000")
val ARRAY_SUBSCRIPT_ERROR = SqlState("2202E")
val CHARACTER_NOT_IN_REPERTOIRE = SqlState("22021")
val DATETIME_FIELD_OVERFLOW = SqlState("22008")
val DIVISION_BY_ZERO = SqlState("22012")
val ERROR_IN_ASSIGNMENT = SqlState("22005")
val ESCAPE_CHARACTER_CONFLICT = SqlState("2200B")
val INDICATOR_OVERFLOW = SqlState("22022")
val INTERVAL_FIELD_OVERFLOW = SqlState("22015")
val INVALID_ARGUMENT_FOR_LOGARITHM = SqlState("2201E")
val INVALID_ARGUMENT_FOR_NTILE_FUNCTION = SqlState("22014")
val INVALID_ARGUMENT_FOR_NTH_VALUE_FUNCTION = SqlState("22016")
val INVALID_ARGUMENT_FOR_POWER_FUNCTION = SqlState("2201F")
val INVALID_ARGUMENT_FOR_WIDTH_BUCKET_FUNCTION = SqlState("2201G")
val INVALID_CHARACTER_VALUE_FOR_CAST = SqlState("22018")
val INVALID_DATETIME_FORMAT = SqlState("22007")
val INVALID_ESCAPE_CHARACTER = SqlState("22019")
val INVALID_ESCAPE_OCTET = SqlState("2200D")
val INVALID_ESCAPE_SEQUENCE = SqlState("22025")
val NONSTANDARD_USE_OF_ESCAPE_CHARACTER = SqlState("22P06")
val INVALID_INDICATOR_PARAMETER_VALUE = SqlState("22010")
val INVALID_PARAMETER_VALUE = SqlState("22023")
val INVALID_REGULAR_EXPRESSION = SqlState("2201B")
val INVALID_ROW_COUNT_IN_LIMIT_CLAUSE = SqlState("2201W")
val INVALID_ROW_COUNT_IN_RESULT_OFFSET_CLAUSE = SqlState("2201X")
val INVALID_TIME_ZONE_DISPLACEMENT_VALUE = SqlState("22009")
val INVALID_USE_OF_ESCAPE_CHARACTER = SqlState("2200C")
val MOST_SPECIFIC_TYPE_MISMATCH = SqlState("2200G")
val NULL_VALUE_NOT_ALLOWED = SqlState("22004")
val NULL_VALUE_NO_INDICATOR_PARAMETER = SqlState("22002")
val NUMERIC_VALUE_OUT_OF_RANGE = SqlState("22003")
val STRING_DATA_LENGTH_MISMATCH = SqlState("22026")
val STRING_DATA_RIGHT_TRUNCATION = SqlState("22001")
val SUBSTRING_ERROR = SqlState("22011")
val TRIM_ERROR = SqlState("22027")
val UNTERMINATED_C_STRING = SqlState("22024")
val ZERO_LENGTH_CHARACTER_STRING = SqlState("2200F")
val FLOATING_POINT_EXCEPTION = SqlState("22P01")
val INVALID_TEXT_REPRESENTATION = SqlState("22P02")
val INVALID_BINARY_REPRESENTATION = SqlState("22P03")
val BAD_COPY_FILE_FORMAT = SqlState("22P04")
val UNTRANSLATABLE_CHARACTER = SqlState("22P05")
val NOT_AN_XML_DOCUMENT = SqlState("2200L")
val INVALID_XML_DOCUMENT = SqlState("2200M")
val INVALID_XML_CONTENT = SqlState("2200N")
val INVALID_XML_COMMENT = SqlState("2200S")
val INVALID_XML_PROCESSING_INSTRUCTION = SqlState("2200T")
}
/** Class 23 — Integrity Constraint Violation */
object class23 {
val INTEGRITY_CONSTRAINT_VIOLATION = SqlState("23000")
val RESTRICT_VIOLATION = SqlState("23001")
val NOT_NULL_VIOLATION = SqlState("23502")
val FOREIGN_KEY_VIOLATION = SqlState("23503")
val UNIQUE_VIOLATION = SqlState("23505")
val CHECK_VIOLATION = SqlState("23514")
val EXCLUSION_VIOLATION = SqlState("23P01")
}
/** Class 24 — Invalid Cursor State */
object class24 {
val INVALID_CURSOR_STATE = SqlState("24000")
}
/** Class 25 — Invalid Transaction State */
object class25 {
val INVALID_TRANSACTION_STATE = SqlState("25000")
val ACTIVE_SQL_TRANSACTION = SqlState("25001")
val BRANCH_TRANSACTION_ALREADY_ACTIVE = SqlState("25002")
val HELD_CURSOR_REQUIRES_SAME_ISOLATION_LEVEL = SqlState("25008")
val INAPPROPRIATE_ACCESS_MODE_FOR_BRANCH_TRANSACTION = SqlState("25003")
val INAPPROPRIATE_ISOLATION_LEVEL_FOR_BRANCH_TRANSACTION = SqlState("25004")
val NO_ACTIVE_SQL_TRANSACTION_FOR_BRANCH_TRANSACTION = SqlState("25005")
val READ_ONLY_SQL_TRANSACTION = SqlState("25006")
val SCHEMA_AND_DATA_STATEMENT_MIXING_NOT_SUPPORTED = SqlState("25007")
val NO_ACTIVE_SQL_TRANSACTION = SqlState("25P01")
val IN_FAILED_SQL_TRANSACTION = SqlState("25P02")
}
/** Class 26 — Invalid SQL_Statement Name */
object class26 {
val INVALID_SQL_STATEMENT_NAME = SqlState("26000")
}
/** Class 27 — Triggered Data Change Violation */
object class27 {
val TRIGGERED_DATA_CHANGE_VIOLATION = SqlState("27000")
}
/** Class 28 — Invalid Authorization Specification */
object class28 {
val INVALID_AUTHORIZATION_SPECIFICATION = SqlState("28000")
val INVALID_PASSWORD = SqlState("28P01")
}
/** Class 2B — Dependent Privilege Descriptors Still Exist */
object class2B {
val DEPENDENT_PRIVILEGE_DESCRIPTORS_STILL_EXIST = SqlState("2B000")
val DEPENDENT_OBJECTS_STILL_EXIST = SqlState("2BP01")
}
/** Class 2D — Invalid Transaction Termination */
object class2D {
val INVALID_TRANSACTION_TERMINATION = SqlState("2D000")
}
/** Class 2F — SQL_Routine Exception */
object class2F {
val SQL_ROUTINE_EXCEPTION = SqlState("2F000")
val FUNCTION_EXECUTED_NO_RETURN_STATEMENT = SqlState("2F005")
val MODIFYING_SQL_DATA_NOT_PERMITTED = SqlState("2F002")
val PROHIBITED_SQL_STATEMENT_ATTEMPTED = SqlState("2F003")
val READING_SQL_DATA_NOT_PERMITTED = SqlState("2F004")
}
/** Class 34 — Invalid Cursor Name */
object class34 {
val INVALID_CURSOR_NAME = SqlState("34000")
}
/** Class 38 — External Routine Exception */
object class38 {
val EXTERNAL_ROUTINE_EXCEPTION = SqlState("38000")
val CONTAINING_SQL_NOT_PERMITTED = SqlState("38001")
val MODIFYING_SQL_DATA_NOT_PERMITTED = SqlState("38002")
val PROHIBITED_SQL_STATEMENT_ATTEMPTED = SqlState("38003")
val READING_SQL_DATA_NOT_PERMITTED = SqlState("38004")
}
/** Class 39 — External Routine Invocation Exception */
object class39 {
val EXTERNAL_ROUTINE_INVOCATION_EXCEPTION = SqlState("39000")
val INVALID_SQLSTATE_RETURNED = SqlState("39001")
val NULL_VALUE_NOT_ALLOWED = SqlState("39004")
val TRIGGER_PROTOCOL_VIOLATED = SqlState("39P01")
val SRF_PROTOCOL_VIOLATED = SqlState("39P02")
}
/** Class 3B — Savepoint Exception */
object class3B {
val SAVEPOINT_EXCEPTION = SqlState("3B000")
val INVALID_SAVEPOINT_SPECIFICATION = SqlState("3B001")
}
/** Class 3D — Invalid Catalog Name */
object class3D {
val INVALID_CATALOG_NAME = SqlState("3D000")
}
/** Class 3F — Invalid Schema Name */
object class3F {
val INVALID_SCHEMA_NAME = SqlState("3F000")
}
/** Class 40 — Transaction Rollback */
object class40 {
val TRANSACTION_ROLLBACK = SqlState("40000")
val TRANSACTION_INTEGRITY_CONSTRAINT_VIOLATION = SqlState("40002")
val SERIALIZATION_FAILURE = SqlState("40001")
val STATEMENT_COMPLETION_UNKNOWN = SqlState("40003")
val DEADLOCK_DETECTED = SqlState("40P01")
}
/** Class 42 — Syntax Error or Access Rule Violation */
object class42 {
val SYNTAX_ERROR_OR_ACCESS_RULE_VIOLATION = SqlState("42000")
val SYNTAX_ERROR = SqlState("42601")
val INSUFFICIENT_PRIVILEGE = SqlState("42501")
val CANNOT_COERCE = SqlState("42846")
val GROUPING_ERROR = SqlState("42803")
val WINDOWING_ERROR = SqlState("42P20")
val INVALID_RECURSION = SqlState("42P19")
val INVALID_FOREIGN_KEY = SqlState("42830")
val INVALID_NAME = SqlState("42602")
val NAME_TOO_LONG = SqlState("42622")
val RESERVED_NAME = SqlState("42939")
val DATATYPE_MISMATCH = SqlState("42804")
val INDETERMINATE_DATATYPE = SqlState("42P18")
val WRONG_OBJECT_TYPE = SqlState("42809")
val UNDEFINED_COLUMN = SqlState("42703")
val UNDEFINED_FUNCTION = SqlState("42883")
val UNDEFINED_TABLE = SqlState("42P01")
val UNDEFINED_PARAMETER = SqlState("42P02")
val UNDEFINED_OBJECT = SqlState("42704")
val DUPLICATE_COLUMN = SqlState("42701")
val DUPLICATE_CURSOR = SqlState("42P03")
val DUPLICATE_DATABASE = SqlState("42P04")
val DUPLICATE_FUNCTION = SqlState("42723")
val DUPLICATE_PREPARED_STATEMENT = SqlState("42P05")
val DUPLICATE_SCHEMA = SqlState("42P06")
val DUPLICATE_TABLE = SqlState("42P07")
val DUPLICATE_ALIAS = SqlState("42712")
val DUPLICATE_OBJECT = SqlState("42710")
val AMBIGUOUS_COLUMN = SqlState("42702")
val AMBIGUOUS_FUNCTION = SqlState("42725")
val AMBIGUOUS_PARAMETER = SqlState("42P08")
val AMBIGUOUS_ALIAS = SqlState("42P09")
val INVALID_COLUMN_REFERENCE = SqlState("42P10")
val INVALID_COLUMN_DEFINITION = SqlState("42611")
val INVALID_CURSOR_DEFINITION = SqlState("42P11")
val INVALID_DATABASE_DEFINITION = SqlState("42P12")
val INVALID_FUNCTION_DEFINITION = SqlState("42P13")
val INVALID_PREPARED_STATEMENT_DEFINITION = SqlState("42P14")
val INVALID_SCHEMA_DEFINITION = SqlState("42P15")
val INVALID_TABLE_DEFINITION = SqlState("42P16")
val INVALID_OBJECT_DEFINITION = SqlState("42P17")
}
/** Class 44 — WITH_CHECK_OPTION_Violation */
object class44 {
val WITH_CHECK_OPTION_VIOLATION = SqlState("44000")
}
/** Class 53 — Insufficient Resources */
object class53 {
val INSUFFICIENT_RESOURCES = SqlState("53000")
val DISK_FULL = SqlState("53100")
val OUT_OF_MEMORY = SqlState("53200")
val TOO_MANY_CONNECTIONS = SqlState("53300")
}
/** Class 54 — Program Limit Exceeded */
object class54 {
val PROGRAM_LIMIT_EXCEEDED = SqlState("54000")
val STATEMENT_TOO_COMPLEX = SqlState("54001")
val TOO_MANY_COLUMNS = SqlState("54011")
val TOO_MANY_ARGUMENTS = SqlState("54023")
}
/** Class 55 — Object Not In Prerequisite State */
object class55 {
val OBJECT_NOT_IN_PREREQUISITE_STATE = SqlState("55000")
val OBJECT_IN_USE = SqlState("55006")
val CANT_CHANGE_RUNTIME_PARAM = SqlState("55P02")
val LOCK_NOT_AVAILABLE = SqlState("55P03")
}
/** Class 57 — Operator Intervention */
object class57 {
val OPERATOR_INTERVENTION = SqlState("57000")
val QUERY_CANCELED = SqlState("57014")
val ADMIN_SHUTDOWN = SqlState("57P01")
val CRASH_SHUTDOWN = SqlState("57P02")
val CANNOT_CONNECT_NOW = SqlState("57P03")
val DATABASE_DROPPED = SqlState("57P04")
}
/** Class 58 — System Error (errors external to PostgreSQL itself) */
object class58 {
val IO_ERROR = SqlState("58030")
val UNDEFINED_FILE = SqlState("58P01")
val DUPLICATE_FILE = SqlState("58P02")
}
/** Class F0 — Configuration File Error */
object classF0 {
val CONFIG_FILE_ERROR = SqlState("F0000")
val LOCK_FILE_EXISTS = SqlState("F0001")
}
/** Class P0 — PL/pgSQL_Error */
object classP0 {
val PLPGSQL_ERROR = SqlState("P0000")
val RAISE_EXCEPTION = SqlState("P0001")
val NO_DATA_FOUND = SqlState("P0002")
val TOO_MANY_ROWS = SqlState("P0003")
}
/** Class XX — Internal Error */
object classXX {
val INTERNAL_ERROR = SqlState("XX000")
val DATA_CORRUPTED = SqlState("XX001")
val INDEX_CORRUPTED = SqlState("XX002")
}
}