Re: dblink_exists - Mailing list pgsql-sql

From ml@ft-c.de
Subject Re: dblink_exists
Date
Msg-id 6963b9cb4034bb716fca2df60f3af69a08b395fd.camel@ft-c.de
Whole thread Raw
In response to Re: dblink_exists  ("David G. Johnston" <david.g.johnston@gmail.com>)
List pgsql-sql
On Sun, 2020-12-20 at 18:52 -0700, David G. Johnston wrote:
On Sunday, December 20, 2020, <ml@ft-c.de> 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

pgsql-sql by date:

Previous
From: "David G. Johnston"
Date:
Subject: Re: dblink_exists
Next
From: Thomas Kellerer
Date:
Subject: JSON path query returns duplicate values