Thread: psql \lo_* quiet mode patch
I sent this in a while back, but never heard anything about it.
This patch makes psql's \lo_* commands respect the -q flag (or other
methods of setting quiet mode) as well as HTML output mode. This came in
very handy when writing a regression test which uses the \lo_import
command since it would otherwise output the OID of the new large object
which would be different every run.
Please let me know if it is ok, or if I need to do it differently.
--
Let me assure you that to us here at First National, you're not just a
number. You're two numbers, a dash, three more numbers, another dash
and another number.
-- James Estes
Attachment
This has been saved for the 8.3 release:
http://momjian.postgresql.org/cgi-bin/pgpatches_hold
---------------------------------------------------------------------------
Jeremy Drake wrote:
> I sent this in a while back, but never heard anything about it.
>
> This patch makes psql's \lo_* commands respect the -q flag (or other
> methods of setting quiet mode) as well as HTML output mode. This came in
> very handy when writing a regression test which uses the \lo_import
> command since it would otherwise output the OID of the new large object
> which would be different every run.
>
> Please let me know if it is ok, or if I need to do it differently.
>
> --
> Let me assure you that to us here at First National, you're not just a
> number. You're two numbers, a dash, three more numbers, another dash
> and another number.
> -- James Estes
Content-Description:
[ Attachment, skipping... ]
>
> ---------------------------(end of broadcast)---------------------------
> TIP 3: Have you checked our extensive FAQ?
>
> http://www.postgresql.org/docs/faq
--
Bruce Momjian bruce@momjian.us
EnterpriseDB http://www.enterprisedb.com
+ If your life is a hard drive, Christ can be your backup. +
Your patch has been added to the PostgreSQL unapplied patches list at:
http://momjian.postgresql.org/cgi-bin/pgpatches
It will be applied as soon as one of the PostgreSQL committers reviews
and approves it.
---------------------------------------------------------------------------
Jeremy Drake wrote:
> I sent this in a while back, but never heard anything about it.
>
> This patch makes psql's \lo_* commands respect the -q flag (or other
> methods of setting quiet mode) as well as HTML output mode. This came in
> very handy when writing a regression test which uses the \lo_import
> command since it would otherwise output the OID of the new large object
> which would be different every run.
>
> Please let me know if it is ok, or if I need to do it differently.
>
> --
> Let me assure you that to us here at First National, you're not just a
> number. You're two numbers, a dash, three more numbers, another dash
> and another number.
> -- James Estes
Content-Description:
[ Attachment, skipping... ]
>
> ---------------------------(end of broadcast)---------------------------
> TIP 3: Have you checked our extensive FAQ?
>
> http://www.postgresql.org/docs/faq
--
Bruce Momjian <bruce@momjian.us> http://momjian.us
EnterpriseDB http://www.enterprisedb.com
+ If your life is a hard drive, Christ can be your backup. +
On Tue, 13 Feb 2007, Bruce Momjian wrote: > > Your patch has been added to the PostgreSQL unapplied patches list at: > > http://momjian.postgresql.org/cgi-bin/pgpatches > > It will be applied as soon as one of the PostgreSQL committers reviews > and approves it. This one has also already been applied. > > --------------------------------------------------------------------------- > > > Jeremy Drake wrote: > > I sent this in a while back, but never heard anything about it. > > > > This patch makes psql's \lo_* commands respect the -q flag (or other > > methods of setting quiet mode) as well as HTML output mode. This came in > > very handy when writing a regression test which uses the \lo_import > > command since it would otherwise output the OID of the new large object > > which would be different every run. > > > > Please let me know if it is ok, or if I need to do it differently. > > > > -- > > Let me assure you that to us here at First National, you're not just a > > number. You're two numbers, a dash, three more numbers, another dash > > and another number. > > -- James Estes > Content-Description: > > [ Attachment, skipping... ] > > > > > ---------------------------(end of broadcast)--------------------------- > > TIP 3: Have you checked our extensive FAQ? > > > > http://www.postgresql.org/docs/faq > > -- Computers can figure out all kinds of problems, except the things in the world that just don't add up.
Jeremy Drake wrote: > On Tue, 13 Feb 2007, Bruce Momjian wrote: > > > > > Your patch has been added to the PostgreSQL unapplied patches list at: > > > > http://momjian.postgresql.org/cgi-bin/pgpatches > > > > It will be applied as soon as one of the PostgreSQL committers reviews > > and approves it. > > This one has also already been applied. Oops, thanks. --------------------------------------------------------------------------- > > > > > --------------------------------------------------------------------------- > > > > > > Jeremy Drake wrote: > > > I sent this in a while back, but never heard anything about it. > > > > > > This patch makes psql's \lo_* commands respect the -q flag (or other > > > methods of setting quiet mode) as well as HTML output mode. This came in > > > very handy when writing a regression test which uses the \lo_import > > > command since it would otherwise output the OID of the new large object > > > which would be different every run. > > > > > > Please let me know if it is ok, or if I need to do it differently. > > > > > > -- > > > Let me assure you that to us here at First National, you're not just a > > > number. You're two numbers, a dash, three more numbers, another dash > > > and another number. > > > -- James Estes > > Content-Description: > > > > [ Attachment, skipping... ] > > > > > > > > ---------------------------(end of broadcast)--------------------------- > > > TIP 3: Have you checked our extensive FAQ? > > > > > > http://www.postgresql.org/docs/faq > > > > > > -- > Computers can figure out all kinds of problems, except the things in > the world that just don't add up. -- Bruce Momjian <bruce@momjian.us> http://momjian.us EnterpriseDB http://www.enterprisedb.com + If your life is a hard drive, Christ can be your backup. +