Regressor

## README.md

      
        
          
            
              
              2 files
            
          
          
            
              
              4 forks
            
          
          
            
              
              4 comments
            
          
          
            
              
              23 stars
            
          
        
        
          
              
          
          
            
                notheotherben
                / README.md
            
            
              Last active
              September 9, 2021 07:50
            
              
                Fix Postgres 9.x Sequences
              
          
        
      
        
  
      
    PostgreSQL 9.x Sequence Fixing Script

This script is intended to automatically fix the sequence numbers for all tables in the current database.
This is accomplished through the use of the setval() command, which we provide with the next ID value we wish to make use of.
We use the setval(sequence, number, is_called) overload
and set is_called = false in conjunction with COALESCE(MAX + 1, 1) to ensure that, with an empty table, the next sequence
value is 1 as expected.