From: Tom Lane <tgl@sss.pgh.pa.us>
To: Mark Dilger <mark.dilger@enterprisedb.com>
cc: Andrew Dunstan <andrew@dunslane.net>, Peter Geoghegan <pg@bowt.ie>,
        Robert Haas <robertmhaas@gmail.com>,
        Pavel Borisov <pashkin.elfe@gmail.com>,
        Alexander Lakhin <exclusion@gmail.com>,
        PostgreSQL-development <pgsql-hackers@postgresql.org>
Subject: Re: BUG #17212: pg_amcheck fails on checking temporary relations
In-reply-to: <2306C399-4919-4694-9A0E-72CB5EE1D0B8@enterprisedb.com>
References: <17212-34dd4a1d6bba98bf@postgresql.org>
 <CA+TgmoYa5exExaONEnGBWRdi7A3=FKuKzewY8DXTj6+045wiFQ@mail.gmail.com>
 <CAH2-WzkwRUayddmb3uxCadV_y--DHfY+UMmjtOokiAO2xNh5fA@mail.gmail.com>
 <CA+Tgmoat1M4MAqUQM1H+bkWR=wXmi33bB0YRR=xaFk9ADs5Jeg@mail.gmail.com>
 <CAH2-Wzk3NzXYXsUKWBFuBm6aiXTh-_L2Dm9wPqfFenUvG+VbRw@mail.gmail.com>
 <543F3BF3-EDED-4C52-AF05-623921B6C409@enterprisedb.com>
 <CAH2-WzkXphRHgbaUXqMgb7SBmc_VbwdyWGYqphV6KbOH7stfxA@mail.gmail.com>
 <55A2BFE7-AAAF-4A64-BD3A-5C98EA982267@enterprisedb.com>
 <CAH2-WzniogVqNuWzNVLOKjkd8FBcSry29hN9=wiROUPw92fmGg@mail.gmail.com>
 <07159C9A-40DA-47BF-B2F4-! 203F5AC00890@enterprisedb.com>
 <CAH2-Wzkt-umhXfR1nqy=ZDXMfoN3LDK4W5VtchfWyRAuPWxtnA@mail.gmail.com>
 <40DB088B-C96F-49B2-BC84-BDC8D35C7E97@enterprisedb.com>
 <CAH2-Wzne7L9fX2LdZ9enNZpO2wuqbrsubCw2thH__CC_nZazjw@mail.gmail.com>
 <0B7DA7A4-2872-485B-BFDD-BF8E9BB07B26@enterprisedb.com>
 <726473.1634184950@sss.pgh.pa.us>
 <b5ec84db-c5af-bfac-fe4f-a704a364f90b@dunslane.net> <02C6345B-D186-4F!
 ! 88-A976-A2CD1051CB93@enterprisedb.com> <903680.1634246015@sss.pgh.pa.us>
 <2306C399-4919-4694-9A0E-72CB5EE1D0B8@enterprisedb.com>
Comments: In-reply-to Mark Dilger <mark.dilger@enterprisedb.com>
	message dated "Thu, 14 Oct 2021 14:18:01 -0700"
MIME-Version: 1.0
Content-Type: text/plain; charset="us-ascii"
Content-ID: <904976.1634247542.1@sss.pgh.pa.us>
Content-Transfer-Encoding: quoted-printable
Date: Thu, 14 Oct 2021 17:39:02 -0400
Message-ID: <904977.1634247542@sss.pgh.pa.us>
Archived-At: 
 <https://www.postgresql.org/message-id/904977.1634247542%40sss.pgh.pa.us>
Precedence: bulk

Mark Dilger <mark.dilger@enterprisedb.com> writes:
>> On Oct 14, 2021, at 2:13 PM, Tom Lane <tgl@sss.pgh.pa.us> wrote:
>> (b) Wouldn't finish()ing that connection cause the temp tables to be
>> dropped, negating the entire point of the test?

> The finish() would have to be the last line of the test.
> ...
> I'm curious if the test is indicating something about the underlying tes=
t system.  Only one other test in the tree uses background_psql().  I was =
hoping Andrew would have something to say about whether this is a bug with=
 that function or just user error on my part.

Neither of these things could explain the problem at hand, AFAICS,
because it's failing to start up the standby.

			regards, tom lane