Re: Persistent changes in rolled-back transactions

Ron <ronljohnsonjr@xxxxxxxxx> · Sat, 12 Nov 2022 02:37:29 -0600



    On 11/11/22 17:18, Rui DeSousa wrote:

    
          On Nov 9, 2022, at 8:23 PM, David G. Johnston
            <david.g.johnston@xxxxxxxxx>
            wrote:
          

          Or just
              read the documentation for the current version (I seem to
              recall it used to be non-transactional, maybe...doesn't
              matter now).
        
      
      In a lot of other databases DDL is not transactional
        and truncate is DDL — most likely confusing it with another
        RDBMS systems.
    
    
    The first two RDBMS I dealt with had transactional DDL.  It's... natural,
    given that table definitions reside in a system catalog that's just
    a bunch of tables...  I was shocked to see how Oracle does it (and
    that they don't have integers).

    
    -- 

      Angular momentum makes the world go 'round.