On 12/19/24 15:36, Bharani SV-forum wrote:
cannot drop a tablespace which never exists in pg_tablespace
I remember i had create previously an tablespace named " mq_data" , but
cannot find in pg_tablespace listing.
if i try to create the same tablespace name, it is giving error as "
already
cannot drop a tablespace which never exists in pg_tablespace
I remember i had create previously an tablespace named " mq_data" , but cannot
find in pg_tablespace listing.
if i try to create the same tablespace name, it is giving error as " already in
use as a tablespace"how to force drop the p
On 12/19/24 11:40 AM, Enrico Schenone wrote:
Hello, my answers in line along your message ...
Thanks a lot again.
Enrico
On 12/19/24 10:11, Enrico Schenone wrote:
Good day, Adrian.
I get the error inside the program by catching the exception and
logging it with diagnostic info provided
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 10:11, Enrico Schenone wrote:
Good day, Adrian.
I get the error inside the program by catching the exception and logging
it with diagnostic info provided by the DVM (a runtime interpreter
similar in concept to a JVM) that embed the PG driver.
DVM is this?:
https://www.geeksforgee
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/18/24 23:52, Enrico Schenone wrote:
Good day, Adrian.
First of all I thank-you for you answer.
At the time the error occurs, dozens of other SQL sessions are active &
running on DB server, and no-one is reporting any error at-all (not only
fetch errors).
This happens sometimes also in
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
Hi,
I'm adding support for Pipeline Mode to my C++ PostgreSQL client library
(https://github.com/taocpp/taopq) and I tried to understand the interaction
between Pipeline Mode and Single Row Mode / Chunked Rows Mode. It seems that it
works sometimes, but I don't get the feeling that it was delib
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
15 matches
Mail list logo
