| Subject | Re: [firebird-support] DDL and DML in one transaction |
|---|---|
| Author | Helen Borrie |
| Post date | 2004-10-12T06:21:08Z |
At 02:55 PM 11/10/2004 +0000, you wrote:
Apart from the multi-user issues, is the fact that metadata are stored in
regular database tables (albeit they have funny names like RDB$SPLAT). A
table definition consists of rows in a group of these system tables. Until
the surface DDL statements (the SQL commands by which the underlying
INSERTS into these tables are surfaced) are committed, the table doesn't
exist.
This is a situation where the egg has to pre-exist the chicken. :-)
./heLen
>Hi there,No.
>
>Will there be any support for lets say creating a table and
>populating it within one transaction?
Apart from the multi-user issues, is the fact that metadata are stored in
regular database tables (albeit they have funny names like RDB$SPLAT). A
table definition consists of rows in a group of these system tables. Until
the surface DDL statements (the SQL commands by which the underlying
INSERTS into these tables are surfaced) are committed, the table doesn't
exist.
This is a situation where the egg has to pre-exist the chicken. :-)
./heLen