Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1krDQa-0008F8-8c for pgsql-sql@arkaria.postgresql.org; Mon, 21 Dec 2020 05:08:12 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1krDQY-0000hB-1Z for pgsql-sql@arkaria.postgresql.org; Mon, 21 Dec 2020 05:08:10 +0000 Received: from makus.postgresql.org ([2001:4800:3e1:1::229]) by malur.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1krDQX-0000h3-Q2 for pgsql-sql@lists.postgresql.org; Mon, 21 Dec 2020 05:08:09 +0000 Received: from einhorn-mail-out.in-berlin.de ([217.197.80.21]) by makus.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1krDQQ-00061F-Ox for pgsql-sql@lists.postgresql.org; Mon, 21 Dec 2020 05:08:08 +0000 X-Envelope-From: ml@ft-c.de X-Envelope-To: Received: from authenticated.user (localhost [127.0.0.1]) by einhorn.in-berlin.de with ESMTPSA id 0BL57vxN017470 (version=TLSv1.3 cipher=TLS_AES_256_GCM_SHA384 bits=256 verify=NOT) for ; Mon, 21 Dec 2020 06:07:58 +0100 Message-ID: <6963b9cb4034bb716fca2df60f3af69a08b395fd.camel@ft-c.de> Subject: Re: dblink_exists From: ml@ft-c.de Reply-To: ml@ft-c.de To: pgsql-sql@lists.postgresql.org Date: Mon, 21 Dec 2020 06:07:57 +0100 In-Reply-To: References: Content-Type: multipart/alternative; boundary="=-p5/ontCfl8O+zRIqLLjY" User-Agent: Evolution 3.38.0 FreeBSD GNOME Team MIME-Version: 1.0 List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Precedence: bulk --=-p5/ontCfl8O+zRIqLLjY Content-Type: text/plain; charset="UTF-8" Content-Transfer-Encoding: 8bit On Sun, 2020-12-20 at 18:52 -0700, David G. Johnston wrote: > On Sunday, December 20, 2020, wrote: > > > > My general problem: > > I need a command that send a answer immediately and not, when the > > query > > if finished.  > dblink_exec()?   no, it needs a connection string >   > > > > When someone start the script again (when it is running), so I need > > a > > section like: > Advisory locks? lock on a table: it is the  best solution   > > > > 2. question: > > When dlink_send_query is running, > > select dblink_get_connections() > > send NULL as answer. > > > Don’t know - though suggest showing actual code that results in this > behavior. Franz --=-p5/ontCfl8O+zRIqLLjY Content-Type: text/html; charset="utf-8" Content-Transfer-Encoding: quoted-printable
On Sun, 2020-12-20 at 18:52 -0700, David G. J= ohnston wrote:
On Sunday, December 20,= 2020, <ml@ft-c.de> wrote:

My general problem:
I need a comman= d that send a answer immediately and not, when the query
if finished.&nb= sp;
dblink_exec()?
  no,= it needs a connection string
 

When someone start the script again= (when it is running), so I need a
section like:
= Advisory locks?
lock on a table: it is the  bes= t solution  
--=-p5/ontCfl8O+zRIqLLjY--