MIME-Version: 1.0
References: 
 <CA+wokJ-NAMMVdo52WdwmGN8CasaE026jhRH7yb1MFU2eF=HeEw@mail.gmail.com>
 <CAKFQuwZvMkCNffV8_X2yeVFJdOaFKwVUEuWcLpsvP-w+YjwBGw@mail.gmail.com>
In-Reply-To: 
 <CAKFQuwZvMkCNffV8_X2yeVFJdOaFKwVUEuWcLpsvP-w+YjwBGw@mail.gmail.com>
From: Edwin UY <edwin.uy@gmail.com>
Date: Thu, 7 Nov 2024 20:49:56 +1300
Message-ID: 
 <CA+wokJ_nqFaPF8YaLsgndawVT-Wf-Zw5hBaK5=F8UehD2PozXQ@mail.gmail.com>
Subject: Re: \i and \watch
To: "David G. Johnston" <david.g.johnston@gmail.com>
Cc: "pgsql-admin@lists.postgresql.org" <pgsql-admin@lists.postgresql.org>
Content-Type: multipart/alternative; boundary="000000000000954ad006264de324"
Archived-At: 
 <https://www.postgresql.org/message-id/CA%2BwokJ_nqFaPF8YaLsgndawVT-Wf-Zw5hBaK5%3DF8UehD2PozXQ%40mail.gmail.com>
Precedence: bulk

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

Thanks for the explanation.
Yeah, here's what's happening. So, yeah, we'll check on having to script it
instead.

###
=3D> select now() ;
              now
-------------------------------
 2024-11-07 07:46:23.876888+00
(1 row)

=3D> \! cat x.sql
select version() ;
=3D> \i x.sql
                                                   version
---------------------------------------------------------------------------=
-----------------------------------
 PostgreSQL 14.12 on aarch64-unknown-linux-gnu, compiled by
aarch64-unknown-linux-gnu-gcc (GCC) 9.5.0, 64-bit
(1 row)

=3D> \watch 5
Thu 07 Nov 2024 20:47:05 NZDT (every 5s)

              now
-------------------------------
 2024-11-07 07:47:05.411747+00
(1 row)

Thu 07 Nov 2024 20:47:10 NZDT (every 5s)

              now
-------------------------------
 2024-11-07 07:47:10.418915+00
(1 row)

^C


On Thu, Nov 7, 2024 at 6:26=E2=80=AFPM David G. Johnston <david.g.johnston@=
gmail.com>
wrote:

> On Wednesday, November 6, 2024, Edwin UY <edwin.uy@gmail.com> wrote:
>
>>
>> Is there no way to use \watch to let it run the last script that I just
>> run?
>>
>> When do I do as below:
>>
>> select 1 ;
>> \i x.sql
>> \watch 20
>>
>> It runs select 1 instead.
>>
>>
> Watch is documented to act on either a non-empty query buffer or the last
> sent command.  I would expect that whatever the final SQL command present
> in x.sql is would be the command that gets watched.  If indeed the
> preceding select 1 command is watched there would seem to be an
> undocumented interaction going on.
>
> In any case, no, you cannot watch a meta-command.  You=E2=80=99d have to =
resort to
> shell scripting the repeated execution of the psql program itself.
>
> David J.
>
>

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

<div dir=3D"ltr"><div>Thanks for the explanation. <br></div><div></div><div=
>Yeah, here&#39;s what&#39;s happening. So, yeah, we&#39;ll check on having=
 to script it instead. <br></div><div><br></div><div>###</div><div>=3D&gt; =
select now() ;<br>=C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 now<br>-=
------------------------------<br>=C2=A02024-11-07 07:46:23.876888+00<br>(1=
 row)<br><br>=3D&gt; \! cat x.sql<br>select version() ;<br>=3D&gt; \i x.sql=
<br>=C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =
=C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=
=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0version<br>--------------------------=
---------------------------------------------------------------------------=
---------<br>=C2=A0PostgreSQL 14.12 on aarch64-unknown-linux-gnu, compiled =
by aarch64-unknown-linux-gnu-gcc (GCC) 9.5.0, 64-bit<br>(1 row)<br><br>=3D&=
gt; \watch 5<br>Thu 07 Nov 2024 20:47:05 NZDT (every 5s)<br><br>=C2=A0 =C2=
=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 now<br>-----------------------------=
--<br>=C2=A02024-11-07 07:47:05.411747+00<br>(1 row)<br><br>Thu 07 Nov 2024=
 20:47:10 NZDT (every 5s)<br><br>=C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =
=C2=A0 now<br>-------------------------------<br>=C2=A02024-11-07 07:47:10.=
418915+00<br>(1 row)<br><br>^C</div><div><br></div></div><br><div class=3D"=
gmail_quote"><div dir=3D"ltr" class=3D"gmail_attr">On Thu, Nov 7, 2024 at 6=
:26=E2=80=AFPM David G. Johnston &lt;<a href=3D"mailto:david.g.johnston@gma=
il.com">david.g.johnston@gmail.com</a>&gt; wrote:<br></div><blockquote clas=
s=3D"gmail_quote" style=3D"margin:0px 0px 0px 0.8ex;border-left:1px solid r=
gb(204,204,204);padding-left:1ex">On Wednesday, November 6, 2024, Edwin UY =
&lt;<a href=3D"mailto:edwin.uy@gmail.com" target=3D"_blank">edwin.uy@gmail.=
com</a>&gt; wrote:<br><blockquote class=3D"gmail_quote" style=3D"margin:0px=
 0px 0px 0.8ex;border-left:1px solid rgb(204,204,204);padding-left:1ex"><di=
v dir=3D"ltr"><div><br></div><div>Is there no way to use \watch to let it r=
un the last script that I just run?</div><div><br></div><div>When do I do a=
s below:</div><div><br></div><div>select 1 ;</div><div>\i x.sql</div><div>\=
watch 20</div><div><br></div><div>It runs select 1 instead.</div><div><br><=
/div></div></blockquote><div><br></div><div>Watch is documented to act on e=
ither a non-empty query buffer or the last sent command.=C2=A0 I would expe=
ct that whatever the final SQL command present in x.sql is would be the com=
mand that gets watched.=C2=A0 If indeed the preceding select 1 command is w=
atched there would seem to be an undocumented interaction going on.</div><d=
iv><br></div><div>In any case, no, you cannot watch a meta-command.=C2=A0 Y=
ou=E2=80=99d have to resort to shell scripting the repeated execution of th=
e psql program itself.</div><div><br></div><div>David J.</div><div><br></di=
v>
</blockquote></div>

--000000000000954ad006264de324--