Is there a way to run a SQL statement on buffered data that has not been committed on an optimistic table buffering with multi-locks on? The SQL is retrieving the original data from disk which is cool in some cases. In the past I've issued the 'COPY TO' then executed a select statement on the copy. Any suggestions would be appreciated.