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 1lR31W-0006H2-8T for pgsql-odbc@arkaria.postgresql.org; Tue, 30 Mar 2021 01:18:26 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1lR31U-00033l-SO for pgsql-odbc@arkaria.postgresql.org; Tue, 30 Mar 2021 01:18:24 +0000 Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]) by malur.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1lR31U-00033N-Gn for pgsql-odbc@lists.postgresql.org; Tue, 30 Mar 2021 01:18:24 +0000 Received: from mx07-00574e01.pphosted.com ([205.220.184.3]) by magus.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1lR31N-0000xa-Jp for pgsql-odbc@postgresql.org; Tue, 30 Mar 2021 01:18:21 +0000 Received: from pps.filterd (m0214002.ppops.net [127.0.0.1]) by mx08-00574e01.pphosted.com (8.16.0.43/8.16.0.43) with SMTP id 12U1E37s020417 for ; Tue, 30 Mar 2021 02:18:14 +0100 Received: from mail-ed1-f72.google.com (mail-ed1-f72.google.com [209.85.208.72]) by mx08-00574e01.pphosted.com with ESMTP id 37kt4yr02t-1 (version=TLSv1.2 cipher=ECDHE-RSA-AES128-GCM-SHA256 bits=128 verify=NOT) for ; Tue, 30 Mar 2021 02:18:13 +0100 Received: by mail-ed1-f72.google.com with SMTP id w18so9407316edu.5 for ; Mon, 29 Mar 2021 18:18:13 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=iress-com.20150623.gappssmtp.com; s=20150623; h=mime-version:from:date:message-id:subject:to; bh=R1pkizxxQKQKLTGZqC1nz9BJWCpEqX4CrDzXXToh/WE=; b=BGjoEe7rgjxCbyexqVGFae2wfUQUYMnPvEs2axdSCH9WdQe7w9QGV4LPUdrDCLO0dP OyDIhXXBAZ5cT7NHAi8rL+RI9J2LeBzmy2KsoNssjAgwj2WXaOq87gvOjbRumuqTi2Em gud4fynQRgJ5mu6hyJ7qy7p2N86/yvfz4qIy9L27NpgnHXocTWvbyAtCfN3VhaJ1H8Tu Molql8bWER9mTQ0kRsY/XjFN6yAkfKJ1lxJRGb331cVYsEFBO7UUx/VmiEyPweSziD5M YkhdysxbWORUkFslqsbs6o5s8hVSPOidAs0eYUDZ8otNt9c84wHqlRRdu2AdMDZOiUkY vreg== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20161025; h=x-gm-message-state:mime-version:from:date:message-id:subject:to; bh=R1pkizxxQKQKLTGZqC1nz9BJWCpEqX4CrDzXXToh/WE=; b=Amtlca++5wrmAYBkd6lq7ed8HeHh6zZE98UpYb6CmLprnUqWGr2kxEvJosPLWlcJ08 w8tRp2F3hkQZYBzXNjG4pRZzhOBL+lldKbILfljtetWW17tAsIbj1e6J01G+x+0a/4tE Sibc1ak3Ig1lyU06TnkBzUZT1o4kTCxO9DgFn45roDgcNFsrvsTdbqW9x43ecqEAuZwy iC3FJxvnVdNwDuF0amo9gvsUCNbYOc2O7KlZxXMRjC3eQc9IynjIIboO7mMePEqMEBns dorCzEWjX3adwauVOw+ASv6gGGKZrKr0h2VF7mExjWKwcUDfQ1l17kiWCHfR/xwb8QqX 4R6w== X-Gm-Message-State: AOAM531AphN9/xI5DadxJ2E0I5xDPFIHuyYgTqZzjxDy/4EBAwdXc5Wt mvJ/lNpoIL3X5WqGrJkjdDZVfqw65qA2P2JYO3KsOesQzHkDhXzkSQCsvgwPXrB+PSQPGOf0v7y AB8CXQClF+zIcmuF2GgwgtrwlARDQLRVV9HzS4ITDus4KYw== X-Received: by 2002:a17:906:a1c8:: with SMTP id bx8mr30404234ejb.381.1617067093413; Mon, 29 Mar 2021 18:18:13 -0700 (PDT) X-Google-Smtp-Source: ABdhPJwpRvFvO36BlNB5iax4CeVEKmTDa0S+X1J8pnUL8a7u6VvJq2tg6fai0oGy3D2Mkeqwcme5jGCnvIjb X-Received: by 2002:a17:906:a1c8:: with SMTP id bx8mr30404226ejb.381.1617067093205; Mon, 29 Mar 2021 18:18:13 -0700 (PDT) Received: from eu2.smtp.exclaimer.net (eu2.smtp.exclaimer.net. [52.169.0.179]) by smtp-relay.gmail.com with ESMTPS id t24sm520231eji.29.2021.03.29.18.18.12 for (version=TLS1_2 cipher=ECDHE-ECDSA-AES128-GCM-SHA256 bits=128/128); Mon, 29 Mar 2021 18:18:13 -0700 (PDT) X-Relaying-Domain: iress.com Received: from mail-wr1-f72.google.com (209.85.221.72) by eu2.smtp.exclaimer.net (52.169.0.179) with Exclaimer Signature Manager ESMTP Proxy eu2.smtp.exclaimer.net (tlsversion=TLS12, tlscipher=TLS_ECDHE_WITH_AES256_SHA1); Tue, 30 Mar 2021 01:18:12 +0000 X-ExclaimerHostedSignatures-MessageProcessed: true X-ExclaimerProxyLatency: 4880801 X-ExclaimerImprintLatency: 2130731 X-ExclaimerImprintAction: 5ec9a161d1b842bd8debe79f35aad65e Received: by mail-wr1-f72.google.com with SMTP id m13so8322233wri.16 for ; Mon, 29 Mar 2021 18:18:12 -0700 (PDT) X-Received: by 2002:a5d:604b:: with SMTP id j11mr21664837wrt.424.1617067091888; Mon, 29 Mar 2021 18:18:11 -0700 (PDT) X-Received: by 2002:a5d:604b:: with SMTP id j11mr21664827wrt.424.1617067091560; Mon, 29 Mar 2021 18:18:11 -0700 (PDT) MIME-Version: 1.0 From: Adrian Grucza Date: Tue, 30 Mar 2021 12:18:00 +1100 Message-ID: Subject: Contribution to enable refcursor support To: pgsql-odbc@postgresql.org Content-Type: multipart/alternative; boundary="00000000000092215205beb6c558" X-Proofpoint-ORIG-GUID: TBTGzIgp0VQFQlr3rxbCxORk3cNCCJKv X-Proofpoint-GUID: TBTGzIgp0VQFQlr3rxbCxORk3cNCCJKv 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. --00000000000092215205beb6c558 Content-Type: text/plain; charset=utf-8 Content-Transfer-Encoding: quoted-printable Hi, I'm working on a patch for psqlODBC that I'd like to contribute. Currently there is code in this project that automatically fetches rows from returned cursors, but it's not compiled in because the REFCUR_SUPPORT symbol is not defined. My patch will: 1. Replace the REFCUR_SUPPORT symbol with a proper driver setting (defaulting to off) 2. Enhance the code to allow fetching of multiple refcursors (instead of just one) 3. Allow refcursors to be used in conjunction with regular output parameter= s 4. Include regression tests What is the best way to make this contribution? I have a postgresql.org community account, so if I could get the appropriate permissions on the psqlodbc repository then I could push my changes to be reviewed (once they are done). Regards, Adrian Grucza Adrian Grucza Technical Lead Tel: +61390185800 Mobile: +61432755054 adrian.grucza@iress.com www.iress.com Level 16, 385 Bourke Street, Melbourne, Victoria, 3000 The contents of this email originated from Iress. For this purpose Iress in= cludes Iress Limited and/or any of its subsidiaries, holding companies and = trading entities. =E2=80=8BIf you have received this email in error please = notify the sender immediately and delete this email. nosig --00000000000092215205beb6c558 Content-Type: text/html; charset=utf-8 Content-Transfer-Encoding: quoted-printable
Hi,

