BUG #14465: cursor for insert into select ... returning cann't streaming fetch?

From: digoal(at)126(dot)com
To: pgsql-bugs(at)postgresql(dot)org
Subject: BUG #14465: cursor for insert into select ... returning cann't streaming fetch?
Date: 2016-12-14 02:56:53
Message-ID: 20161214025653.14892.72446@wrigleys.postgresql.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

The following bug has been logged on the website:

Bug reference: 14465
Logged by: Zhou Digoal
Email address: digoal(at)126(dot)com
PostgreSQL version: 9.6.1
Operating system: CentOS 6.x x64
Description:

HI,
when i write a plpgsql return refcursor.
the refcursor is a ```insert into .. select .. from .. returning *;```
query.
but when i use auto_explain DEBUG it, i found the fetch after insert end,
not stream , insert and fetch the same time coordinat.
can PostgreSQL improve it?

Responses

Browse pgsql-bugs by date

  From Date Subject
Next Message David G. Johnston 2016-12-14 03:57:00 Re: BUG #14465: cursor for insert into select ... returning cann't streaming fetch?
Previous Message Tom Lane 2016-12-13 21:37:38 Re: BUG #14463: refcursor cann't used with array or variadic parameter?