Received: from malur.postgresql.org ([217.196.149.56])
	by arkaria.postgresql.org with esmtps  (TLS1.3) tls
 TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384
	(Exim 4.94.2)
	(envelope-from <pgsql-odbc-owner+archive@lists.postgresql.org>)
	id 1tERSU-007LTN-I9
	for pgsql-odbc@arkaria.postgresql.org; Fri, 22 Nov 2024 11:04:18 +0000
Received: from localhost ([127.0.0.1] helo=malur.postgresql.org)
	by malur.postgresql.org with esmtp (Exim 4.94.2)
	(envelope-from <pgsql-odbc-owner+archive@lists.postgresql.org>)
	id 1tERST-007dMP-4O
	for pgsql-odbc@arkaria.postgresql.org; Fri, 22 Nov 2024 11:04:17 +0000
Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29])
	by malur.postgresql.org with esmtps  (TLS1.3) tls
 TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384
	(Exim 4.94.2)
	(envelope-from <davecramer@postgres.rocks>)
	id 1tERSS-007dMH-TJ
	for pgsql-odbc@lists.postgresql.org; Fri, 22 Nov 2024 11:04:16 +0000
Received: from pgintl.fastcrypt.com ([149.56.129.164])
	by magus.postgresql.org with esmtp (Exim 4.94.2)
	(envelope-from <davecramer@postgres.rocks>)
	id 1tERSQ-003GMn-8E
	for pgsql-odbc@lists.postgresql.org; Fri, 22 Nov 2024 11:04:16 +0000
Received: from mail-ed1-f52.google.com (mail-ed1-f52.google.com
 [209.85.208.52])
	by pgintl.fastcrypt.com (Postfix) with ESMTPSA id B11B820826
	for <pgsql-odbc@lists.postgresql.org>; Fri, 22 Nov 2024 06:04:11 -0500 (EST)
Received: by mail-ed1-f52.google.com with SMTP id
 4fb4d7f45d1cf-5ceca0ec4e7so2277514a12.0
        for <pgsql-odbc@lists.postgresql.org>;
 Fri, 22 Nov 2024 03:04:11 -0800 (PST)
X-Gm-Message-State: AOJu0YyuVF1JIQT9loiYOWvsbDu60DIi/eXwNzXd7c/MbG3XkoJiTkla
	biA+hLV6OSo0RmpxC6HHWqXptshpv7vbebCVeAUGbbGsW+TXd6H3WuVatchBndqFg5dANJ0lRaR
	WnJ4VI5gLFSaxPTU6xiNkTv/NS2I=
X-Google-Smtp-Source: 
 AGHT+IGW4bAe/snbYo5UZzXbmslkoVTZXfINveY1+22JU0iCSfNJSiEhm9SFtxwmTfW1fwVojs8MPS3a4ykFkSzW1O0=
X-Received: by 2002:a17:906:59a5:b0:a9e:6712:c27 with SMTP id
 a640c23a62f3a-aa509d0a357mr174195266b.49.1732273450412; Fri, 22 Nov 2024
 03:04:10 -0800 (PST)
MIME-Version: 1.0
References: 
 <CAAyULEDF44QTjSBwOPitDK72ppZXBsKXVwu-+vdXmhsEsfbiBQ@mail.gmail.com>
In-Reply-To: 
 <CAAyULEDF44QTjSBwOPitDK72ppZXBsKXVwu-+vdXmhsEsfbiBQ@mail.gmail.com>
From: Dave Cramer <davecramer@postgres.rocks>
Date: Fri, 22 Nov 2024 06:03:53 -0500
X-Gmail-Original-Message-ID: 
 <CADK3HHK8c+moBCHDYA8V+mT2QM2GqUqBVyr9VY=s3FccmR5e7g@mail.gmail.com>
Message-ID: 
 <CADK3HHK8c+moBCHDYA8V+mT2QM2GqUqBVyr9VY=s3FccmR5e7g@mail.gmail.com>
Subject: Re: Issue with SQLSpecialColumns
To: Abhishek Kumar <abhishek.aak0@gmail.com>
Cc: pgsql-odbc@lists.postgresql.org
Content-Type: multipart/alternative; boundary="000000000000aa7c7106277e57bc"
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/CADK3HHK8c%2BmoBCHDYA8V%2BmT2QM2GqUqBVyr9VY%3Ds3FccmR5e7g%40mail.gmail.com>
Precedence: bulk

--000000000000aa7c7106277e57bc
Content-Type: text/plain; charset="UTF-8"

Please post this on github with an example.
Thanks
Dave Cramer
www.postgres.rocks


On Fri, 22 Nov 2024 at 04:40, Abhishek Kumar <abhishek.aak0@gmail.com>
wrote:

> Hi All,
>
> In native psqlodbc driver, we do not get any results in the result set
> when we use SQLSpecialColumns with a table with unique index created with
> no primary key defined.
>
> Please let me know if there is a way to get proper results?
>
> Regards,
> Abhishek Kumar
>

--000000000000aa7c7106277e57bc
Content-Type: text/html; charset="UTF-8"
Content-Transfer-Encoding: quoted-printable

<div dir=3D"ltr"><div>Please post this on github with an example.</div><div=
>Thanks</div><div><div dir=3D"ltr" class=3D"gmail_signature" data-smartmail=
=3D"gmail_signature"><div dir=3D"ltr">Dave Cramer<div>www.postgres.rocks</d=
iv></div></div></div><br></div><br><div class=3D"gmail_quote"><div dir=3D"l=
tr" class=3D"gmail_attr">On Fri, 22 Nov 2024 at 04:40, Abhishek Kumar &lt;<=
a href=3D"mailto:abhishek.aak0@gmail.com">abhishek.aak0@gmail.com</a>&gt; w=
rote:<br></div><blockquote class=3D"gmail_quote" style=3D"margin:0px 0px 0p=
x 0.8ex;border-left:1px solid rgb(204,204,204);padding-left:1ex"><div dir=
=3D"ltr">Hi All,<br><div><br></div><div>In native psqlodbc driver, we do no=
t get any results in the result set when we use SQLSpecialColumns with a ta=
ble with unique index created with no primary key defined.</div><div><br></=
div><div>Please let me know=C2=A0if=C2=A0there is a way to get proper resul=
ts?</div><div><br></div><div>Regards,</div><div>Abhishek Kumar</div></div>
</blockquote></div>

--000000000000aa7c7106277e57bc--