From: "M, Anbazhagan" <Anbazhagan.M@netapp.com>
To: "pgsql-odbc@postgresql.org" <pgsql-odbc@postgresql.org>
Subject: Reg: libpq support in pgODBC driver
Thread-Topic: Reg: libpq support in pgODBC driver
Thread-Index: AQHZviTGRLmCd5bJXEGGkzDJ6+wbKA==
Date: Mon, 24 Jul 2023 11:57:38 +0000
Message-ID: 
 <SN4PR0601MB861386378F09DA8BA1E956EFFF02A@SN4PR0601MB8613.namprd06.prod.outlook.com>
Accept-Language: en-GB, en-US
Content-Language: en-IN
x-ms-exchange-antispam-messagedata-chunkcount: 1
x-ms-exchange-antispam-messagedata-0: 
 =?Windows-1252?Q?eES9jZm8LSb5a9PLrIIOg7Uff87Nlmv4eRlHNk71fCBatX6oMtLGj6Bz?=
 =?Windows-1252?Q?1uhsuUrs0YzOFSrVc1EKx2m3pyuD/mFe9992XoqCY3F811c5cYCDGduA?=
 =?Windows-1252?Q?e3NeMN/XbAStVU6R9Uh3gCMukaCKl1B0aqYJbYb2WRvGDDKGLml6sF0z?=
 =?Windows-1252?Q?BNs3i09lcfZFx6hXV5Kfi0RDYtZn2YUtDX+2VIRYF6Y9B5KHJVR5dLLY?=
 =?Windows-1252?Q?JNO2H5/J+nWEnE+C6UkA8KPtLEDGj4MqikTe7BwqdKKinvg2TpyzF5E+?=
 =?Windows-1252?Q?C+g9w+GM0418HDC3Tz0cu1L3sArAJIdV1evxNOpEr86ZrvJe6wnxb/zU?=
 =?Windows-1252?Q?Rz96+bFGmQwDiU+VEsdbWRnnwvchP2LOfXrm82oh93fTeO04sM5E9FUq?=
 =?Windows-1252?Q?Q636LNL7hvrXblBqOX/z0ufLWcNlr1WTajuLqVhFcnOUoziNHdmlMGFR?=
 =?Windows-1252?Q?7FAk/bVdxt8NGTddDl+vKoX+qU8/08Xxrj5srLRN1DqgyNw+GCWMnUGM?=
 =?Windows-1252?Q?Yc4mmozKpa334tLX9EgT6N6hdJp5PPMSgGuckLUZqR2qf0oBiZEQqQ+5?=
 =?Windows-1252?Q?K4a30rL7SxyO509TwH0/W7N+0N6Ldc4aH8pqA+cbkG8MeQQOUB4PvRrN?=
 =?Windows-1252?Q?ba7m6lN4vz5ZU7DokiHThP0Hy2vYX/LA4y7E4fo8Ed5TmsUB7Gcsokg4?=
 =?Windows-1252?Q?FtjjLY7KvNwMWxm6FZRkYGVd6p6bWsbtNOj83MaYiqN2knQzwsGWFWpZ?=
 =?Windows-1252?Q?EKOCvPtTqH8CKCyYEshWrsmbcyD4YCJJzG99AwMO5HAExsHuzKDG5VQY?=
 =?Windows-1252?Q?F+jVJ5or20/mFZAFb3dw/6Iidk99dv+jB3xOfodqwcGkIvCTu1UiKXvi?=
 =?Windows-1252?Q?2pJEBcs8wfLsjNlkfQUUueFBSDEQapIIVF2d+uUHNzCwl27m9rCGvog9?=
 =?Windows-1252?Q?MonQRK4rB56MOkQPBmUivbQZmZ85E8owLSW2qihEajS+EU6HnnA8T4sM?=
 =?Windows-1252?Q?EjMaRG5W7Fo7mWgY8DriWdnrumNp4ORsl5bHbSY04ZiVBVt8/5LVgGFH?=
 =?Windows-1252?Q?W5+2XcpEI2yktSJssaiOuOnGXwOD6iaDs3l8IxDItr8w0iHd6OsAyFny?=
 =?Windows-1252?Q?59XcxmV1QwyR24akUAQn6J2X18Up2dJ1Zom2UWlaDqJB0DBxsoQ7OFpg?=
 =?Windows-1252?Q?QCrGU3tANRMHW0PqV4BC75zdIINLjQM3AET2ZzJcqWFZ6wQ3PwLBeoar?=
 =?Windows-1252?Q?zikGfny3sRE/g7OMWWBrq0DnpW2/w+/nEl5XAiRgggBUwGTnvCxumnHO?=
 =?Windows-1252?Q?6hoL+4c0Hma3XKavuoHDGKtdvmYxcsJhtSMhS4HkbMLNrL3rR0l89szv?=
 =?Windows-1252?Q?WIf6AUE+5eGFm+y/EwN08yd5TMMtVFloLQLtxkn0VWfzrH6XNXUbJ450?=
 =?Windows-1252?Q?Gciczmn8JRoDFlR+V14ygOSFmBffYKwkeOZfQaS9Gkotd3ry6T8lcqII?=
 =?Windows-1252?Q?y/se1OZnpHaW0HHKxCloUo3ApwLZ+se7LM1IVV2BGwUaaMQwwp0knuCr?=
 =?Windows-1252?Q?SCjjSlwR8Linn2HMRm73ngLzF4Nk0iroqOMj0KtkjVr8FFAnHZTF8eG7?=
 =?Windows-1252?Q?xdGy7a5JOrlOBWsXwuVtMNjQJyvaQn42ff8SDF3Gj9332Js/fpfZJWpA?=
 =?Windows-1252?Q?kdiOvK1rzlyvgCTWZlaGMJnGRUcp3VKCf0rIyYO4ZjXLKeNuByBZwA?=
 =?Windows-1252?Q?=3D=3D?=
