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 ) id 1tEQ9Q-007ENP-Kl for pgsql-odbc@arkaria.postgresql.org; Fri, 22 Nov 2024 09:40:32 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.94.2) (envelope-from ) id 1tEQ9N-007Cc5-MA for pgsql-odbc@arkaria.postgresql.org; Fri, 22 Nov 2024 09:40:29 +0000 Received: from makus.postgresql.org ([2001:4800:3e1:1::229]) by malur.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1tEQ9N-007Cbx-8D for pgsql-odbc@lists.postgresql.org; Fri, 22 Nov 2024 09:40:29 +0000 Received: from mail-lj1-x232.google.com ([2a00:1450:4864:20::232]) by makus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_128_GCM_SHA256 (Exim 4.94.2) (envelope-from ) id 1tEQ9K-003CAS-BP for pgsql-odbc@lists.postgresql.org; Fri, 22 Nov 2024 09:40:27 +0000 Received: by mail-lj1-x232.google.com with SMTP id 38308e7fff4ca-2fb599aac99so22000981fa.1 for ; Fri, 22 Nov 2024 01:40:26 -0800 (PST) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20230601; t=1732268424; x=1732873224; darn=lists.postgresql.org; h=to:subject:message-id:date:from:mime-version:from:to:cc:subject :date:message-id:reply-to; bh=637/2yQKCGaDoXsrfTGA7IpErDM14l2dMAxZOV0m6S4=; b=WhY4hfymPw1xVtJl0l3LlF+QRBD3WZ88/lB/754maxF+9xzNHWtBOcLjHNF1mman5A hLN9J1gLmD1YiMdEfO9HPfigAiIulA9Ue08MGRnVpwULfWyuC6JcHa+hF9pimVCv+O9s JBHXhUqajbpUMDqtK/H8MhAC2MeMbCoCNVspQtMT2CN4H+/7J7ZHC6jq1n4VmQZEgErZ h7uJkIk7UbwKYrHrp9VsMfuyl1CJ0I24bIzmM+7642CWE76L8FyC/nBUJj3FRRvNDaoc PDgQOGNBq+auDT9dW+Uxtatc3CaHGlGMi2LRaYPsGuqkEqDl6quw2xAwEL7Q0KMZxdh/ lZXg== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20230601; t=1732268424; x=1732873224; h=to:subject:message-id:date:from:mime-version:x-gm-message-state :from:to:cc:subject:date:message-id:reply-to; bh=637/2yQKCGaDoXsrfTGA7IpErDM14l2dMAxZOV0m6S4=; b=A/sKbsctlWqZ/5nqYI2ylBe/APaDg9bY4po8Ec2iwcYMcVWzWqKBQUTgKqchFHf0c/ tzK441ceSCJ/6eAooSH2LgYgAq51rZpNDh/nEAKKlSYbrxXjmslyjGiek9hSJ3e2Ajq1 Vj7b7lHg9WrLK3Q6wwCx552gDh6eQTMBsB5BVstktELUY/hMad9wgOSuGlw6d+CeD5ux 7BWl16ZwvK3+gsmVD+bc++ItjvjqDuZrORubyXCg2+Bczre9ALTpM8cYLSPUii41t7le 25nfFO7xvI/dZ0jNJR40zJn5NJFf25w+hIOJB4vEneINWPTbkCReVBcPx9nZwVo+YpsT qY2A== X-Gm-Message-State: AOJu0Yx3Nbltlx3ZxobsGLdZqoiVu0Z/Ej4juIW0uTp+gtExP+GHVRyf nQ9XtmXc2+wlLg9mJ1n+eCNo7Dcu+yipmGB0x/qoGeRPWLu0NK54Q/RdTQ7ca+CrBz9ss3IrIv/ O9wvo7H3hqx6yF/+R6CJcAVUVGYTL8HJYWg== X-Gm-Gg: ASbGnctzqdq9uk4IgqpV1BKp+mJnSEGkP7DwxHwwCBj+9rBCJa8foKQrH/E2VvODtfX Yi5tSr9LQ/lYHHoWvkJoxAqhV5aM= X-Google-Smtp-Source: AGHT+IHTyC1m1Tcgs/FckWwFVMTD3soGLVSgdjnW811uBlmMjhQjCM2KUWO6mbZrvqWh8NfTMA9/dmsp53jkBE6H+Qk= X-Received: by 2002:a05:651c:88c:b0:2fa:d67a:ada7 with SMTP id 38308e7fff4ca-2ffa713291cmr11130571fa.23.1732268423938; Fri, 22 Nov 2024 01:40:23 -0800 (PST) MIME-Version: 1.0 From: Abhishek Kumar Date: Fri, 22 Nov 2024 15:10:12 +0530 Message-ID: Subject: Issue with SQLSpecialColumns To: pgsql-odbc@lists.postgresql.org Content-Type: multipart/alternative; boundary="00000000000010900606277d2caf" List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk --00000000000010900606277d2caf Content-Type: text/plain; charset="UTF-8" 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 --00000000000010900606277d2caf Content-Type: text/html; charset="UTF-8" Content-Transfer-Encoding: quoted-printable
Hi All,

In native psqlodbc driver, = we do not get any results in the result set when we use SQLSpecialColumns w= ith a table with unique index created with no primary key defined.

Please let me know=C2=A0if=C2=A0there is a way to get prop= er results?

Regards,
Abhishek Kumar
--00000000000010900606277d2caf--