On Mon, 25 Sep 2006, Tom Lane wrote:
> Jeremy Drake <psql@jdrake.com> writes:
> > I just tried using the \lo_import command in a regression test, and I
> > think I figured out why this will not work:
> > ...
> > Yes, that's the large object OID in the output there, and it is different
> > each run (as I expect).
>
> Right. I'd suggest temporarily setting ECHO off to hide the
> unpredictable part of the output. There are similar measures taken in
> many of the contrib tests.
I tried this:
jeremyd=# \set QUIET
jeremyd=# \set ECHO off
jeremyd=# BEGIN;
jeremyd=# \lo_import results/lotest.txt
lo_import 84951
jeremyd=# ROLLBACK;
From what I could tell in the code, the message is printed regardless of
setting.
It looks like the large_obj.c output is missing much of the output
settings handling which is in the PrintQueryStatus function in common.c,
such as handling quiet mode, and html output. I will try to dig around
and try to put together a patch to make it respect the settings like other
commands...
--
"You are old," said the youth, "and your programs don't run,And there isn't one language you like;
Yet of useful suggestions for help you have none --Have you thought about taking a hike?"
"Since I never write programs," his father replied,"Every language looks equally bad;
Yet the people keep paying to read all my booksAnd don't realize that they've been had."