Content-Type: multipart/alternative;
	boundary="_000_SN4PR0601MB861386378F09DA8BA1E956EFFF02ASN4PR0601MB8613_"
MIME-Version: 1.0
X-OriginatorOrg: netapp.com
X-MS-Exchange-CrossTenant-AuthAs: Internal
X-MS-Exchange-CrossTenant-AuthSource: 
 SN4PR0601MB8613.namprd06.prod.outlook.com
X-MS-Exchange-CrossTenant-Network-Message-Id: 
 14da657d-f8c8-4166-351b-08db8c3d2d56
X-MS-Exchange-CrossTenant-originalarrivaltime: 24 Jul 2023 11:57:38.4570
 (UTC)
X-MS-Exchange-CrossTenant-fromentityheader: Hosted
X-MS-Exchange-CrossTenant-id: 4b0911a0-929b-4715-944b-c03745165b3a
X-MS-Exchange-CrossTenant-mailboxtype: HOSTED
X-MS-Exchange-CrossTenant-userprincipalname: 
 SwIRAYphFjjDEIgDq0xTDSclWzDn5Dw+5k9Aa/4sk83a13J4P+flnVZY5XIiZseIJQwRIE3gLsjLmf0YrVl66w==
X-MS-Exchange-Transport-CrossTenantHeadersStamped: SJ0PR06MB8678
List-Id: <pgsql-odbc.lists.postgresql.org>
List-Help: <https://lists.postgresql.org/manage/>
List-Subscribe: <https://lists.postgresql.org/manage/>
List-Post: <mailto:pgsql-odbc@lists.postgresql.org>
List-Owner: <mailto:pgsql-odbc-owner@lists.postgresql.org>
List-Archive: <https://www.postgresql.org/list/pgsql-odbc>
Archived-At: 
 <https://www.postgresql.org/message-id/SN4PR0601MB861386378F09DA8BA1E956EFFF02A%40SN4PR0601MB8613.namprd06.prod.outlook.com>
Precedence: bulk

--_000_SN4PR0601MB861386378F09DA8BA1E956EFFF02ASN4PR0601MB8613_
Content-Type: text/plain; charset="Windows-1252"
Content-Transfer-Encoding: quoted-printable

Dear Team,

We are currently trying to connect to postgresql database with target_sessi=
on_attrs, we could see that pgODBC supports libpq. Hence we tried to utiliz=
e the benefit of using target_session_attrs.


Sample connecting string used,
"Driver=3D{PostgreSQL Unicode};Server=3Dhostname1,hostname2,hostname3;Datab=
ase=3Dpostgres;Uid=3Dodbc_user;Pwd=3DWelcome;Port=3D5432;sslmode=3Drequire;=
target_session_attrs=3Dread-write;=94
But it is always connecting to hostname1 mentioned under =93Server=94 . Is =
it possible to mention the multiple hosts under parameter called =93host=94=
 as in libpq psql in the connection string and ensure it honours the target=
_session_attrs parameter value ?

