Results of 1 - 6 of about 6 for violation (0.001 sec.)
- Indexes 13014
- Index Types DuckDB has two built-in index types. Indexes can also be defined via extensions . Min-Max Index (Zonemap) A min-max index (also known as zonemap or block range index) is automatically created for columns of all general-purpose d
...et know that 2048 becomes 2049, and so forth. That is because we have not yet seen that chunk. Thus, we throw a constraint violation. CREATE TABLE my_table (i INTEGER PRIMARY KEY); INSERT INTO my_table SELECT range FROM range(3_000); UPDATE my_table SET i...n INSERT . The to-be-deleted row exists in the foreign key table. If these hold, you'll encounter an unexpected constraint violation: CREATE TABLE pk_table (id INTEGER PRIMARY KEY, payload VARCHAR[]); INSERT INTO pk_table VALUES (1, ['hello']); CREATE TAB...straint because key "id: 1" is still referenced by a foreign key in a different table. If this is an unexpected constraint violation, please refer to our foreign key limitations in the documentation The reason for this is that DuckDB does not yet support... - https://man.mtool.work/duckdb/2.0/sql/indexes.html
- Appender 9596
- Appenders are the most efficient way of loading data into DuckDB from within the C interface, and are recommended for fast data loading. The appender is much faster than using prepared statements or individual INSERT INTO statements. Append
...ush the appender to the table, forcing the cache of the appender to be cleared. If flushing the data triggers a constraint violation or any other error, then all data is invalidated, and this function returns DuckDBError. It is not possible to append more...ppender by flushing all intermediate states and closing it for further appends. If flushing the data triggers a constraint violation or any other error, then all data is invalidated, and this function returns DuckDBError. Call duckdb_appender_error_data t...troying it, this function de-allocates all memory associated with the appender. If flushing the data triggers a constraint violation, then all data is invalidated, and this function returns DuckDBError. Due to the destruction of the appender, it is no lon... - https://man.mtool.work/duckdb/2.0/clients/c/appender.html
- Import Data 8042
- Overview The Go client offers two ways to load data into DuckDB in bulk: the high-performance Appender for inserting rows generated in Go, and reading directly from data files such as Parquet, CSV, and JSON. Both are described below. For in
...mn. Call AppendRow() once per row. Warning The appender buffers rows and flushes them to DuckDB in chunks, so a constraint violation such as a NOT NULL or foreign-key failure may surface only when the buffer is flushed rather than from the AppendRow() cal... - https://man.mtool.work/duckdb/2.0/clients/go/data_import.html
- Troubleshoot 8042
- Overview This page collects common issues encountered when using the DuckDB Go client, together with their workarounds. Because the client uses cgo to embed DuckDB, most build problems are cgo or linker problems. If you run into a problem t
...eCatalog: // Handle a missing table, view, or other catalog entry. case duckdb.ErrorTypeConstraint: // Handle a constraint violation. } } } duckdb.Error.Type is a duckdb.ErrorType . Other categories include ErrorTypeBinder , ErrorTypeParser , ErrorTypeCon... - https://man.mtool.work/duckdb/2.0/clients/go/troubleshoot.html
- Troubleshooting 8042
- Troubleshooting Running EXPLAIN Renders Newlines In Python, the output of the EXPLAIN statement contains hard line breaks ( \n ): In [1]: import duckdb ...: duckdb.sql("EXPLAIN SELECT 42 AS x") Out[1]: ┌───────────────┬─────────────────────
...ortError: DLL load failed while importing duckdb: The specified module could not be found. Windows fatal exception: access violation Current thread 0x0000311c (most recent call first): File "<stdin>", line 1 in <module> Process finished with exit code -10... - https://man.mtool.work/duckdb/2.0/clients/python/known_issues.html
- Appender 8042
- The Appender can be used to load bulk data into a DuckDB database. It is available in the C, C++, Go, Java, Julia, Node.js, Python, and Rust clients. This page describes how the Appender behaves across clients and shows a minimal example in
...s flushed rather than as each row is added, so a row can be accepted but later fail at flush time. See Handling Constraint Violations . Within a row, a value must be appended for every column of the table, in column order, before the row is ended. Ending...transactions and surrounding your batches of appended rows by BEGIN TRANSACTION and COMMIT statements. Handling Constraint Violations If the Appender encounters a PRIMARY KEY conflict or a UNIQUE constraint violation, it fails and returns the following er... - https://man.mtool.work/duckdb/2.0/data/appender.html
PREV
1
NEXT
DuckDB 2.0 Documentation / man.mtool.work