> Hello All,
>
> I posted this message yesterday but I wasn't sure that it went through.
> So I'm sending it again. Sorry if it is a dup.
>
> I've just started using Firebird and it looks good. However, I'm
> having some problems with table creation in a transaction.
>
> The following script fails with the error:
>
> kinterbasdb.ProgrammingError: (-204, 'execute.isc_dsql_prepare:
> Dynamic SQL
> Error. SQL error code = -204. Table unknown. TEST. At line 1,
> column 15..')
>
> However, if I commit the transaction after creating the table
> everything works
> as expected. I was unable to find a documented reason for this
> behaviour.
>
> Any help would be greatly appreciated.
>
> Thanks,
>
> Chaitan.
>

this was answered - check the messages. It's not a bug - you must commit
metadata before anyone can use it. It's well documented.
Alan