public inbox for [email protected]  

help / color / mirror / Atom feed

From: PG Bug reporting form <[email protected]>
To: [email protected]
Cc: [email protected]
Subject: BUG #19473: regression error in dblink: another command is already in progress
Date: Fri, 08 May 2026 19:29:44 +0000
Message-ID: <[email protected]> (raw)

The following bug has been logged on the website:

Bug reference:      19473
Logged by:          Oleg Ivanov
Email address:      [email protected]
PostgreSQL version: 18.3
Operating system:   Linux
Description:        

Testcase:
SELECT * FROM dblink('dbname=postgres user=postgres', $$ select 7; $$ ) as
(col1 int);
SELECT * FROM dblink_connect('connection1', 'host=/var/run/postgresql
port=5432');
SELECT * FROM dblink_send_query('connection1', $$ select 8 from pg_sleep(1);
$$ );
SELECT dblink_is_busy('connection1');
SELECT * FROM dblink_get_result('connection1') as t(col1 int);
--- SELECT dblink_is_busy('connection1');
SELECT * FROM dblink_exec('connection1', $$ CHECKPOINT; $$);
SELECT * FROM dblink_disconnect('connection1');

 col1
------
    7
(1 row)

 dblink_connect
----------------
 OK
(1 row)

 dblink_send_query
-------------------
                 1
(1 row)

 dblink_is_busy
----------------
              1
(1 row)

 col1
------
    8
(1 row)

ERROR:  another command is already in progress
CONTEXT:  while executing command on dblink connection named "connection1"
 dblink_disconnect
-------------------
 OK
(1 row)

There was no error in 16 version. The error appeared in 17 version. It
seems, there is a regression bug.
The workaround is to uncomment a commented statement.

reply

Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients using the --to and --cc options:
  reply via email

  To: [email protected]
  Cc: [email protected], [email protected], [email protected]
  Subject: Re: BUG #19473: regression error in dblink: another command is already in progress
  In-Reply-To: <[email protected]>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by agora; see mirroring instructions
for how to clone and mirror all data and code used for this inbox