I'm working o= n a patch for psqlODBC that I'd like to contribute. Currently there is = code in this project that automatically fetches rows from returned cursors,= but it's not compiled in because=C2=A0the REFCUR_SUPPORT symbol is not= defined.=C2=A0My patch will:

1. Replace the REFCU= R_SUPPORT symbol with a proper driver setting (defaulting to off)
2. Enhance the code to allow fetching of multiple refcursors (instead of j= ust one)
3. Allow refcursors to be used in conjunction=C2=A0with = regular output parameters
4. Include regression tests
<= br>
What is the best way to make this contribution? I have a postgresql.org community account, so if I= could get the appropriate permissions on the psqlodbc repository then I co= uld push my changes to be reviewed (once they are done).

Regards,
Adrian Grucza

=
<= td align=3D"left" style=3D"vertical-align:top;font-family:Arial;">www.= iress.com
3D"iress.com"
Adrian Grucza​  
Technical Lead
Tel: +613901= 85800
Mobile: +614327= 55054
adrian.grucz= a@iress.com
= Level 16, 385 Bourke Street,
 Melbou= rne, Victoria, 3000
The contents of this email originated from Iress. Fo= r this purpose Iress includes Iress Limited and/or any of its subsidiaries,= holding companies and trading entities. ​If you have received this e= mail in error please notify the sender immediately and delete this email.&n= bsp;
nosig
--00000000000092215205beb6c558--