Revision 2146
Added by Aaron Marcuse-Kubitza about 12 years ago
| lib/sql.py | ||
|---|---|---|
| 315 | 315 |
if into == None: return run_query(db, query, params, *args, **kw_args) |
| 316 | 316 |
else: # place rows in temp table |
| 317 | 317 |
check_name(into) |
| 318 |
|
|
| 319 |
run_query(db, 'DROP TABLE IF EXISTS '+into+' CASCADE', *args, **kw_args) |
|
| 320 | 318 |
return run_query(db, 'CREATE TEMP TABLE '+into+' AS '+query, params, |
| 321 | 319 |
*args, **kw_args) # CREATE TABLE sets rowcount to # rows in query |
| 322 | 320 |
|
Also available in: Unified diff
sql.py: run_query_into(): Removed "DROP TABLE IF EXISTS" because sometimes when there are collisions in the temp table names, the code actually uses both "copies" of the temp table. Eventually, this situation will be resolved by adding a counter to the temp table name.