HI Adrian,
I did additional tests and I can reproduce the problem also without the
extensions.
I did the test multiple time with a script that I put as attachment
(wholetest.sh).
I added also the file log_different_run.txt that contains the results of
some test and the times it takes to reproduce.
Adrian Klaver writes:
> The latest bug fixes of each are 16.6 and 17.2. I would upgrade to those
> and then try again.
Highly unlikely to make any difference. What's evidently going on
here is that the test script attempts to do DROP SCHEMA concurrently
with another session that's creating an o
Hi Adrian,
Thanks for the test, I installed also version 17.2 and test with a fresh
newly created db.
At the beginning I cannot reproduce the problem as well.
Than I start adding the extension we use, one after one, and testing in
between.
I found out that the problem appear immediately as soon as
On 12/19/24 08:50, Adrian Klaver wrote:
On 12/19/24 08:46, Renzo Dani wrote:
Again.
Reply to list also using Reply All.
Ccing list.
Hi Adrian,
here a new version of the script that I just tested produce the same
problem.
The script do not rely now on any additional relation than the ones
de
On 12/19/24 08:46, Renzo Dani wrote:
Again.
Reply to list also using Reply All.
Ccing list.
Hi Adrian,
here a new version of the script that I just tested produce the same
problem.
The script do not rely now on any additional relation than the ones
defined into the script.
BR
Renzo
On Thu
Hi,
Recently, I encountered a problem during a database export using pg_dump.
Here is the error message:
pg_dump: last built-in OID is 16383
pg_dump: reading extensions
pg_dump: identifying extension members
pg_dump: reading schemas
pg_dump: reading user-defined tables
pg_dump: reading u
On 12/19/24 08:21, Renzo Dani wrote:
Reply to list also.
Ccing list.
HI Adrian,
you are right, there is a typo, the correct would be to have:
 MyTestBugSchema2.afunction( u.username )
In any case the problem appears in my tests also with that script.
To be clear the test script did not use
On 12/19/24 01:43, arons wrote:
I forgot to attache the script.
In MyTestBugSchema01.baseProc() you meant to have:
select MyTestBugSchema.afunction( u.username )
instead of
select MyTestBugSchema2.afunction( u.username )
In other words there is a predefined MyTestBugSchema?
On Thu, Dec 1
I forgot to attache the script.
On Thu, Dec 19, 2024 at 10:41 AM Renzo Dani wrote:
> Hi,
>
>
> Recently, I encountered a problem during a database export using pg_dump.
>
>
> Here is the error message:
>
>
> pg_dump: last built-in OID is 16383
>
> pg_dump: reading extensions
>
> pg_dump: identif