--_000_SN4PR0601MB861386378F09DA8BA1E956EFFF02ASN4PR0601MB8613_
Content-Type: text/html; charset="Windows-1252"
Content-Transfer-Encoding: quoted-printable

<html xmlns:o=3D"urn:schemas-microsoft-com:office:office" xmlns:w=3D"urn:sc=
hemas-microsoft-com:office:word" xmlns:m=3D"http://schemas.microsoft.com/of=
fice/2004/12/omml" xmlns=3D"http://www.w3.org/TR/REC-html40">
<head>
<meta http-equiv=3D"Content-Type" content=3D"text/html; charset=3DWindows-1=
252">
<meta name=3D"Generator" content=3D"Microsoft Word 15 (filtered medium)">
<style><!--
/* Font Definitions */
@font-face
	{font-family:"Cambria Math";
	panose-1:2 4 5 3 5 4 6 3 2 4;}
@font-face
	{font-family:Calibri;
	panose-1:2 15 5 2 2 2 4 3 2 4;}
@font-face
	{font-family:"Segoe UI";
	panose-1:2 11 5 2 4 2 4 2 2 3;}
/* Style Definitions */
p.MsoNormal, li.MsoNormal, div.MsoNormal
	{margin:0cm;
	font-size:11.0pt;
	font-family:"Calibri",sans-serif;
	mso-ligatures:standardcontextual;
	mso-fareast-language:EN-US;}
span.EmailStyle17
	{mso-style-type:personal-compose;
	font-family:"Calibri",sans-serif;
	color:windowtext;}
.MsoChpDefault
	{mso-style-type:export-only;
	font-family:"Calibri",sans-serif;
	mso-fareast-language:EN-US;}
@page WordSection1
	{size:612.0pt 792.0pt;
	margin:72.0pt 72.0pt 72.0pt 72.0pt;}
div.WordSection1
	{page:WordSection1;}
--></style>
</head>
<body lang=3D"EN-IN" link=3D"#0563C1" vlink=3D"#954F72" style=3D"word-wrap:=
break-word">
<div class=3D"WordSection1">
<p class=3D"MsoNormal"><span lang=3D"EN-US">Dear Team,<o:p></o:p></span></p=
>
<p class=3D"MsoNormal"><span lang=3D"EN-US"><o:p>&nbsp;</o:p></span></p>
<p class=3D"MsoNormal"><span lang=3D"EN-US">We are currently trying to conn=
ect to postgresql database with target_session_attrs, we could see that pgO=
DBC supports libpq. Hence we tried to utilize the benefit of using target_s=
ession_attrs.
<o:p></o:p></span></p>
<p class=3D"MsoNormal"><span lang=3D"EN-US"><o:p>&nbsp;</o:p></span></p>
<p style=3D"mso-margin-top-alt:0cm;margin-right:0cm;margin-bottom:12.0pt;ma=
rgin-left:0cm;line-height:15.0pt;background:white;vertical-align:baseline">
<span lang=3D"EN-US" style=3D"color:black">Sample connecting string used,<b=
r>
</span><span style=3D"font-size:10.5pt;font-family:&quot;Segoe UI&quot;,san=
s-serif;color:#2F3941">&quot;Driver=3D{PostgreSQL Unicode};Server=3Dhostnam=
e1,hostname2,hostname3;Database=3Dpostgres;Uid=3Dodbc_user;Pwd=3DWelcome;Po=
rt=3D5432;sslmode=3Drequire;target_session_attrs=3Dread-write;=94<o:p></o:p=
></span></p>
<p class=3D"MsoNormal" style=3D"outline: 0px;font-variant-ligatures: normal=
;font-variant-caps: normal;orphans: 2;text-align:start;widows: 2;-webkit-te=
xt-stroke-width: 0px;text-decoration-thickness: initial;text-decoration-sty=
le: initial;text-decoration-color: initial;word-spacing:0px">
<span lang=3D"EN-US">But it is always connecting to hostname1 mentioned und=
er =93Server=94 . Is it possible to mention the multiple hosts under parame=
ter called =93host=94 as in libpq psql in the connection string and ensure =
it honours the target</span><span style=3D"font-size:10.5pt;font-family:&qu=
ot;Segoe UI&quot;,sans-serif;color:#2F3941">_session_attrs
 parameter value </span><span lang=3D"EN-US">?<o:p></o:p></span></p>
</div>
</body>
</html>

--_000_SN4PR0601MB861386378F09DA8BA1E956EFFF02ASN4PR0601MB8613_--