Re: Query regarding function cleanup in extension upgrade path - Mailing list pgsql-general

From Daniel Gustafsson
Subject Re: Query regarding function cleanup in extension upgrade path
Date
Msg-id 670C5F75-12A9-499D-933B-D44A171A13F8@yesql.se
Whole thread Raw
In response to Re: Query regarding function cleanup in extension upgrade path  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-general
> On 14 Feb 2024, at 21:56, Tom Lane <tgl@sss.pgh.pa.us> wrote:
> Ayush Vatsa <ayushvatsa1810@gmail.com> writes:

>> 2. While going through the contrib folder I find that in the regress test
>> there are two .out files with respect to a single .sql file, example
>> citext.out and citext_1.out wrt citext.sql. Why is it so? Even in git blame
>> , I couldn't find much!
>
> We use that when the expected test output is environment-dependent.
> If the diff between the .out files isn't pretty self-explanatory,
> you can try checking the git log for the "_1.out" file to see why it
> was created.

Some further details on this may be gleaned from the pg_regress source code
where it checks for an alternate file (_1 through _9) in case the main expected
output file created a diff:


https://git.postgresql.org/gitweb/?p=postgresql.git;a=blob;f=src/test/regress/pg_regress.c;h=c894005dac06bc233896520c83c18e51af8ace9c;hb=HEAD#l1450

--
Daniel Gustafsson




pgsql-general by date:

Previous
From: Laurenz Albe
Date:
Subject: Re: RowLock and multiple transactions
Next
From: "Daniel Westermann (DWE)"
Date:
Subject: pg_stat_activity.query_id <-> pg_stat_statements.queryid