Expand description
Types and functions related to PG’s and Sqlite’s ON CONFLICT
clause
Upsert is currently supported by diesel for the following database systems:
- PostgreSQL version 9.5 or newer
- Sqlite3 version 3.24.0 or newer
See the methods on InsertStatement
for usage examples.
Constructing an upsert statement from an existing select statement requires a where clause on sqlite due to a ambiguity in their parser. See the corresponding documentation for details.
Structs§
- A partially constructed
ON CONFLICT DO UPDATE
clause. - A partially constructed
ON CONFLICT
clause.
Traits§
- Interface to add information to conflict targets. Designed to be open for further additions to conflict targets like constraints
Functions§
- Represents
excluded.column
in anON CONFLICT DO UPDATE
clause. - Used to specify the constraint name for an upsert statement in the form
ON CONFLICT ON CONSTRAINT
. Note thatconstraint_name
must be the name of a unique constraint, not the name of an index.