More probs with BLOBs

From: Neanderthelle Jones <elle(at)view(dot)net(dot)au>
To: PGSQL Mailing List <pgsql-general(at)postgresql(dot)org>
Subject: More probs with BLOBs
Date: 2012-08-15 10:24:17
Message-ID: Pine.LNX.4.64.1208151919190.3710@calypso.view.net.au
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

We are getting a strange thing happening if the lo_export(attr, path)
destination is a fifo.

First, in the normal case, there is output to the file but also
feedback to stdout (or somewhere, appearing on the VT screen) of the
number 1.

-----------
1
(1 row)

Now, if the destination file is a fifo and a psql -c command is given
from the shell to lo_export(attr, '/path/to/fifo') we don't get that
feedback, but then a cat of the fifo to a normal file (cat fifo >
file) writes the BLOB content to the destination file but also sends

-----------
1
(1 row)

(or just "1" with psql -t) to the console, apparently (not stderr).

So it seems to us that the lo_export output can't be piped (via a
named pipe) to another process that reads from the pipe and expects
the valid BLOB contents.

Beyond my understanding. What is happening here, and can the echoing
to the fifo be avoided? Ideas, anyone?

(PostgreSQL 9.1.2, Linux 2.6.29.)

Elle

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Neanderthelle Jones 2012-08-15 10:35:13 Re: More probs with BLOBs
Previous Message Loughrey, Hugh 2012-08-15 09:52:17 Check PostgreSQL status using MS-DOS bat file?