Re: [Firebird-devel] Metadata without Commitment

[Paul R. <pn...@ja...>]

> Alex Peshkov wrote:
>
> >
> > And what about 'DROP TABLE/VIEW'? Dropped relation will be found in
> > the transaction, which issued this command. May be 2 lists of pending
> > relations - new and dropped? And before return check, has not given
> > relation got in the second list. Certainly, it will be necessary to
> > add relations to this list from drop_relation() code.
>
> You're right -- there certainly is a problem there.  Tables can be added
> then dropped then added and dropping.  Looks like I have more
> book-keeping to do.  Sigh.

To date, I haven't found the time to investigate how other database systems
implement temporary tables. However, it would seem to me that the above code
can be usefully re-used to implement temporary tables for Firebird --
assuming the mechanism allows for mixing DDL and DML.

Also, it seems to me that on the topic of "metadating without commitment" we
are on the downward complexity slope. I believe it was Benjamin Franklin who
once said "I wouldn't give anything for simplicity before complexity, but I
would give anything for simplicity after complexity". Wise words.

Paul Ruizendaal