Re: psql client quits after 1st command - Mailing list pgsql-general

From Vincenzo Romano
Subject Re: psql client quits after 1st command
Date
Msg-id 200703050912.33414.Vincenzo.Romano@gmail.com
Whole thread Raw
In response to Re: psql client quits after 1st command  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-general
Good point Tom.

I failed to go  little deeper in the problem.
So the final test for me is that the whole bash script along
with its echos is to be globally directed to the pipes.

On Friday 02 March 2007 19:43 Tom Lane wrote:
> Martijn van Oosterhout <kleptog@svana.org> writes:
> > I don't think you can acheive the effect you want with a FIFO.
>
> I think Doug had it right: the trick is to have some process holding the
> FIFO open for write throughout the procedure, so that the reader (psql)
> doesn't see an EOF.  This doesn't necessarily have to be the same
> process(es) that're actually putting data into the FIFO.
>
> Per the read(2) man page:
>
>      When attempting to read from an empty pipe or FIFO:
>
>           o  If no process has the pipe open for writing, read() will
>              return 0 to indicate end-of-file.
>
>           o  If some process has the pipe open for writing and O_NONBLOCK
>              is set, read() will return -1 and set errnoto EAGAIN.
>
>           o  If some process has the pipe open for writing and O_NONBLOCK
>              is clear, read() will block until some data is written or the
>              pipe is closed by all processes that had the pipe open for
>              writing.
>
>             regards, tom lane

--
Vincenzo Romano
----
Maybe Computers will never become as intelligent as Humans.
For sure they won't ever become so stupid. [VR-1987]

pgsql-general by date:

Previous
From: "hubert depesz lubaczewski"
Date:
Subject: Re: real multi-master replication?
Next
From: Bruno Wolff III
Date:
Subject: Re: Can I getting a unique ID from a select