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

Thanks! Please see my reply to Alan McDonald.

Kjell

-- 
--------------------------------------
Kjell Rilbe
DataDIA AB
E-post: kjell@...
Telefon: 08-761 06 55
Mobil: 0733-44 24 64