Feature Requests item #2160475, was opened at 2008-10-11 20:34 Message generated for change (Tracker Item Submitted) made by Item Submitter You can respond by visiting: https://sourceforge.net/tracker/?func=detail&atid=482471&aid=2160475&group_id=56967
Please note that this message will contain a full copy of the comment thread, including the initial issue submission, for this request, not just the latest update. Category: SQL - general Group: None Status: Open Priority: 5 Private: No Submitted By: Carl J. Nobile (cnobile) Assigned to: Nobody/Anonymous (nobody) Summary: Transactions Initial Comment: Neils, In connection with the bug I found where adding a column during updates then deleting caused the DB to loose track of the columns in subsequent selections, I realized that there is another issue which is maybe a feature request which is why it is here. In a sequence where a column needs to be added, as of now, one needs to commit before data can be inserted into the db. This is not optimal since adding the column is really part of the transaction and at least two transactions are needed to do what should be done in one maybe the process non-atomic. The problem also comes into view when the sys.columns view is accessed and the newly added column is not there yet. During the fix to the bug I found above could this also be fixed? I know this may not be easy, but I felt it should be stated non-the-less. -Carl ---------------------------------------------------------------------- You can respond by visiting: https://sourceforge.net/tracker/?func=detail&atid=482471&aid=2160475&group_id=56967 ------------------------------------------------------------------------- This SF.Net email is sponsored by the Moblin Your Move Developer's challenge Build the coolest Linux based applications with Moblin SDK & win great prizes Grand prize is a trip for two to an Open Source event anywhere in the world http://moblin-contest.org/redirect.php?banner_id=100&url=/ _______________________________________________ Monetdb-bugs mailing list [email protected] https://lists.sourceforge.net/lists/listinfo/monetdb-bugs
