26.11.2013 01:54, Kjell Rilbe wrote:

>
> Scenario, in a single connection I do this:
>
> 1. Start transaction.
> 2. Create table.
> 3. Commit.
> 4. Start transaction.
> 5. Insert rows.
> 6. Select using join with other tables.

Handles for both INSERT and SELECT statements must be destroyed.

> 7. Commit.
> 8. Start transaction.
> 9. Drop table.
> ---> ERROR: Object is in use.

For the safety sake, ensure that your DDL transaction has the WAIT
option set (or explicit timeout is specified).


Dmitry