On Sat, 27 Jul 2024 at 19:06, Tatsuo Ishii wrote:
> > Yes, sorry, I should have said one can not create a with hold portal
> using
> > the BIND command
>
> Ok.
>
> It would be possible to add a new parameter to the BIND command to
> create such a portal. But it needs some changes to the existing
> Yes, sorry, I should have said one can not create a with hold portal using
> the BIND command
Ok.
It would be possible to add a new parameter to the BIND command to
create such a portal. But it needs some changes to the existing
protocol definition and requires protocol version up, which is a m
Dave Cramer writes:
> On Sat, 27 Jul 2024 at 01:55, Tatsuo Ishii wrote:
>>> So while the API's are "virtually" identical AFAICT there is no way to
>>> create a "WITH HOLD" portal ?
> Yes, sorry, I should have said one can not create a with hold portal using
> the BIND command
Yeah. The two API
Dave Cramer
On Sat, 27 Jul 2024 at 01:55, Tatsuo Ishii wrote:
> > So while the API's are "virtually" identical AFAICT there is no way to
> > create a "WITH HOLD" portal ?
>
> I am not sure if I fully understand your question but I think you can
> create a portal with "WITH HOLD" option.
>
> BEG
> So while the API's are "virtually" identical AFAICT there is no way to
> create a "WITH HOLD" portal ?
I am not sure if I fully understand your question but I think you can
create a portal with "WITH HOLD" option.
BEGIN;
DECLARE c CURSOR WITH HOLD FOR SELECT * FROM generate_series(1,10);
(of c
On Thu, 25 Jul 2024 at 17:52, Dave Cramer wrote:
>
>
> On Thu, 25 Jul 2024 at 16:19, David G. Johnston <
> david.g.johns...@gmail.com> wrote:
>
>> On Thursday, July 25, 2024, Dave Cramer wrote:
>>
>> May not make a difference but…
>>
>>
>>> 2024-07-25 15:55:39 FINEST org.postgresql.core.v3.Query
On Thu, 25 Jul 2024 at 16:19, David G. Johnston
wrote:
> On Thursday, July 25, 2024, Dave Cramer wrote:
>
> May not make a difference but…
>
>
>> 2024-07-25 15:55:39 FINEST org.postgresql.core.v3.QueryExecutorImpl
>> sendSimpleQuery FE=> SimpleQuery(query="declare C_3 CURSOR WITHOUT HOLD
>> FOR
On Thursday, July 25, 2024, Dave Cramer wrote:
May not make a difference but…
> 2024-07-25 15:55:39 FINEST org.postgresql.core.v3.QueryExecutorImpl
> sendSimpleQuery FE=> SimpleQuery(query="declare C_3 CURSOR WITHOUT HOLD
> FOR SELECT * FROM testsps WHERE id = 2")
>
You named the cursor c_3 (
Hi Tom,
On Wed, 8 Nov 2023 at 06:02, Dave Cramer wrote:
>
> Dave Cramer
>
>
> On Tue, 7 Nov 2023 at 10:26, Tom Lane wrote:
>
>> Dave Cramer writes:
>> > If we use a Portal it is possible to open the portal and do a describe
>> and
>> > then Fetch N records.
>>
>> > Using a Cursor we open t
Dave Cramer
On Tue, 7 Nov 2023 at 10:26, Tom Lane wrote:
> Dave Cramer writes:
> > If we use a Portal it is possible to open the portal and do a describe
> and
> > then Fetch N records.
>
> > Using a Cursor we open the cursor. Is there a corresponding describe and
> a
> > way to fetch N record
Dave Cramer writes:
> If we use a Portal it is possible to open the portal and do a describe and
> then Fetch N records.
> Using a Cursor we open the cursor. Is there a corresponding describe and a
> way to fetch N records without getting the fields each time. Currently we
> have to send the SQL
Greetings,
If we use a Portal it is possible to open the portal and do a describe and
then Fetch N records.
Using a Cursor we open the cursor. Is there a corresponding describe and a
way to fetch N records without getting the fields each time. Currently we
have to send the SQL "fetch N" and we
12 matches
Mail list logo