Request a Demo
23.3. Advanced
Prev UpChapter 23. Configuration ParametersHome Next

23.3. Advanced #

duckdb.convert_unsupported_numeric_to_double #

Converts NUMERIC types with unsupported precision/scale to DOUBLE instead of throwing an error.

Possible values:

  • true

  • false

DuckDB supports NUMERIC/DECIMAL with precision 1-38 and scale 0-38 (where scale ≤ precision). For NUMERICs outside these limits:

  • If true is specified, unsupported NUMERICs are converted to DOUBLE with possible precision loss.

  • If false is specified, unsupported NUMERICs cause an error.

Default value: false.

Access: All users.

duckdb.unsafe_allow_mixed_transactions #

Allows mixed transactions between DuckDB and Postgres Pro.

Important

This parameter enables transactions that modify data in both databases, but it may cause consistency issues and is not recommended for production use.

Default value: false.

Access: All users.

Prev Up Next
23.2. Resource Management Home 23.4. Storage
epub pdf