pg.ddx.io  pgsql-admin@postgresql.org mailing list archive  
help / color / mirror / Atom feed
From: Laurenz Albe <laurenz.albe@cybertec.at>
To: Brandl, Wolfgang <wolfgang.brandl@brz.gv.at>
To: pgsql-admin@postgresql.org <pgsql-admin@postgresql.org>
Subject: Re: WG: Extension using the current connection handle
Date: Tue, 19 Dec 2017 13:23:04 +0100
Message-ID: <1513686184.2428.3.camel@cybertec.at> (raw)
In-Reply-To: <F2EB158D72DC6A4F97877DD0BB6F020E6138D643@CMD0MBX-AB01.cmd0.cna.at>
References: <F2EB158D72DC6A4F97877DD0BB6F020E6138D643@CMD0MBX-AB01.cmd0.cna.at>

Wolfgang Brandl wrote:
> Thanks for the Tipp with the SPI.
> We are not using oracle_fdw, becaue we got somehow problems with the connection.
> Therefore some of the transactions get lost and all following didn't get a connection.
> We did not analyse this.

Normally, oracle_fdw re-establishes lost connections, so you
get at most one error, and the next statement works again.

Yours,
Laurenz Albe




view thread (4+ messages)

Message-ID: <1513686184.2428.3.camel@cybertec.at>
Permalink:  ../1513686184.2428.3.camel@cybertec.at/
Also on:    postgresql.org/message-id/1513686184.2428.3.camel@cybertec.at

 · 

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-admin@postgresql.org
  Cc: laurenz.albe@cybertec.at, wolfgang.brandl@brz.gv.at
  Subject: Re: WG: Extension using the current connection handle
  In-Reply-To: <1513686184.2428.3.camel@cybertec.at>

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

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