(In addition to Clive's comments.)
On Fri, May 26, 2006 at 09:28:37AM -0700, Loo, Peter # PHX wrote:
>
> The problem I am having is, when I execute "INSERT INTO real_table
> SELECT * FROM ex_table" before I start writing to the named pipe, this
> process immediately stops because there is no data to SELECT. But if I
> start writing to the named pipe before starting the "INSERT INTO", I may
> miss some data.
>
> I was wondering if anyone might have an answer as to how I can sync the
> start up of the write and INSERT INTO at the same time or perhaps some
> other method.
So the steps go something like,
open the pipe for writing
start the process which reads the pipe
start writing to the pipe.
Tim.
