else: # place rows in temp table

        assert isinstance(into, sql_gen.Table)

        kw_args['recover'] = True

        kw_args.setdefault('log_ignore_excs', (DuplicateTableException,))

        temp = not db.autocommit # tables are permanent in autocommit mode

        # "temporary tables cannot specify a schema name", so remove schema

        if temp: into.schema = None

        # Create table

        while True:

            create_query = 'CREATE'

            if temp: create_query += ' TEMP'

            create_query += ' TABLE '+into.to_str(db)+' AS\n'+query

            try:

                cur = run_query(db, create_query, **kw_args)

                    # CREATE TABLE AS sets rowcount to # rows in query

                break

            except DuplicateTableException, e:

                into.name = next_version(into.name)

                # try again with next version of name

        if add_indexes_: add_indexes(db, into)

        return cur