From: Alberto Benini <alberto.benini@tasgroup.eu>
MIME-Version: 1.0
Thread-Index: Adgo4CM+yYk4vz6xSNWOlfePVm27+w==
Date: Wed, 23 Feb 2022 19:18:14 +0100
Message-ID: <e0b4495abaa4c9bfeff2e75f6ae60e88@mail.gmail.com>
Subject: PSQL: "\set ECHO all" doesn't work with "\o"
To: pgsql-sql@lists.postgresql.org
Cc: cm <cm@tasgroup.eu>
Content-Type: multipart/alternative; boundary="0000000000004f6c7705d8b37d51"
Archived-At: 
 <https://www.postgresql.org/message-id/e0b4495abaa4c9bfeff2e75f6ae60e88%40mail.gmail.com>
Precedence: bulk

--0000000000004f6c7705d8b37d51
Content-Type: text/plain; charset="UTF-8"
Content-Transfer-Encoding: quoted-printable

Hi all,

I haven=E2=80=99t understand how to redirect SQL errors on output file.


Our goal is to have a psql script with:


\set ON_ERROR_STOP true

\set ECHO all

\o log/update.log;

\i update.sql;


..but in the log file we don=E2=80=99t see any sql error


KR,

Alberto

--0000000000004f6c7705d8b37d51
Content-Type: text/html; charset="UTF-8"
Content-Transfer-Encoding: quoted-printable

<html><head><meta http-equiv=3D"Content-Type" content=3D"text/html; charset=
=3Dus-ascii"><meta name=3D"Generator" content=3D"Microsoft Word 15 (filtere=
d medium)"><style><!--
/* Font Definitions */
@font-face
	{font-family:"Cambria Math";
	panose-1:2 4 5 3 5 4 6 3 2 4;}
@font-face
	{font-family:Calibri;
	panose-1:2 15 5 2 2 2 4 3 2 4;}
/* Style Definitions */
p.MsoNormal, li.MsoNormal, div.MsoNormal
	{margin:0cm;
	margin-bottom:.0001pt;
	font-size:11.0pt;
	font-family:"Calibri",sans-serif;
	mso-fareast-language:EN-US;}
a:link, span.MsoHyperlink
	{mso-style-priority:99;
	color:#0563C1;
	text-decoration:underline;}
a:visited, span.MsoHyperlinkFollowed
	{mso-style-priority:99;
	color:#954F72;
	text-decoration:underline;}
span.StileMessaggioDiPostaElettronica17
	{mso-style-type:personal-compose;
	font-family:"Calibri",sans-serif;
	color:windowtext;}
.MsoChpDefault
	{mso-style-type:export-only;
	mso-fareast-language:EN-US;}
@page WordSection1
	{size:612.0pt 792.0pt;
	margin:70.85pt 2.0cm 2.0cm 2.0cm;}
div.WordSection1
	{page:WordSection1;}
--></style></head><body lang=3D"IT" link=3D"#0563C1" vlink=3D"#954F72"><div=
 class=3D"WordSection1"><p class=3D"MsoNormal"><span lang=3D"EN-US">Hi all,=
</span></p><p class=3D"MsoNormal"><span lang=3D"EN-US">I haven=E2=80=99t un=
derstand how to redirect SQL errors on output file.</span></p><p class=3D"M=
soNormal"><span lang=3D"EN-US">=C2=A0</span></p><p class=3D"MsoNormal"><spa=
n lang=3D"EN-US">Our goal is to have a psql script with:</span></p><p class=
=3D"MsoNormal"><span lang=3D"EN-US">=C2=A0</span></p><p class=3D"MsoNormal"=
><span lang=3D"EN-US">\set ON_ERROR_STOP true</span></p><p class=3D"MsoNorm=
al"><span lang=3D"EN-US">\set ECHO all</span></p><p class=3D"MsoNormal">\o =
log/update.log;</p><p class=3D"MsoNormal">\i update.sql;</p><p class=3D"Mso=
Normal"><span style=3D"mso-fareast-language:IT">=C2=A0</span></p><p class=
=3D"MsoNormal"><span style=3D"mso-fareast-language:IT">=C2=A0</span></p><p =
class=3D"MsoNormal"><span lang=3D"EN-US" style=3D"mso-fareast-language:IT">=
..but in the log file we don=E2=80=99t see any sql error</span></p><p class=
=3D"MsoNormal"><span lang=3D"EN-US" style=3D"mso-fareast-language:IT">=C2=
=A0</span></p><p class=3D"MsoNormal"><span lang=3D"EN-US" style=3D"mso-fare=
ast-language:IT">KR,</span></p><p class=3D"MsoNormal"><span lang=3D"EN-US" =
style=3D"mso-fareast-language:IT">Alberto</span></p><p class=3D"MsoNormal">=
<span lang=3D"EN-US" style=3D"mso-fareast-language:IT">=C2=A0</span></p></d=
iv></body></html>

--0000000000004f6c7705d8b37d51--