Re: get_database_name() from background worker - Mailing list pgsql-hackers

From Craig Ringer
Subject Re: get_database_name() from background worker
Date
Msg-id CAMsr+YESe0cPfmg2pX7YvHiQL=K0LAMXQqsPeNK_2QQ814fe4A@mail.gmail.com
Whole thread Raw
In response to RE: get_database_name() from background worker  (ROS Didier <didier.ros@edf.fr>)
List pgsql-hackers
On Thu, 12 Dec 2019 at 16:21, ROS Didier <didier.ros@edf.fr> wrote:
Hi
   With pg_background extension ,it is possible to make  "autonomous transaction" which means possibility to commit in a transaction.
 It is like a client which connects to a postgresql instance. So you can execute any sql orders .


Yes, that's possible. It's not easy though and I strongly suggest you look into existing approaches like using dblink instead.

Please start a new thread rather than following an unrelated existing one. 


--
 Craig Ringer                   http://www.2ndQuadrant.com/
 2ndQuadrant - PostgreSQL Solutions for the Enterprise

pgsql-hackers by date:

Previous
From: Thomas Munro
Date:
Subject: Re: checkpointer: PANIC: could not fsync file: No such file or directory
Next
From: Craig Ringer
Date:
Subject: Re: xact_start for walsender & logical decoding not updated