Subject Re: [firebird-support] Table creation in transaction
Author Dan Wilson
> 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.

It is my understanding that all metadata changes must be committed before you can make use of those changes in DML.