agora inbox for pgsql-sql@postgresql.org
help / color / mirror / Atom feedFrom: ml@ft-c.de
To: pgsql-sql@lists.postgresql.org
Subject: Re: dblink_exists
Date: Mon, 21 Dec 2020 06:07:57 +0100
Message-ID: <6963b9cb4034bb716fca2df60f3af69a08b395fd.camel@ft-c.de> (raw)
In-Reply-To: <CAKFQuwbu0OjsSf9S+dtHjd_s6rt7NnCPgq-Q3pjGBVkxXTzPGw@mail.gmail.com>
References: <ad1e2ca9dbbacae8ca129ed2a7c1cde975c0ed18.camel@ft-c.de>
<CAKFQuwbu0OjsSf9S+dtHjd_s6rt7NnCPgq-Q3pjGBVkxXTzPGw@mail.gmail.com>
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
view thread (3+ messages)
Message-ID: <6963b9cb4034bb716fca2df60f3af69a08b395fd.camel@ft-c.de>
Permalink: ../6963b9cb4034bb716fca2df60f3af69a08b395fd.camel@ft-c.de/
Also on: postgresql.org/message-id/6963b9cb4034bb716fca2df60f3af69a08b395fd.camel@ft-c.de
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: pgsql-sql@postgresql.org
Cc: ml@ft-c.de, pgsql-sql@lists.postgresql.org
Subject: Re: dblink_exists
In-Reply-To: <6963b9cb4034bb716fca2df60f3af69a08b395fd.camel@ft-c.de>
* 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