Em 16/01/2017 18:58, Dimitry Sibiryakov escreveu: > 16.01.2017 21:52, Adriano dos Santos Fernandes wrote: >> It wasn't in my requirements, but it would be possible. >> >> create table ... >> as >> select ... >> >> Would run the select and fill the table at commit time. > > Oh, then I misread your suggestion. I read it as "let's create > table/view/sp in memory > virtually and let user interact with it as it was real, then validate all > changes on > commit and drop them into real database". If you had on mind something > different, I'm sorry. >
What you seem to try to fix (mix DML changed in uncommitted tables) is a no-go. It would never work even in single thread considering prepared statement that may be prepared in one transaction and used in another. The semantics of this is even unthinkable, and I doubt anyone is doing it in database world. Adriano ------------------------------------------------------------------------------ Check out the vibrant tech community on one of the world's most engaging tech sites, SlashDot.org! http://sdm.link/slashdot Firebird-Devel mailing list, web interface at https://lists.sourceforge.net/lists/listinfo/firebird-devel