Message-ID: <3978528f-d76c-4a10-bf3e-7f599770709a@vondra.me>
Date: Fri, 20 Jun 2025 11:11:47 +0200
MIME-Version: 1.0
User-Agent: Mozilla Thunderbird
Subject: Re: Extension disappearing act
To: Dominique Devienne <ddevienne@gmail.com>,
 Laurenz Albe <laurenz.albe@cybertec.at>
Cc: pgsql-general@lists.postgresql.org
References: <CAFCRh-_TQagsob_YH0nXktwhuBftNaiZ_VZ4REhZdSEkWXVKXg@mail.gmail.com>
 <3318006a000e05360c487189bf8abe5c40732ce3.camel@cybertec.at>
 <CAFCRh-8a1vTzySrzp+H4j_enHLUBfgtEHYsnqx1m8u+Zw3YyyQ@mail.gmail.com>
Content-Language: en-US
From: Tomas Vondra <tomas@vondra.me>
In-Reply-To: <CAFCRh-8a1vTzySrzp+H4j_enHLUBfgtEHYsnqx1m8u+Zw3YyyQ@mail.gmail.com>
Content-Type: text/plain; charset=UTF-8
Content-Transfer-Encoding: 8bit
Archived-At: <https://www.postgresql.org/message-id/3978528f-d76c-4a10-bf3e-7f599770709a%40vondra.me>
Precedence: bulk


On 6/20/25 09:35, Dominique Devienne wrote:
> On Thu, Jun 19, 2025 at 6:35 PM Laurenz Albe <laurenz.albe@cybertec.at> wrote:
>>
>> On Thu, 2025-06-19 at 15:09 +0200, Dominique Devienne wrote:
>>> Hi. Little mystery we don't understand. v17.
>>> We're stumped for now.
>>
>> So are we.  Why do you keep us guessing instead of posting a reproducer?
> 
> Hi. Simply because there's too much proprietary stuff, I'm afraid.
> And it's likely some stupid mistakes on our part anyway. That I can't see...
> Still, the fact I see nothing extension-related in the libpq trace is
> intriguing, isn't it?
> 

PQtrace logs client-server communication. I would not expect it to say
anything about actions that happen on the server, like for example
automatically dropping objects in a schema, after the schema is dropped.

I think the best way to move this forward is sharing a reproducer. If
you have too much proprietary stuff, you'll have to remove those bits,
or rather replace them with something you can share.

In fact, a reproducer is meant to be "minimal" - the smallest example
causing the issue. So creating reproducers generally means simplifying
the example as much as possible anyway. And I wouldn't be surprised if
in the process of doing that you find the answer yourself.


regards
-- 
Tomas Vondra