On Wed, 2005-06-01 at 00:40 -0400, Alvaro Herrera wrote: > This doesn't work for COPY, but maybe for CREATE TABLE AS we could log > the fact that the command was executed, so the replayer could execute > the same command again. > > Of course, this handwaving doesn't explain how the system in recovery > mode would be able to execute a full query to reconstruct the table
There's also the typical problem with this kind of approach: how do you handle non-deterministic queries? (e.g. "CREATE TABLE ... AS SELECT random(), gettimeofday(), some_func(t1.x) FROM t1 LIMIT 5") -Neil ---------------------------(end of broadcast)--------------------------- TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]