On Wed, Feb 28, 2018 at 10:27:23AM +1300, Thomas Munro wrote:
Tom K, if you need a workaround before 10.4 comes out in May[1], you
could try selecting the whole transition table into a CTE up front.
Something like WITH my_copy AS (SELECT * FROM new_table) SELECT * FROM
my_copy UNION ALL SELECT *
On Tue, Feb 27, 2018 at 03:58:14PM -0500, Tom Lane wrote:
Thomas Munro writes:
Here's a new version with tuplestore_select_read_pointer() added in
another place where it was lacking, and commit message. Moving to
-hackers, where patches go.
Pushed, along with a regression test based on your
On Wed, Feb 28, 2018 at 9:58 AM, Tom Lane wrote:
> Thomas Munro writes:
>> Here's a new version with tuplestore_select_read_pointer() added in
>> another place where it was lacking, and commit message. Moving to
>> -hackers, where patches go.
>
> Pushed, along with a regression test based on you
Thomas Munro writes:
> Here's a new version with tuplestore_select_read_pointer() added in
> another place where it was lacking, and commit message. Moving to
> -hackers, where patches go.
Pushed, along with a regression test based on your example.
Unfortunately, this came in a bit too late for
On Tue, Feb 27, 2018 at 4:18 AM, Tom Kazimiers wrote:
> On Mon, Feb 26, 2018 at 11:15:44PM +1300, Thomas Munro wrote:
>> On Sat, Feb 24, 2018 at 4:47 PM, Tom Kazimiers
>> wrote:
>> Thanks for the reproducer. Yeah, that seems to be a bug.
>> nodeNamedTuplestorescan.c allocates a new read pointer
Hi Thomas,
On Mon, Feb 26, 2018 at 11:15:44PM +1300, Thomas Munro wrote:
On Sat, Feb 24, 2018 at 4:47 PM, Tom Kazimiers wrote:
Thanks for the reproducer. Yeah, that seems to be a bug.
nodeNamedTuplestorescan.c allocates a new read pointer for each
separate scan of the named tuplestore, but it
On Sat, Feb 24, 2018 at 4:47 PM, Tom Kazimiers wrote:
> I am on Postgres 10.2 and try to get a statement level trigger to work that
> is executed after UPDATE statements on a particular table. This trigger
> references both the old and new transition table and for some reason I am
> unable to refe
Hi all,
I am on Postgres 10.2 and try to get a statement level trigger to work
that is executed after UPDATE statements on a particular table. This
trigger references both the old and new transition table and for some
reason I am unable to reference each transition table multiple times in
a C
