Ah. That explains it. Thanks.
Out of curiosity, why does the transaction get marked as aborted? I
only ask since others
(e.g. Oracle) don't have this behavior.
Greg
Peter Mount wrote:
> Dropping a non-existent table should throw an exception as well as mark any
> open transaction as aborted.
>
> I'd say either:
>
> * using autoCommit while checking for existing tables.
> * commit and begin a new transaction afterwards.
> * Use temporary tables, so the table doesn't survive the connection.
>
> Peter
>