Pragma autonomous transactions in Postgres/ Certification based authentication in DB Links - Mailing list pgsql-sql

From aditya desai
Subject Pragma autonomous transactions in Postgres/ Certification based authentication in DB Links
Date
Msg-id CAN0SRDEGsXnULFzB+X7FNzwO4iT27G=rDhe9GgvMnhsj98KKPw@mail.gmail.com
Whole thread Raw
Responses Re: Pragma autonomous transactions in Postgres/ Certification based authentication in DB Links  (Jonathan Katz <jonathan.katz@excoventures.com>)
List pgsql-sql
Hi,
Is there any way to achieve autonomous transactions in Postgres? There is a way to do it by using DB Link. However DB Link involves user name and password which is a bit of a security threat.

How to use certificate based authentication in DB Links instead of hardcoding user name and password in it?



Regards,
Aditya.


pgsql-sql by date:

Previous
From: hubert depesz lubaczewski
Date:
Subject: Re: ERROR ON INSERTING USING A CURSOR IN EDB POSTGRESQL
Next
From: Jonathan Katz
Date:
Subject: Re: Pragma autonomous transactions in Postgres/ Certification based authentication in DB Links