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