title: Delay execution of SQL script in Amazon Redshift
body: <p>Does Redshift have any functions similar to <code>pg_sleep()</code> in PostgreSQL?</p>
  
  <p>I have a SQL script that needs to wait for some time before continuing with the execution.</p>
  
  <p>The <a href="http://docs.aws.amazon.com/redshift/latest/dg/c_unsupported-postgresql-functions.html" rel="noreferrer">Unsupported PostgreSQL Functions</a> Redshift documentation that says <code>pg_sleep()</code> is not supported.</p>
  
  <p>Update 1:</p>
  
  <p>I am running into deadlock issue in Redshift. I have multiple processes that can query a table (or set of tables) with <code>DROP/TRUNCATE/INSERT/UPDATE/SELECT</code>. If there is a deadlock, I was trying to catch this exception and have the process wait for sometime and retry. Are there any recommendations on ways to handle deadlocks?</p>