On Mon, 25 Sep 2006, Tom Lane wrote: > Jeremy Drake <[EMAIL PROTECTED]> 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 books And don't realize that they've been had." ---------------------------(end of broadcast)--------------------------- TIP 5: don't forget to increase your free space map settings