Feature Requests item #2160624, was opened at 2008-10-12 03:23 Message generated for change (Settings changed) made by nielsnes You can respond by visiting: https://sourceforge.net/tracker/?func=detail&atid=482471&aid=2160624&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: Closed Priority: 5 Private: No Submitted By: Carl J. Nobile (cnobile) Assigned to: Niels Nes (nielsnes) 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 ---------------------------------------------------------------------- >Comment By: Niels Nes (nielsnes) Date: 2009-02-11 20:09 Message: fixed. New columns/indices created through alter are now always 'updates' (ie initial bats are created with equal lengths as the other bats in the table). This make sure all bats stay aligned. ---------------------------------------------------------------------- You can respond by visiting: https://sourceforge.net/tracker/?func=detail&atid=482471&aid=2160624&group_id=56967 ------------------------------------------------------------------------------ Create and Deploy Rich Internet Apps outside the browser with Adobe(R)AIR(TM) software. With Adobe AIR, Ajax developers can use existing skills and code to build responsive, highly engaging applications that combine the power of local resources and data with the reach of the web. Download the Adobe AIR SDK and Ajax docs to start building applications today-http://p.sf.net/sfu/adobe-com _______________________________________________ Monetdb-bugs mailing list [email protected] https://lists.sourceforge.net/lists/listinfo/monetdb-bugs
