public inbox for [email protected]  

help / color / mirror / Atom feed

From: Inoue,Hiroshi <[email protected]>
To: Adrian Grucza <[email protected]>
Cc: [email protected]
Subject: Re: [PATCH] Automatic fetching of refcursors
Date: Mon, 17 May 2021 15:35:47 +0900
Message-ID: <CAFGcedUpECDcXM_1KJXVc=r=CAmkvP+Ajojy02fsOfJA2Wg3bQ@mail.gmail.com> (raw)
In-Reply-To: <CADF4wWrq1Oex-=eqS5-Wsb83oOPW1z3NFa3wUKzDwzicrip3yQ@mail.gmail.com>
References: <CADF4wWrq1Oex-=eqS5-Wsb83oOPW1z3NFa3wUKzDwzicrip3yQ@mail.gmail.com>

Hi Adrian,

I would take care of your patches.

Thanks.
Hiroshi Inoue

2021年5月17日(月) 11:21 Adrian Grucza <[email protected]>:

> Hi all,
>
> I've created a patch that enables automatic fetching of refcursors from a
> function/procedure. Functions/procedures can return one or more refcursors,
> and the client application can then consume them the way multiple result
> sets are normally consumed via ODBC.
>
> Below is a summary of the attached patches:
>
> 0001 (`regress.ps1` changes unrelated to refcursors)
>   * Allow installation and testing of a debug build of the driver (useful
> for debugging)
>   * Fixed a bug in `regress.ps1` where accepting the default password of
> `postgres` did not work
>
> 0002
>   * Added a FetchRefcursors setting
>   * When FetchRefcursors is enabled, executes some refcursor code in
> `statement.c` that already existed but was not compiled in due to
> REFCUR_SUPPORT not being #defined
>
> 0003
>   * Enhanced refcursor code to support multiple refcursors
>   * Fixed an issue where output parameter bindings were not processed when
> using refcursors
>   * Added a `fetch-refcursors` regression test
>
> Notes:
>   * Client application must execute the statement in a transaction to
> avoid cursors being closed prematurely (i.e. turn auto-commit off)
>   * Works with both ODBC CALL and PostgreSQL CALL syntaxes
>   * A search through the mailing list archive shows that refcursor support
> is a feature that multiple people have wanted
>
> Regards,
> [image: iress.com] <https://www.iress.com/;
> Adrian Grucza​
> Technical Lead
> Tel:  +61390185800
> *[email protected]* <[email protected]>
> *www.iress.com* <https://www.iress.com/;
> Level 16, 385 Bourke Street,  Melbourne,  Victoria,  3000
> The contents of this email originated from Iress. For this purpose Iress
> includes Iress Limited and/or any of its subsidiaries, holding companies
> and trading entities. ​If you have received this email in error please
> notify the sender immediately and delete this email.
> nosig
>

view thread (3+ messages)  latest in thread

reply

Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients using the --to and --cc options:
  reply via email

  To: [email protected]
  Cc: [email protected], [email protected], [email protected]
  Subject: Re: [PATCH] Automatic fetching of refcursors
  In-Reply-To: <CAFGcedUpECDcXM_1KJXVc=r=CAmkvP+Ajojy02fsOfJA2Wg3bQ@mail.gmail.com>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by agora; see mirroring instructions
for how to clone and mirror all data and code used for this inbox