Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1qBwJH-0007xx-Cf for pgsql-odbc@arkaria.postgresql.org; Wed, 21 Jun 2023 11:47:39 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1qBwJG-0000Zo-B1 for pgsql-odbc@arkaria.postgresql.org; Wed, 21 Jun 2023 11:47:38 +0000 Received: from makus.postgresql.org ([2001:4800:3e1:1::229]) by malur.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1qBalS-0006e9-Sb for pgsql-odbc@lists.postgresql.org; Tue, 20 Jun 2023 12:47:18 +0000 Received: from gosford.compton.nu ([2001:8b0:bd:1:e2d5:5eff:fee7:6698]) by makus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1qBalQ-003F9m-7f for pgsql-odbc@postgresql.org; Tue, 20 Jun 2023 12:47:17 +0000 DKIM-Signature: v=1; a=rsa-sha256; q=dns/txt; c=relaxed/relaxed; d=compton.nu; s=20200130; h=To:Subject:From:MIME-Version:Date:Message-ID:Content-Type: Sender:Reply-To:Cc:Content-Transfer-Encoding:Content-ID:Content-Description: Resent-Date:Resent-From:Resent-Sender:Resent-To:Resent-Cc:Resent-Message-ID: In-Reply-To:References:List-Id:List-Help:List-Unsubscribe:List-Subscribe: List-Post:List-Owner:List-Archive; bh=4blOkWNW2d/EOXhKBr0y8xaqhTEqf2Id3GyDRfdP30o=; i=tom@compton.nu; t=1687265236; x=1688474836; b=OW0Y/25zcOzwc0HnHKYRmb7jT8x+qqZZQibPXAjMn3wi0uv 6S66A8Ua78mpkRAOqX7rpmYq8qO4PBe6XXNZd6k+yE0umVaoMyO/qwIXBcEof/ySaVfHQkyhcv0hI IeX3OCQuK3BrSg5P8YjU7PxzMKETlJJLzjNPiblPTvfMriG3M8Iwgh4aqMuYwEpWHwXySX/K0vQx1 C7bxp4BwQgY3vPUdiLFnXKBRjDoG1+/i+TL7Zj7yzNeDNS3NQeB1LIcXxQO4LuliMKeYdUNAYvSxk XVrzuXzMYQOI3N0qhGkG0y7DpMoR5pj1q0cLWGB2AYeEM9HKUFw8v9SWbRfPkskg==; Authentication-Results: gosford.compton.nu; iprev=pass (bericote.compton.nu) smtp.remote-ip=2001:8b0:bd:1:1881:14ff:fe46:3cc7 Received: from bericote.compton.nu ([2001:8b0:bd:1:1881:14ff:fe46:3cc7]:59338) by gosford.compton.nu with esmtps (TLS1.3) tls TLS_AES_256_GCM_SHA384 (Exim 4.96) (envelope-from ) id 1qBalM-007ZAJ-01; Tue, 20 Jun 2023 13:47:12 +0100 Received: from bristol.uk.cyberscience.com ([2001:8b0:ff84:1:5cba:2dff:fe82:71af]:35840) by bericote.compton.nu with esmtps (TLS1.3) tls TLS_AES_128_GCM_SHA256 (Exim 4.96) (envelope-from ) id 1qBalL-00CLh9-2Z for pgsql-odbc@postgresql.org; Tue, 20 Jun 2023 13:47:11 +0100 Content-Type: multipart/mixed; boundary="------------pBjIA4Nwc6NtmBlXsV2ROOwz" Message-ID: <4322270e-23f6-ba4e-086b-07d01944e3b7@compton.nu> Date: Tue, 20 Jun 2023 13:47:11 +0100 MIME-Version: 1.0 User-Agent: Mozilla/5.0 (X11; Linux x86_64; rv:102.0) Gecko/20100101 Thunderbird/102.12.0 From: Tom Hughes Subject: [PATCH] Allow catalog (database) enumeration with SQLTables To: pgsql-odbc@postgresql.org Content-Language: en-US List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk This is a multi-part message in MIME format. --------------pBjIA4Nwc6NtmBlXsV2ROOwz Content-Type: text/plain; charset=UTF-8; format=flowed Content-Transfer-Encoding: 7bit The attached patch fixed SQLTables to make enumeration of databases (catalogs in ODBC speak) work. Tom -- Tom Hughes (tom@compton.nu) http://compton.nu/ --------------pBjIA4Nwc6NtmBlXsV2ROOwz Content-Type: text/x-patch; charset=UTF-8; name="all-catalogs.patch" Content-Disposition: attachment; filename="all-catalogs.patch" Content-Transfer-Encoding: base64 Y29tbWl0IDAyYWM3MTMwODY1NzY1YjVkYzEwODBmOTkzOTlhYzMzOTE0NWQ2ODUKQXV0aG9y OiBUb20gSHVnaGVzIDx0b21AY29tcHRvbi5udT4KRGF0ZTogICBXZWQgSnVuIDE0IDEzOjA3 OjMzIDIwMjMgKzAxMDAKCiAgICBNYWtlIGNhdGFsb2cgZW51bWVyYXRpb24gd2l0aCBTUUxU YWJsZXMgd29yay4KCmRpZmYgLS1naXQgYS9pbmZvLmMgYi9pbmZvLmMKaW5kZXggMzdmMWQ0 OS4uMjNkYjVhMyAxMDA2NDQKLS0tIGEvaW5mby5jCisrKyBiL2luZm8uYwpAQCAtMTg5OCw3 ICsxODk4LDggQEAgcmV0cnlfcHVibGljX3NjaGVtYToKIAlpbml0UFFFeHBCdWZmZXIoJnRh Ymxlc19xdWVyeSk7CiAjZGVmaW5lCXJldHVybglET05UX0NBTExfUkVUVVJOX0ZST01fSEVS RT8/PwogCWlmIChsaXN0X2NhdCkKLQkJYXBwZW5kUFFFeHBCdWZmZXJTdHIoJnRhYmxlc19x dWVyeSwgInNlbGVjdCBOVUxMLCBOVUxMLCBOVUxMIik7CisJCWFwcGVuZFBRRXhwQnVmZmVy U3RyKCZ0YWJsZXNfcXVlcnksICJzZWxlY3QgZGF0bmFtZSwgTlVMTCwgTlVMTCIKKwkJCSIg ZnJvbSBwZ19jYXRhbG9nLnBnX2RhdGFiYXNlIik7CiAJZWxzZSBpZiAobGlzdF90YWJsZV90 eXBlcykKIAl7CiAJCS8qCkBAIC0yMTY1LDcgKzIxNjYsOSBAQCByZXRyeV9wdWJsaWNfc2No ZW1hOgogCQl7CiAJCQl0dXBsZSA9IFFSX0FkZE5ldyhyZXMpOwogCi0JCQlpZiAobGlzdF9j YXQgfHwgIWxpc3Rfc29tZSkKKwkJCWlmIChsaXN0X2NhdCkKKwkJCQlzZXRfdHVwbGVmaWVs ZF9zdHJpbmcoJnR1cGxlW1RBQkxFU19DQVRBTE9HX05BTUVdLCB0YWJsZV9uYW1lKTsKKwkJ CWVsc2UgaWYgKCFsaXN0X3NvbWUpCiAJCQkJc2V0X3R1cGxlZmllbGRfc3RyaW5nKCZ0dXBs ZVtUQUJMRVNfQ0FUQUxPR19OQU1FXSwgQ3VyckNhdChjb25uKSk7CiAJCQllbHNlCiAJCQkJ c2V0X3R1cGxlZmllbGRfbnVsbCgmdHVwbGVbVEFCTEVTX0NBVEFMT0dfTkFNRV0pOwo= --------------pBjIA4Nwc6NtmBlXsV2ROOwz--