title: PostgreSQL: Set MAX Value for Sequence to a Higher Value
body: <p>Currently I am importing data from a RabbitMQ worker to a table in postgreSQL. In doing so I received this error:</p>
  
  <p><code>4|tiq-work | error: nextval: reached maximum value of sequence "table_id_seq" (2147483647)</code></p>
  
  <p><code>table.id</code> has a data type of int8 (bigint) which has a range of <code>9223372036854775807</code></p>
  
  <p>I tried to set the max value using this command from the postgreSQL documentation:</p>
  
  <p><code>alter sequence schema.table_id_seq maxvalue 9223372036854775807;</code></p>
  
  <p>But then receive this error:</p>
  
  <p><code>SQL Error [22023]: ERROR: MAXVALUE (9223372036854775807) is out of range for sequence data type</code></p>
  
  <p>This appears to be because the range for sequence data type is the same as the integer data type (2147483647). </p>
  
  <p>Is there a way to force this to go higher? I still have a lot of data to load. </p>