title: Alter PostgreSQL sequence using Hibernate native sql query
body: <p>My problem seems to be very simple but I have hard time resolving it.<br>
  I want to alter an PostgreSQL sequence using Hibernate via native sql query (other solutions are also welcomed) using next code: </p>
  
  <pre><code>    Query query = getSession()
          .createSQLQuery("ALTER SEQUENCE users_id_seq RESTART WITH ?")
          .setInteger(0, 1);
      query.executeUpdate();
  </code></pre>
  
  <p>But I am getting this error:</p>
  
  <pre><code>Hibernate: 
      ALTER SEQUENCE users_id_seq RESTART WITH ?
  hibernate.engine.jdbc.spi.SqlExceptionHelper - SQL Error: 0, SQLState: 42601
  hibernate.engine.jdbc.spi.SqlExceptionHelper - ERROR: syntax error at or near "$1"
  </code></pre>