Revision 7392
Added by Aaron Marcuse-Kubitza about 12 years ago
| lib/sql_io.py | ||
|---|---|---|
| 342 | 342 |
'''Recovers from errors. |
| 343 | 343 |
Only works under PostgreSQL (uses INSERT RETURNING). |
| 344 | 344 |
IMPORTANT: Must be run at the *beginning* of a transaction. |
| 345 |
|
|
| 346 |
Warning: This function's insert/if not exists get algorithm does not support |
|
| 347 |
database triggers that populate fields covered by a unique constraint. Such |
|
| 348 |
fields must be populated by the mappings instead. (Other fields are not |
|
| 349 |
affected by this restriction on triggers.) |
|
| 345 | 350 |
@param in_tables The main input table to select from, followed by a list of |
| 346 | 351 |
tables to join with it using the main input table's pkey |
| 347 | 352 |
@param mapping dict(out_table_col=in_table_col, ...) |
Also available in: Unified diff
sql_io.py: put_table(): Documented that the function's insert/if not exists get algorithm does not support database triggers that populate fields covered by a unique constraint